Re: [SQL] How do I stop the postmaster? - Mailing list pgsql-sql

From James Olin Oden
Subject Re: [SQL] How do I stop the postmaster?
Date
Msg-id 81Aug5.123254edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
In response to Re: [SQL] How do I split the data files into 2 hardisks?  (Ludovic Marcotte <ludovic@Sophos.ca>)
List pgsql-sql
> Hi all,
>
> I started the postmaster by running this command:
> /usr/local/psql/bin/postmaster -oe -S -D /usr/local/pgsql/data
>
> Then I type:
> psql mydb
>
> Error:
> Connection to database 'mydb' failed.
> PQexec() -- Request was sent to backend, but backed closed the channel before
> responding.
>                         This probably means the backend terminated abnormally
> before or while
>                         processing request.
>

What user are you logged in as when you try to connect to the database?  If you
are not a users that has also had a postgres account created by create_user this
may happen.  Also, this or other error messages will occur if you try to access
the database as root...james


pgsql-sql by date:

Previous
From: pierre@desertmoon.com
Date:
Subject: Re: [SQL] Creating table with unique key.
Next
From: Johann Spies
Date:
Subject: Re: [SQL] What is the recommended machine configuration?