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:
> 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
In response to
pgsql-novice by date
|Next:||From: Robert Morgan||Date: 2004-04-28 01:56:53|
|Subject: opening postgresql first time|
|Previous:||From: joseph speigle||Date: 2004-04-27 23:08:36|
|Subject: Re: Validation rules|