Slony-I timezone setting

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-----

Responses

Browse pgsql-general by date

  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???