On 29/06/2009 16:39, Pedro Doria Meunier wrote:
> btw: do you happen to know of a Slony mailing list?
Here you go:
http://lists.slony.info/mailman/listinfo
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom,
This is what I have in '/usr/share/pgsql/timezonesets/Atlantic.txt':
WEST 3600 D # Western Europe Summer Time
# (Atlantic/Canary)
# (Atlantic/Faeroe)
# (Atlantic/Madeira)
Pedro Doria Meunier writes:
> This is what's defined in postgresql.conf
> datestyle = 'iso, ymd'
> timezone = 'Atlantic/Madeira'
Hmm. WET/WEST are the zone abbreviations for that zone, all right,
but I don't understand why they're being emitted if you have that
datestyle setting. Maybe somethi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks Tom for your thoughts :)
I tried what you suggested to no avail :-(
Looking at this more closely I see this format when the error arises:
"Mon Jun 29 15:28:10.952151 2009 WEST"
Curiously enough this is what the following command throws out of
Pedro Doria Meunier 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 datest
-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'