Re: Time Zone in Postgres - Mailing list pgsql-admin

From Tom Lane
Subject Re: Time Zone in Postgres
Date
Msg-id 2195.1204858196@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time Zone in Postgres  (Shilpa Sudhakar <ssudhakar@internode.com.au>)
Responses Re: Time Zone in Postgres  (Shilpa Sudhakar <ssudhakar@internode.com.au>)
List pgsql-admin
Shilpa Sudhakar <ssudhakar@internode.com.au> writes:
> As i said, we have version 8.2.4 databases and if i need to just update
> the timezone files for this database do i copy the zoneinfo files from
> the OS zonefile or from the newer version of Postgres zonefiles.

If your platform uses the standard zoneinfo format (and if the file
trees look similar, it probably does) then you could just copy the
system's zoneinfo files into the Postgres directories, assuming you've
gotten updated zoneinfo files for the system.

            regards, tom lane

pgsql-admin by date:

Previous
From: Shilpa Sudhakar
Date:
Subject: Re: Time Zone in Postgres
Next
From: "sathiya psql"
Date:
Subject: stable release and difference