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

Re: Server closed the connection unexpectedly

From: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Server closed the connection unexpectedly
Date: 2004-04-29 03:06:39
Message-ID: 20040429030639.GA20211@www.sirfsup.com (view raw or flat)
Thread:
Lists: pgsql-novice
carla, 
sometimes people have a psql version which doesn't match that of the server.  since you can run psql and get the version, maybe there is a mismatch? 
?

On Wed, Apr 28, 2004 at 06:42:22PM -0700, Carla wrote:
> This problem occurs when running postgres locally on win2k ,
> 
> psql was running ok but now when typing:
> c:\>psql psql -d template1
> c:\>psql -U username
> c:\>psql -l
> c:\>psql -e
> 
> I still get
>  psql: server closed the connection unexpectedly
>  	This problem means the server terminated abnormally
>  	before or while processing the request.
> 
> I have checked the .pid file on the starting of postgres which is fine and
> the log file said that postgres is still running.
> 
> I have checked the TYPE, DATABASE, IP_ADRESS in pg_hba.conf
> I have checked my host.txt and the IP is correct. In pgruntime.config,
> tcpip_socket = true and the port is correct.
> 
> I thought it might be a TCP/IP problem but am sure that the -I for TCP/IP
> connections is being passed in when starting postgres. pg_ctl is working
> 
> If you run psql when postgres is stopped you get the expected error.
> The only command I can run is
> c:\>psql -V
> all other options in psql result in this 'server closed the connection
> unexpectedly' error.
> 
> Is their something that I am doing wrong, overlooked or not checked?
> 
> Carla
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.670 / Virus Database: 432 - Release Date: 27/04/2004
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

-- 
joe speigle
www.sirfsup.com

In response to

pgsql-novice by date

Next:From: Robert MorganDate: 2004-04-29 04:17:27
Subject: starting posgresql for the first time and most probably last :)
Previous:From: CarlaDate: 2004-04-29 01:42:22
Subject: Server closed the connection unexpectedly

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