On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
Geoffrey Myers wrote:
Tom Lane wrote:
Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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
Thanks Tom, seems we were not setting it in the postgresql.conf file.
What about the situation where you have two databases in the same
cluster that need different timezones? I'm assuming I would have to
rely on setting it in each database, rather in the postgresql.conf file.
ALTER DATABASE foo SET TIMEZONE...
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
