On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
> Geoffrey Myers wrote:
>> Tom Lane wrote:
>>> 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
>>
>> 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
