From: | Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> |
---|---|
To: | Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Slony-I timezone setting |
Date: | 2009-06-29 12:41:55 |
Message-ID: | 4A48B693.7070502@netmadeira.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi All,
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 UTC.
My postgresql.conf has the same setting ('Atlantic/Madeira')
Postgresql ver. 8.3.7 on Fedora 8
I feel reluctant to follow Slony's 'Best practices' depicted in the
(cough) fine manual as it would mean losing any DST awareness ...
Any thoughts appreciated,
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
iD8DBQFKSLaI2FH5GXCfxAsRAkPpAJ48qThWwTWwwIRK802T/Tyn9ztyvgCfWjw3
kkUnMNb1hmKNYZ5dmM04C7U=
=3XOr
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Sergio Borgonovo | 2009-06-29 12:46:42 | Re: Replication and coding good practices |
Previous Message | durumdara | 2009-06-29 11:36:59 | Python client + select = locked resources??? |