Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Craig Ayliffe
Hi All, I was in fact out-of-date with patches, and have fixed that - which has brought the zone files up to date. Will definitely be looking to upgrade all servers to 8.3 at some stage soon - all about scheduling outages and testing code before we do... Thanks for everyone's help appreciate it.

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Scott Marlowe
On Thu, Oct 16, 2008 at 10:23 AM, Roderick A. Anderson <[EMAIL PROTECTED]> wrote: > Scott Marlowe wrote: >> >> On Thu, Oct 16, 2008 at 8:52 AM, Roderick A. Anderson <[EMAIL PROTECTED]> >> wrote: >>> >>> Tom Lane wrote: >>> CentOS 5 -- three, four, or maybe more, updates this year so far. :-) >>>

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Roderick A. Anderson
Scott Marlowe wrote: On Thu, Oct 16, 2008 at 8:52 AM, Roderick A. Anderson <[EMAIL PROTECTED]> wrote: Tom Lane wrote: CentOS 5 -- three, four, or maybe more, updates this year so far. :-) Is there a way to determine from a binary install (Devrim GÜNDÜZ's rpms) if it uses the system timezone da

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Scott Marlowe
On Thu, Oct 16, 2008 at 8:52 AM, Roderick A. Anderson <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > CentOS 5 -- three, four, or maybe more, updates this year so far. :-) > > Is there a way to determine from a binary install (Devrim GÜNDÜZ's rpms) if > it uses the system timezone data or the build

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Roderick A. Anderson
Tom Lane wrote: "Roderick A. Anderson" <[EMAIL PROTECTED]> writes: Tom Lane wrote: No, you're behind the times: 8.2.4 and 8.1.9 are too old to know about this year's changes in southeast Australia DST laws. Which I imagine is what's biting you. Doesn't Pg use tzdata (at least that's what it'

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Scott Marlowe
On Thu, Oct 16, 2008 at 12:23 AM, Craig Ayliffe <[EMAIL PROTECTED]> wrote: > Hi, > > I have several Postgres DB's not showing correct daylight savings time. > > Server 1: postgresql-8.2.4 (Ubuntu 7.04) > Server2: Postgresql-8.1.9 (on Ubuntu Dapper 6.06.1) Question: Why are you so far behind on pg

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Tom Lane
"Roderick A. Anderson" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> No, you're behind the times: 8.2.4 and 8.1.9 are too old to know about >> this year's changes in southeast Australia DST laws. Which I imagine >> is what's biting you. > Doesn't Pg use tzdata (at least that's what it's called

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Alvaro Herrera
Roderick A. Anderson wrote: > Doesn't Pg use tzdata (at least that's what it's called on for > Redhat-ian distributions) for it's timezone information? Yes. It ships its own, unless told to use the system copy at build time. If it's not, then you must upgrade both copies (the system's and PG'

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Roderick A. Anderson
Tom Lane wrote: "Craig Ayliffe" <[EMAIL PROTECTED]> writes: I have several Postgres DB's not showing correct daylight savings time. From maillist etc I believe these are patched up to the right levels to have the correct time zones - but they don't seem to be working still. No, you're behin

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Tom Lane
"Craig Ayliffe" <[EMAIL PROTECTED]> writes: > I have several Postgres DB's not showing correct daylight savings time. > From maillist etc I believe these are patched up to the right levels to have > the correct time zones - but they don't seem to be working still. No, you're behind the times: 8.2

Re: [GENERAL] Problems with Timezones in Australia

2008-10-16 Thread Murray Fox
On 16/10/2008, at 7:23 PM, Craig Ayliffe wrote: Hi, I have several Postgres DB's not showing correct daylight savings time. From maillist etc I believe these are patched up to the right levels to have the correct time zones - but they don't seem to be working still. The unix date com

[GENERAL] Problems with Timezones in Australia

2008-10-15 Thread Craig Ayliffe
Hi, I have several Postgres DB's not showing correct daylight savings time. >From maillist etc I believe these are patched up to the right levels to have the correct time zones - but they don't seem to be working still. The unix date command show the correct dates. Server 1: postgresql-8.2.4 (U