Re: Time Zone in Postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Time Zone in Postgres
Date: 2008-03-07 02:49:56
Message-ID: 2195.1204858196@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sathiya psql 2008-03-07 05:29:35 stable release and difference
Previous Message Shilpa Sudhakar 2008-03-07 01:51:37 Re: Time Zone in Postgres