Postgres Pro
Downloads
Home   >   mailing lists

Re: Slony-I timezone setting - Mailing list pgsql-general

From Tom Lane
Subject Re: Slony-I timezone setting
Date
Msg-id 11460.1246284690@sss.pgh.pa.us
Whole thread Raw
In response to Slony-I timezone setting  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Responses Re: Slony-I timezone setting
List pgsql-general
Tree view 
Pedro Doria Meunier <pdoria@netmadeira.com> writes:
> 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"'

You need to make the timezone_abbreviations configuration on the slave
match that on the master.  Alternatively, set datestyle to ISO so that
a less ambiguous timestamp format is used.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: another can't connect
Next
From: Joshua Tolley
Date:
Subject: Re: Free OLAP software for Postgres databas