Thread: postgres 3.7 unexpected closing of connections
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. Has anyone any ideas on how to fix this? it is really annoying because it is intermittent. I have done a complete reinstallation and deleted everything before reinstalling it. Lucky it is only a test installation! Andrew -- ___________________________________________ 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/ ___________________________________________
On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean <andrew.amaclean@gmail.com> 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.
Actually it is happening on two different Vista platforms one running McAfee and the other Symantec. Andrew -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@gmail.com] Sent: Thursday, 14 May 2009 09:40 To: a.maclean@cas.edu.au Cc: General Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean <andrew.amaclean@gmail.com> 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.
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@gmail.com] Sent: Thursday, 14 May 2009 09:40 To: a.maclean@cas.edu.au Cc: General Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean <andrew.amaclean@gmail.com> 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.
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@cas.edu.au> 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@gmail.com] > Sent: Thursday, 14 May 2009 09:40 > To: a.maclean@cas.edu.au > Cc: General > Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections > > On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean > <andrew.amaclean@gmail.com> 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@postgresql.org) > 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/ ___________________________________________
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@gmail.com> 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@cas.edu.au> 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@gmail.com] >> Sent: Thursday, 14 May 2009 09:40 >> To: a.maclean@cas.edu.au >> Cc: General >> Subject: Re: [GENERAL] postgres 3.7 unexpected closing of connections >> >> On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean >> <andrew.amaclean@gmail.com> 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@postgresql.org) >> 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/ ___________________________________________