| From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | "Rommel the iCeMAn" <icecrew(at)gmail(dot)com> |
| Cc: | "PgAdmin Support" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: pgAdmin Crashes After Changing Timezone Setting |
| Date: | 2008-03-18 11:36:35 |
| Message-ID: | 937d27e10803180436q433f1cecx9a20d5d94a777baa@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Mon, Mar 17, 2008 at 4:41 PM, Rommel the iCeMAn <icecrew(at)gmail(dot)com> wrote:
> I tried manually editing the postgresql.conf file in Notepad but when I
> reload PostgreSQL it ignores the entry in the config file and defaults to
> 'Canada/Atlantic' time zone. I am using pgAdmin3 v1.8.2.99 and Postgresql
> 8.3.0. I am able to reproduce this error with PostgreSQL 8.3.0 running on
> Windows XP SP2, Windows 2000 SP4 and Windows 2003 SP1. Am I doing something
> incorrectly?
I've fixed the bug in pgAdmin for 1.8.3 (hint: edit the timezone
setting, not TimeZone).
Iirc, the timezone can only be changed with a full restart of
PostgreSQL, so you need to stop and start the service, not just tell
it to reload the config file.
--
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcin Zajaczkowski | 2008-03-18 15:41:33 | Problem with focus in report dialogs |
| Previous Message | Rommel the iCeMAn | 2008-03-17 16:41:37 | pgAdmin Crashes After Changing Timezone Setting |