Re: setting timezone

Steve Crawford wrote:
> 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...

As I expected, thanks.

>
> Cheers,
> Steve
>
>
>

--
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