Re: Server Timezone - Mailing list pgsql-general

From Robert DiFalco
Subject Re: Server Timezone
Date
Msg-id 13B7318C-3415-4F14-AE28-F9DAD8C27963@gmail.com
Whole thread Raw
In response to Re: Server Timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
You're right. This was my error.

Sent from my iPhone

> On Apr 7, 2014, at 8:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Robert DiFalco <robert.difalco@gmail.com> writes:
>> Is there any way to set the timezone of the postgres server differently
>> than the OS? I *have* tried setting timezone = 'UTC' in my postgresql.conf
>> file but that seems to be a VIEW of time zone. It doesn't seem to behave
>> the same as running a postgresql server on a machine that is in UTC.
>
> You would need to be more precise about "doesn't seem to behave the same"
> for anyone to help you.  Setting the timezone parameter (and perhaps
> log_timezone) should cover it, so far as the server is concerned.
>
> Are you sure your client-side code isn't doing something helpful with
> what it thinks the timezone is?
>
>            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server Timezone
Next
From: Kevin Grittner
Date:
Subject: Re: Increase in max_connections