Skip site navigation (1) Skip section navigation (2)

Re: Serious connection problem

From: Afton & Ray Still <rastill(at)shaw(dot)ca>
To: apocalypznow <apocalypznow(at)gmail(dot)com>,pgsql-novice(at)postgresql(dot)org
Subject: Re: Serious connection problem
Date: 2005-02-16 23:42:10
Message-ID: 005901c51481$225eebf0$7c884146@rayshome (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I had something similliar happen when I upgraded to 8.01 from a release 
candidate. (win xp, SP2) I don't remember exactly what the problem ended up 
being, but I seem to remember that it was related to an incorrect path 
statement, or a service not being started properly or the like. I'd suggest 
you check all your config files and make sure any services are running 
----- Original Message ----- 
From: "apocalypznow" <apocalypznow(at)gmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, February 11, 2005 4:08 PM
Subject: [NOVICE] Serious connection problem

>I just installed (for the 4th time) Postgresql 8.01 on WinXP SP1.  Each 
>time, the same thing happens.  When I use pgAdminIII to connect to the 
>default database server, I get the following error:
> "An error has occured:
> server closed the connection unexpectedly
> This probably means the server terminated abnormally before or while 
> processing the request."
> I have set up a user account (ie: not admin account) in WinXP for this 
> installation.  I have also set listen_addresses = '*' in postgresql.conf. 
> The install procedure seemed to run without flaw.  I have even uninstalled 
> Norton Antivirus.  The machine has a Network Bridge on it because it is 
> used to bridge the wireless connection that is hardwired to the machine. 
> I mention this just in case it has anything to do with this problem.  This 
> machine is obviously not going to be a production server, but for 
> development only.
> When the postgresql service starts, the log file is filled with the 
> following statements repeatedly:
> FATAL:  could not reattach to shared memory (key=5432001, addr=01350000): 
> Invalid argument
> FATAL:  could not reattach to shared memory (key=5432001, addr=01350000): 
> Invalid argument
> 2005-02-11 15:06:52 LOG:  background writer process (PID 2016) exited with 
> exit code 0
> 2005-02-11 15:06:52 LOG:  terminating any other active server processes
> 2005-02-11 15:06:53 LOG:  all server processes terminated; reinitializing
> How do I fix this connection problem?
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster 

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005

In response to

pgsql-novice by date

Next:From: Oisin GlynnDate: 2005-02-17 00:08:54
Subject: Re: Front End Languages for PostgreSQL
Previous:From: Dick DaviesDate: 2005-02-16 23:13:31
Subject: Re: Front End Languages for PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group