Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 826702E3297 for ; Wed, 2 Jan 2008 16:50:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86096-01-8 for ; Wed, 2 Jan 2008 16:50:40 -0400 (AST) Received: from vms173003pub.verizon.net (vms173003pub.verizon.net [206.46.173.3]) by postgresql.org (Postfix) with ESMTP id 409F72E351F for ; Wed, 2 Jan 2008 16:50:32 -0400 (AST) Received: from [192.168.2.5] ([71.180.173.50]) by vms173003.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JU100HIYB53NEA2@vms173003.mailsrvcs.net> for pgsql-sql@postgresql.org; Wed, 02 Jan 2008 14:48:40 -0600 (CST) Date: Wed, 02 Jan 2008 15:49:24 -0500 From: Joe Subject: Re: Argentinian timezone change at the last moment. How to change pgsql tz db? In-reply-to: To: Scott Marlowe Cc: Fernando Hevia , SQL Postgresql List Message-id: <477BF8D4.9090608@freedomcircle.net> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: User-Agent: Thunderbird 2.0.0.9 (X11/20071216) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200801/12 X-Sequence-Number: 29866 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. Joe