pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgAdmin Crashes After Changing Timezone Setting 3+ messages / 2 participants [nested] [flat]
* pgAdmin Crashes After Changing Timezone Setting @ 2008-03-17 14:25 Rommel the iCeMAn <icecrew@gmail.com> 2008-03-17 15:08 ` Re: pgAdmin Crashes After Changing Timezone Setting Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: Rommel the iCeMAn @ 2008-03-17 14:25 UTC (permalink / raw) To: pgsql-admin 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? How do I correctly set the time zone? Thanks, Rommel Edwards Barbados, Caribbean. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgAdmin Crashes After Changing Timezone Setting 2008-03-17 14:25 pgAdmin Crashes After Changing Timezone Setting Rommel the iCeMAn <icecrew@gmail.com> @ 2008-03-17 15:08 ` Tom Lane <tgl@sss.pgh.pa.us> 2008-03-17 16:05 ` Re: pgAdmin Crashes After Changing Timezone Setting Rommel the iCeMAn <icecrew@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2008-03-17 15:08 UTC (permalink / raw) To: Rommel the iCeMAn <icecrew@gmail.com>; +Cc: pgsql-admin "Rommel the iCeMAn" <icecrew@gmail.com> writes: > 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. Can't help you with that, you'll need to report that on the pgadmin mailing list. > 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. Did you remove the comment marker (#) from the timezone setting line? regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgAdmin Crashes After Changing Timezone Setting 2008-03-17 14:25 pgAdmin Crashes After Changing Timezone Setting Rommel the iCeMAn <icecrew@gmail.com> 2008-03-17 15:08 ` Re: pgAdmin Crashes After Changing Timezone Setting Tom Lane <tgl@sss.pgh.pa.us> @ 2008-03-17 16:05 ` Rommel the iCeMAn <icecrew@gmail.com> 0 siblings, 0 replies; 3+ messages in thread From: Rommel the iCeMAn @ 2008-03-17 16:05 UTC (permalink / raw) To: pgsql-admin > Can't help you with that, you'll need to report that on the pgadmin > mailing list. Will do. > Did you remove the comment marker (#) from the timezone setting line? Yes I did, which is why it baffles me. Here's what that part of my conf file looks like: # - Locale and Formatting - datestyle = 'iso, mdy' timezone = 'America/Barbados' # actually, defaults to TZ environment # setting #timezone_abbreviations = 'Default' # Select the set of available time zone # abbreviations. Currently, there are # Default # Australia # India # You can create your own file in # share/timezonesets/. Thanks for the response, Rommel Edwards Barbados, Caribbean. ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-17 16:05 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-03-17 14:25 pgAdmin Crashes After Changing Timezone Setting Rommel the iCeMAn <icecrew@gmail.com> 2008-03-17 15:08 ` Tom Lane <tgl@sss.pgh.pa.us> 2008-03-17 16:05 ` Rommel the iCeMAn <icecrew@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox