Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 586082E2FE7 for ; Wed, 2 Jan 2008 19:29:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 62977-03 for ; Wed, 2 Jan 2008 19:29:38 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id 8CDE02E02DD for ; Wed, 2 Jan 2008 19:29:41 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so9586924waf.5 for ; Wed, 02 Jan 2008 15:29:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=2BughUfHk7V2g/rUtiCubFVQ3AGoceHkkwOwXU5bKSY=; b=rDt5PgbzX8ZCTaPQsv9JVPbnoX7pXFCECdYPjhAwuo//VSAGcx39bH7E8h8iH+euwlU0O+knyVEINXj8RqOa+ygqjR/n+ALrncAHCWd73yVKgZHfokCG7PkybsmlRcPTzeW8AC9DSDWb1XwQRQy1WQcgIJhY0blvQSEUeixJSOI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=w22OuVP+TifevsWKBkTYJtpfJJoIQbgTItrwCDP2tdZmkin/HWOLCoAYem5jSZk/dmkI1dApHy/qu1NphOX8m3RUSntD7WaC/g0GgYd9oUzI3+p9MqAahoe9ewg+C8Un5B+IFCPCzphIzeN+4rWDyX3XRLZ3GmZ+zn35hIgH4PQ= Received: by 10.114.168.1 with SMTP id q1mr14274171wae.73.1199316579612; Wed, 02 Jan 2008 15:29:39 -0800 (PST) Received: by 10.114.131.4 with HTTP; Wed, 2 Jan 2008 15:29:39 -0800 (PST) Message-ID: Date: Wed, 2 Jan 2008 17:29:39 -0600 From: "Scott Marlowe" To: Joe Subject: Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Cc: "Fernando Hevia" , "SQL Postgresql List" In-Reply-To: <477BF8D4.9090608@freedomcircle.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <477BF8D4.9090608@freedomcircle.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/13 X-Sequence-Number: 29867 On Jan 2, 2008 2:49 PM, Joe 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.