Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id ADA822E2F83 for ; Mon, 17 Mar 2008 11:35:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 08559-05-4 for ; Mon, 17 Mar 2008 11:34:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id ED20B2E01B9 for ; Mon, 17 Mar 2008 11:26:53 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so9810509pye.29 for ; Mon, 17 Mar 2008 07:26:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:content-language:thread-index; bh=jfX0VZHyWLrtfz2dZ6Uij61s1Xz7qREuf5zElZpPr78=; b=U8knilQ6QZlzfbq2YlJjyjLBIbRmXw+uiacRCHMD4YDk10mWR2cqgP4wLOBq6g4xphZRzRMjpOJuXigFTrgLj8N0KrYoe31I+vDDWY5dxJiEvXGBeMRx5FOfJ0vOSmBXKtYBOl7OTLYW/xwlqSDsT7JwtxWIRnDX/NXN+doUr1k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:content-language:thread-index; b=vS3/fw3XRzVeOioqqdzt1DGOHvI2I/o0uf128eUr6+sXiyNf0hDX9kUmWn3arBH/2/cn95nztYlXJ1GmoKp09Ny2C1cb7P4wQ1H4kn9fX0zd9cyBc8jVQEmn3wOntvemBmhB5lcatuXiMjdwOquY8Xu653PrQoAWFVxVykPqzuw= Received: by 10.65.96.6 with SMTP id y6mr538040qbl.5.1205764010967; Mon, 17 Mar 2008 07:26:50 -0700 (PDT) Received: from mis06 ( [205.214.220.146]) by mx.google.com with ESMTPS id c6sm19501100qbc.11.2008.03.17.07.26.46 (version=SSLv3 cipher=RC4-MD5); Mon, 17 Mar 2008 07:26:49 -0700 (PDT) From: "Rommel the iCeMAn" To: "PostgreSQL Admin" Subject: pgAdmin Crashes After Changing Timezone Setting Date: Mon, 17 Mar 2008 10:25:16 -0400 Message-ID: <015801c8883a$c1456390$43d02ab0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Content-Language: en-us Thread-Index: AciIOqx2Xd4Yx5fiR4S3HAneZq0I3g== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/121 X-Sequence-Number: 28604 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.