I did a fresh installation after deleting every reference to postgres and pgAdmin in the registry and removing the relevant folders. It looks as if the installation fails when loading additional modules. I also think host should be localhost at this stage. Here is a portion of the log that shows a definite error: *********************************************************************************************************** Script output: Starting postgresql-8.3 Service postgresql-8.3 started successfully startserver.vbs ran to completion Script stderr: Loading additional SQL modules... Executing cscript Script exit code: 2 Script output: Installing pl/pgsql in the template1 databases... psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? Failed to install pl/pgsql in the 'template1' database Installing the adminpack module in the postgres database... psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? Failed to install the 'adminpack' module in the 'postgres' database loadmodules.vbs ran to completion Script stderr: Program ended with an error exit code Error running cscript //NoLogo "C:\Program Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" "" "C:\Program Files\PostgreSQL\8.3" "C:\Program Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit code Error running cscript //NoLogo "C:\Program Files\PostgreSQL\8.3\installer\server\loadmodules.vbs" "postgres" "x" "C:\Program Files\PostgreSQL\8.3" "C:\Program Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit code Write the data directory to the ini file... Write the port number, service ID, locale and superuser to the ini file... *********************************************************************************************************** On Thu, May 14, 2009 at 9:57 AM, Andrew Maclean <a.maclean@xxxxxxxxxx> wrote: > I'll check this out but I am puzzled as to why it suddenly appeared after > upgrading. > > > -----Original Message----- > From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] > Sent: Thursday, 14 May 2009 09:40 > To: a.maclean@xxxxxxxxxx > Cc: General > Subject: Re: postgres 3.7 unexpected closing of connections > > On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean > <andrew.amaclean@xxxxxxxxx> wrote: >> I have the following error message: >> >> "Error connecting to the server: server closed the connection > unexpectedly. >> This probably means that the server terminated abnormally before or >> while processing the request. >> " >> It happens intermittently both when using pgAdminIII and when using QT >> so it is not a pgAdminIII issue. >> >> Often the connection seems to succeed but you get a series of error >> messages like the one above when attempting to open a database. It >> seems to be a timing issue. >> >> This does not happen with postgresql-8.3.5 but does happen with >> postgresql-8.3.7. I used the One-click installer from EnterpriseDB and >> am running Vista SP1. > > First suspect when running on windows is antivirus software. > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- ___________________________________________ Andrew J. P. Maclean Centre for Autonomous Systems The Rose Street Building J04 The University of Sydney 2006 NSW AUSTRALIA Ph: +61 2 9351 3283 Fax: +61 2 9351 7474 URL: http://www.acfr.usyd.edu.au/ ___________________________________________ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
