Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 638FB2E30B2; Fri, 4 Jan 2008 00:38:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 24011-08; Fri, 4 Jan 2008 00:38:06 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C768C2E30AD; Fri, 4 Jan 2008 00:38:06 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m044buve028320; Thu, 3 Jan 2008 23:37:56 -0500 (EST) To: "Fernando Hevia" cc: "'Scott Marlowe'" , "'Joe'" , "'SQL Postgresql List'" , pgsql-general@postgresql.org Subject: Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? In-reply-to: <01dc01c84e85$e2abb5a0$8f01010a@iptel.com.ar> References: <01dc01c84e85$e2abb5a0$8f01010a@iptel.com.ar> Comments: In-reply-to "Fernando Hevia" message dated "Fri, 04 Jan 2008 01:57:12 -0200" Date: Thu, 03 Jan 2008 23:37:56 -0500 Message-ID: <28319.1199421476@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/75 X-Sequence-Number: 126285 "Fernando Hevia" 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