| 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: | Whole Thread | Raw Message | 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??? |