Re: setting timezone - Mailing list pgsql-admin

From Tom Lane
Subject Re: setting timezone
Date
Msg-id 15278.1320857260@sss.pgh.pa.us
Whole thread Raw
In response to Re: setting timezone  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin
Steve Crawford <scrawford@pinpointresearch.com> writes:
> On 11/09/2011 05:10 AM, Geoffrey Myers wrote:
>> Is there a way to retain this information from the original database
>> when reloading?

> Time-zone setting is an attribute of the server configuration, not of
> the data contained in the database.

In particular, pg_dump doesn't know anything about postgresql.conf.
It's up to you to copy the server's configuration files.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Ruslan A. Bondar"
Date:
Subject: Re: database not using indexes
Next
From: Silvio Brandani
Date:
Subject: Re: database not using indexes