From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Geoffrey Myers <lists(at)serioustechnology(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: setting timezone |
Date: | 2011-11-09 19:52:52 |
Message-ID: | 4EBADA14.3050608@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
> Geoffrey Myers wrote:
>> Tom Lane wrote:
>>> Steve Crawford <scrawford(at)pinpointresearch(dot)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
>>
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-11-10 02:36:55 | Re: How to deal with corrupted database? |
Previous Message | Geoffrey Myers | 2011-11-09 19:23:45 | Re: setting timezone |