Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7CB61784916 for ; Wed, 9 Nov 2011 09:49:26 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 30467-06 for ; Wed, 9 Nov 2011 13:49:20 +0000 (UTC) X-Greylist: delayed 00:38:46.668197 by SQLgrey-1.8.0-rc2 Received: from centosvm.serioustechnology.com (99-39-100-157.lightspeed.tukrga.sbcglobal.net [99.39.100.157]) by mail.postgresql.org (Postfix) with ESMTP id 6854D784915 for ; Wed, 9 Nov 2011 09:49:20 -0400 (AST) Received: from centosvm.serioustechnology.com (centosvm [127.0.0.1]) by centosvm.serioustechnology.com (8.13.8/8.13.8) with ESMTP id pA9DAavu008491 for ; Wed, 9 Nov 2011 08:10:36 -0500 Message-ID: <4EBA7BCC.2030704@serioustechnology.com> Date: Wed, 09 Nov 2011 08:10:36 -0500 From: Geoffrey Myers User-Agent: Thunderbird 2.0.0.24 (X11/20110928) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: setting timezone Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.918 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201111/26 X-Sequence-Number: 38620 We are moving a number of databases to new hardware. Some of these machines have the timezone set in the database differently then the actual location of the machine as they are access from a different timezone. We were surprised to note that when we dump the database and reloaded it on the new machine, it did not retain the timezone setting. Is there a way to retain this information from the original database when reloading? Thanks. -- Until later, Geoffrey "I predict future happiness for America if they can prevent the government from wasting the labors of the people under the pretense of taking care of them." - Thomas Jefferson