Thread: pgAdmin Crashes After Changing Timezone Setting

pgAdmin Crashes After Changing Timezone Setting

From
"Rommel the iCeMAn"
Date:
Hi List,

I'm experiencing strange behavior in pgAdmin. I recently noticed that my
PostgreSQL reports a different time to the OS. I checked the time zone
setting and realized it was set to 'Canada/Atlantic'. I tried using
pgAdmin's Backend Configuration Editor to change the time zone in
postgresql.conf to 'America/Barbados' but when I try to save the file,
pgAdmin crashes. The server log has the following entries:

2008-03-17 10:24:58 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 10:24:58 ADT LOG:  database system was shut down at 2008-03-15
14:58:02 ADT
2008-03-17 10:24:58 ADT FATAL:  the database system is starting up
2008-03-17 10:24:59 ADT LOG:  database system is ready to accept connections
2008-03-17 10:24:59 ADT LOG:  autovacuum launcher started
2008-03-17 10:24:59 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 10:31:04 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 10:31:39 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 10:32:01 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 10:33:06 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 11:05:52 ADT LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.

2008-03-17 11:05:52 ADT LOG:  unexpected EOF on client connection
2008-03-17 11:05:52 ADT LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.

2008-03-17 11:05:52 ADT LOG:  unexpected EOF on client connection
2008-03-17 11:05:52 ADT LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.

2008-03-17 11:05:52 ADT LOG:  unexpected EOF on client connection
2008-03-17 11:05:52 ADT LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.

2008-03-17 11:05:52 ADT LOG:  unexpected EOF on client connection
2008-03-17 11:08:47 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 11:08:52 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 11:08:56 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 11:10:02 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-03-17 11:10:25 ADT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"

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?

Thanks,
Rommel Edwards
Barbados, Caribbean.




Re: pgAdmin Crashes After Changing Timezone Setting

From
"Dave Page"
Date:
On Mon, Mar 17, 2008 at 4:41 PM, Rommel the iCeMAn <icecrew@gmail.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


Re: pgAdmin Crashes After Changing Timezone Setting

From
"Rommel the iCeMAn"
Date:
> I've fixed the bug in pgAdmin for 1.8.3

Where can I download 1.8.3? I just visited the download page but I am
only seeing links for 1.8.2.

> (hint: edit the timezone setting, not TimeZone)

I don't understand. Am I not supposed to modify the line #timezone =
unknown so that it reads timezone = 'America/Barbados'? Please
explain.

> 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.

That was exactly what I did when the config reload failed. Restarting
the service didn't work either. I'll try it again.

Thanks for the input so far.


Re: pgAdmin Crashes After Changing Timezone Setting

From
"Dave Page"
Date:
On Tue, Mar 18, 2008 at 7:06 PM, Rommel the iCeMAn <icecrew@gmail.com> wrote:
> > I've fixed the bug in pgAdmin for 1.8.3
>
> Where can I download 1.8.3? I just visited the download page but I am
> only seeing links for 1.8.2.

It isn't released yet - I've fixed the bug in the editor and it will
be in 1.8.3 when that comes out.

> > (hint: edit the timezone setting, not TimeZone)
>
> I don't understand. Am I not supposed to modify the line #timezone =
> unknown so that it reads timezone = 'America/Barbados'? Please
> explain.

The editor was showing lines for TimeZone and timezone. Edit the
first, and you get the error. The second works fine.

> > 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.
>
> That was exactly what I did when the config reload failed. Restarting
> the service didn't work either. I'll try it again.

OK, well if that doesn't work, it's a PostgreSQL issue, not pgAdmin of course.

-- 
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk


Re: pgAdmin Crashes After Changing Timezone Setting

From
"Rommel the iCeMAn"
Date:
> It isn't released yet - I've fixed the bug in the editor and it will be in
1.8.3 when that comes out.

I'll be waiting ;-)


> The editor was showing lines for TimeZone and timezone. Edit the first,
and you get the error. The second works fine.

Understood.


> OK, well if that doesn't work, it's a PostgreSQL issue, not pgAdmin of
course.

I got it to recognize the America/Barbados time zone. It is not a PostgreSQL
issue, it's a simple case of EWSO - Equipment Wayyyyy Superior to Operator!
I thought I was restarting the service but all I was really doing was
reloading the config. I just put on my dunce cap, I'm going to walk over to
the corner in the back of the classroom and face the wall until teacher says
I can return to my desk! :-)

Thanks for the help,
Rommel Edwards
Software Developer,
Barbados, Caribbean.