I tried the pgInstaller instead of the One Click Installer and everything installed correctly. Andrew On Thu, May 14, 2009 at 10:34 AM, Andrew Maclean <andrew.amaclean@xxxxxxxxx> wrote: > 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/ > ___________________________________________ > -- ___________________________________________ 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
