Re: Server Timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: Server Timezone
Date
Msg-id 9032.1396929192@sss.pgh.pa.us
Whole thread Raw
In response to Server Timezone  (Robert DiFalco <robert.difalco@gmail.com>)
Responses Re: Server Timezone  (Robert DiFalco <robert.difalco@gmail.com>)
List pgsql-general
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: Michael Paquier
Date:
Subject: Re: import .sql file into PostgreSQL database
Next
From: Robert DiFalco
Date:
Subject: Re: Server Timezone