Re: Serious connection problem

Hello
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
properly.
HTH
Ray
----- 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