Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA09805 for ; Thu, 6 Aug 1998 13:41:12 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Wed, 5 Aug 1981 12:32:54 -0400 Date: Thu, 6 Aug 1998 13:43:44 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: Chairudin Sentosa Harjo CC: "pgsql-questions@postgresql.org" Subject: Re: [SQL] How do I stop the postmaster? References: <35C95044.3FC7D53B@dnet.net.id> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Aug5.123254edt.35713@gateway.lee.k12.nc.us> > 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