Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E54042E3224 for ; Wed, 2 Jan 2008 16:31:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 62386-07 for ; Wed, 2 Jan 2008 16:31:25 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 5B4E22E318A for ; Wed, 2 Jan 2008 16:31:26 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so9498424waf.5 for ; Wed, 02 Jan 2008 12:31:24 -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=WPCgh9H22ZJSlZwJ/BBbc9Z0PDAhss9RU4PBzRXdLwo=; b=V9ZdWBkZ7iQtEHP3bA01xSh6ErW/Bs0AQX8xZW1noQgFaVQ9phgyvg+rv9pNnHZeuVnDqY3G2Ux7nLLoftrqJKRAXmdv31bH6D+R50xIDeDy16WPI07qo1dMKF+9M+jqMSK1zPtBvhmA+TGaOkaaEhsejLozvpdsPBokAtFBrhs= 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=HdQsFFCz/zwM17ddmnDbPj6DtV/STevTbXsn9kEx/fppYjfSIGnv7T7inOBKe2MvMfY2ifGFkJ/LIUaAPtBPZOFzThIc/y07XJkECZF72cqmUEZcWY6uCFRKC62nkF5c/W63RlB8VdjTRRQYz+HcamLSQK2jVG8yFEckl56o4o4= Received: by 10.114.123.1 with SMTP id v1mr1900534wac.147.1199305884470; Wed, 02 Jan 2008 12:31:24 -0800 (PST) Received: by 10.114.131.4 with HTTP; Wed, 2 Jan 2008 12:31:24 -0800 (PST) Message-ID: Date: Wed, 2 Jan 2008 14:31:24 -0600 From: "Scott Marlowe" To: "Fernando Hevia" Subject: Re: [SQL] PG is in different timezone than the OS Cc: "pgsql-general@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <00ff01c84d6f$65e64ec0$8f01010a@iptel.com.ar> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/41 X-Sequence-Number: 126251 Alright, reading the file in postgresql-8.2.5/src/timezone/README I take it that anyone with a source compiled pg or using source rpms should be able to download the tzdata from here: ftp://elsie.nci.nih.gov/pub/tzcode2007k.tar.gz and put it here: postgresql-8.2.5/src/timezone/data and recompile and have the new timezone they need?