Re: postgres 3.7 unexpected closing of connections

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(dot)amaclean(at)gmail(dot)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(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/
> ___________________________________________
>

--
___________________________________________
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/
___________________________________________