Re: Serious connection problem - Mailing list pgsql-novice

From Afton & Ray Still
Subject Re: Serious connection problem
Date
Msg-id 005901c51481$225eebf0$7c884146@rayshome
Whole thread Raw
In response to Serious connection problem  (apocalypznow <apocalypznow@gmail.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Dick Davies
Date:
Subject: Re: Front End Languages for PostgreSQL
Next
From: "Oisin Glynn"
Date:
Subject: Re: Front End Languages for PostgreSQL