| From: | Ericson Smith <eric(at)did-it(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Time is off in PG server |
| Date: | 2004-08-26 16:14:03 |
| Message-ID: | 412E0C4B.30509@did-it.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
>
| Attachment | Content-Type | Size |
|---|---|---|
| eric.vcf | text/x-vcard | 315 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naomi Walker | 2004-08-26 16:14:57 | Re: Size of database |
| Previous Message | Naomi Walker | 2004-08-26 16:11:32 | Re: Size of database |