Received: from smtp.usit.net (SMTP.USIT.NET [208.10.171.67]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA86302; Tue, 24 Aug 1999 11:39:07 -0400 (EDT) (envelope-from shawn.pursley@acorncomputers.com) Received: from shawn (DIALUP131.TNCOO.USIT.NET [216.80.176.5]) by smtp.usit.net (8.9.3/8.9.2) with SMTP id LAA15280; Tue, 24 Aug 1999 11:39:04 -0400 (EDT) Message-ID: <004d01beee46$b7619660$9f5305c7@go.servicetransport.com> From: "Shawn Pursley" To: Cc: References: Subject: Boneheaded Setup? Date: Tue, 24 Aug 1999 10:38:28 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 I've currently got pgsql up and running but I have a couple of problems and I'm wondering if someone can help me. Here's what I'm getting where postgres should run the postmaster and powner is the common user account: [postgres@pusher pgsql]$ nohup postmaster > regress.log 2>&1 & [1] 691 [postgres@pusher pgsql]$ su powner Password: [powner@pusher pgsql]$ psql template1 Connection to database 'template1' failed. connectDB() failed: Is the postmaster running and accepting connections at 'UNIX Socket' on port '5432'? I setup just about everything that the docs said to, staying away from root, etc. If I run that postmaster command from the powner user, then I can access pgsql, but only as that user. I'm trying to setup pgaccess and it is failing I believe due to this problem. It's giving me an error stating: Is the Postmaster running (with -i) at localhost and accepting connections on TCP/IP port '5432'? Here my setup Linux Mandrake 5.2 pgsql 6.5.1 pgaccess 0.93 TIA Shawn Pursley(shawn.pursley@service-transport.com) Network Administrator Service Transport 800 528 1616 x 240