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

Since this is my first post here: Hi All!

I've been discussing this issue at the postgresql mlist and this is
story so far:

When configuring a Slony cluster I get the infamous 'ERROR:  invalid
input syntax for type timestamp: "Mon Jun 29 13:00:36.628805 2009 WEST"'

I know that this is a timezone setting issue.
In my case I have my system set to 'Atlantic/Madeira' and system clock
set to UTC.

My postgresql.conf has the same setting ('Atlantic/Madeira')
Postgresql ver. 8.3.7 on Fedora 8

This is what's defined in postgresql.conf

datestyle = 'iso, ymd'
timezone = 'Atlantic/Madeira'

I've altered '/usr/share/pgsql/timezonesets/Default' to include the
'WEST' abbrev. from
'/usr/share/pgsql/timezonesets/Atlantic.txt':

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

No go after all the above :(

Could someone *please* share some pointers on how to overcome this
annoying issue?

TIA,

- --
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKSOcl2FH5GXCfxAsRAjRfAJ44Sb9+Fj39GxYBocwTrAVlPTlpIwCdEQQx
37g6+Oi4K7npF4YxGp8bL5M=
=dMxC
-----END PGP SIGNATURE-----