Re: Slony-I timezone setting - Mailing list pgsql-general

From Pedro Doria Meunier
Subject Re: Slony-I timezone setting
Date
Msg-id 4A48E04D.6060808@netmadeira.com
Whole thread Raw
In response to Re: Slony-I timezone setting  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Slony-I timezone setting
List pgsql-general
-----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@netmadeira.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-----


pgsql-general by date:

Previous
From: Lennin Caro
Date:
Subject: Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
Next
From: Andreas Wenk
Date:
Subject: GIN and GiST index - more in depth info