| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Joe <dev(at)freedomcircle(dot)net> |
| Cc: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>, "SQL Postgresql List" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Argentinian timezone change at the last moment. How to change pgsql tz db? |
| Date: | 2008-01-02 23:29:39 |
| Message-ID: | dcc563d10801021529r6c33c367q47ec7b775064e3e2@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Jan 2, 2008 2:49 PM, Joe <dev(at)freedomcircle(dot)net> wrote:
> Scott Marlowe wrote:
> > I've been reading up on zic and wondering if it's a reasonable thing
> > to try and update the pg tz db to include the new argentinian DST
> > change. Where is the tz info stored in postgres? In the catalog?
> >
> Typically in /usr/share/postgresql/timezone or maybe
> /usr/local/share/postgresql/timezone.
That doesn't get me what I need. It lets me change the alias of
timezones, but not the start and stop of daylight savings time. I
think for that I'd have to edit / replace the files in
postgresql-8.2.x/src/timezone/data/ and recompile to fix this.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-02 23:45:14 | Re: Argentinian timezone change at the last moment. How to change pgsql tz db? |
| Previous Message | Martin Langhoff | 2008-01-02 21:27:50 | PITR - filter by database? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-02 23:45:14 | Re: Argentinian timezone change at the last moment. How to change pgsql tz db? |
| Previous Message | Joe | 2008-01-02 20:49:24 | Re: Argentinian timezone change at the last moment. How to change pgsql tz db? |