Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? - Mailing list pgsql-general

From Tom Lane
Subject Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?
Date
Msg-id 28319.1199421476@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
Responses Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
List pgsql-general
"Fernando Hevia" <fhevia@ip-tel.com.ar> writes:
> With 8.2.x the ARST abbreviation was recognized after including the
> following line in /usr/share/postgresql/8.2/timezonesets/Default

> ARST   -14400 D  # Argentina Summer Time

Um ... is that really offsetting in the correct direction?  What I put
into CVS was

ARST    -7200 D  # Argentina Summer Time

If that's wrong I need to know ...

> I wonder if pg_timezone_names plays any role in the ARST issue. It does
> contain the right data (appeared after copying tzdata into
> /usr/share/postgresql/timezone and restarting server) but ARST wasn't
> accepted till previous step was done.

Too tired to experiment, but you may need a "pg_ctl reload" or even a
restart to get PG to notice changes in your timezonesets file.

            regards, tom lane

pgsql-general by date:

Previous
From: "Fernando Hevia"
Date:
Subject: Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Can't make backup