Re: postgres 3.7 unexpected closing of connections

From: Andrew Maclean <andrew(dot)amaclean(at)gmail(dot)com>
To: Andrew Maclean <a(dot)maclean(at)cas(dot)edu(dot)au>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, General <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres 3.7 unexpected closing of connections
Date: 2009-05-14 00:34:20
Message-ID: e7ddbec60905131734p6adc3abem6a05dc9dbf4c7675@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)maclean(at)cas(dot)edu(dot)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(dot)marlowe(at)gmail(dot)com]
> Sent: Thursday, 14 May 2009 09:40
> To: a(dot)maclean(at)cas(dot)edu(dot)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(dot)amaclean(at)gmail(dot)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(at)postgresql(dot)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/
___________________________________________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Maclean 2009-05-14 01:22:27 Re: postgres 3.7 unexpected closing of connections
Previous Message Yaroslav Tykhiy 2009-05-14 00:15:49 Warm standby: 1 to N