Thanks for your input guys - I had to put this problem on hold for a few
days.
In case it helps anyone in a similar boat, this problem seems to have been
due to a umask of 0027. Changing to 022 seems to have fixed it.
Cheers,
Simon Kinsella
-Original Message-
From: [EMAIL PROTECTED
-L.
---
Tried adding " -L /usr/local/share/postgresql/" (and removing -E) but no
joy.
The .../share/postgresql/ files do exist. Not sure why this is happening
now, it's never happened before. I've got a horrible feeling it's something
embarrassingly simple but I'm s
Thanks for your help Tom - I've got it sorted now by setting
timezone='GMT0DST' in the conf file.
Simon.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 26, 2006 5:16 PM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [
template1=# show timezone;
TimeZone
--
GMT0
Thanks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, October 26, 2006 4:53 PM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres timestamps are
tting
This is happening on two machines, but not on a third. All with same version
and config. Not sure where to start - any clues? Sounds like some time zone
or daylight saving thing...?
---
Simon Kinsella
---(end of broadcast)---
TIP 9: In vers
