Обсуждение: 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?

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@gmail.com>
To: <pgsql-novice@postgresql.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