Re: Connection terminated

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