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

Re: Connection terminated

From: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Connection terminated
Date: 2004-04-27 23:10:06
Message-ID: 20040427231006.GB8022@www.sirfsup.com (view raw or flat)
Thread:
Lists: pgsql-novice
hi 
can you connect as the user who started the postmaster, or maybe as postgres user, without password?  try not specifiying the user, just do 'psql -d template1' as postgres

On Tue, Apr 27, 2004 at 04:06:04PM -0700, Carla wrote:
> Hi
> I am running postgres locally. All was working well.
> I can start postgres using the command line which says:
> >postgres successfully started.
> 
> but when I  type in the command
> >psql -U nameOfUser
> psql: server closed the connection unexpectedly
> 	This problem means the server terminated abnormally
> 	before or while processing the request.
> 
> I have checked In postmaster.log which says:
> DEBUG:  database system is ready
> I have checked PGDATA, PGHOME and PGHOST which all have the correct path.
> I have checked postgres in the current processes running,ans that psql is on
> it path.
> Why can I no longer run psql?
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.620 / Virus Database: 399 - Release Date: 11/03/2004
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

-- 
joe speigle
www.sirfsup.com

In response to

pgsql-novice by date

Next:From: Robert MorganDate: 2004-04-28 01:56:53
Subject: opening postgresql first time
Previous:From: joseph speigleDate: 2004-04-27 23:08:36
Subject: Re: Validation rules

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