Re: Slony-I timezone setting

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom,

This is what I have in '/usr/share/pgsql/timezonesets/Atlantic.txt':

WEST 3600 D # Western Europe Summer Time
# (Atlantic/Canary)
# (Atlantic/Faeroe)
# (Atlantic/Madeira)
# (Europe/Lisbon)

I copied this portion into '/usr/share/pgsql/timezonesets/Default' and
restarted the service.
Still no go :(

I even tried alter user user-slony set timezone='WEST';
After the mods this what the query gives:
ERROR: unrecognized time zone name: "WEST"

And this is when I ran out of ideas...

btw: do you happen to know of a Slony mailing list?

TIA,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Tom Lane wrote:
> Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> writes:
>> This is what's defined in postgresql.conf
>
>> datestyle = 'iso, ymd' timezone = 'Atlantic/Madeira'
>
> Hmm. WET/WEST are the zone abbreviations for that zone, all right,
> but I don't understand why they're being emitted if you have that
> datestyle setting. Maybe something is overriding the datestyle for
> some dumb reason?
>
> Anyway, a look at the default timezone abbrevs file shows that it
> recognizes WETDST not WEST. You might care to add WEST as an
> accepted abbrev too.
>
> regards, tom lane
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKSOBE2FH5GXCfxAsRAr+8AJsHvnlpWWZw7rVb2Kp9A70Q4/DJPwCfXbrb
L+n1Km17aMA7AzhUe7IqvPs=
=THOj
-----END PGP SIGNATURE-----