Slony-I timezone setting

Поиск
Список
Период
Сортировка
От Pedro Doria Meunier
Тема Slony-I timezone setting
Дата
Msg-id 4A48B693.7070502@netmadeira.com
обсуждение исходный текст
Ответы Re: Slony-I timezone setting  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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-----


В списке pgsql-general по дате отправления:

Предыдущее
От: durumdara
Дата:
Сообщение: Python client + select = locked resources???
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: Replication and coding good practices