Re: Time is off in PG server - Mailing list pgsql-admin

Making the setting in the postgresql.conf file worked after i HUP'd the
postmaster, and logged back into my psql sessions.

timezone = 'EST5EDT'

Thanks a million.
- Ericson

>"set local" was probably not what you wanted to use here.  Per the man page:
>
>    Note that SET LOCAL will appear to have no effect if it is executed outside
>    a BEGIN block, since the transaction will end immediately.
>
>            regards, tom lane
>
>