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

From Shilpa Sudhakar
Subject Re: Time Zone in Postgres
Date
Msg-id 47D0D353.5050206@internode.com.au
Whole thread Raw
In response to Re: Time Zone in Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
I copied the system zonefiles into the postgres database and it works
fine now. This is anyway a temporary solution until we upgrade all our
systems.

Thanks to all for your suggestions and help.



Tom Lane wrote:
> 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: "sathiya psql"
Date:
Subject: stable release and difference
Next
From: Tom Lane
Date:
Subject: Re: stable release and difference