Received: from smtp.usit.net (SMTP.USIT.NET [208.10.171.67]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA07519; Tue, 24 Aug 1999 13:15:35 -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 NAA29329; Tue, 24 Aug 1999 13:15:29 -0400 (EDT) Message-ID: <00d501beee54$2ff37320$9f5305c7@go.servicetransport.com> From: "Shawn Pursley" To: "Simon Drabble" Cc: , References: Subject: Re: [GENERAL] Boneheaded Setup? Date: Tue, 24 Aug 1999 12:14:54 -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 Simon -- Thanks for all the help so far...please don't kill me... For anyone else doing this exercise...I had to use the -R instead of -r on Mandrake. [root@pusher bin]# chown -R postgres /usr/local/pgsql/ [postgres@pusher pgsql]$ nohup postmaster > regress.log 2>&1 & [1] 1443 [postgres@pusher pgsql]$ createuser Connection to database 'template1' failed. FATAL 1: SetUserId: user 'postgres' is not in 'pg_shadow' createuser: database access failed. [postgres@pusher pgsql]$ cd /usr/local/pgsql/data [postgres@pusher data]$ ls -la total 62 -rw------- 1 postgres postgres 8195 Aug 24 12:09 #pg_shadow# drwxrwsr-x 3 postgres postgres 1024 Aug 24 12:09 ./ drwxrwsr-x 8 postgres postgres 1024 Aug 18 09:10 ../ -rw------- 1 postgres postgres 4 Aug 12 16:12 PG_VERSION drwx--S--- 4 postgres postgres 1024 Aug 17 11:27 base/ -rw------- 1 postgres postgres 8192 Aug 17 11:27 pg_database -r-------- 1 postgres postgres 3407 Aug 12 16:12 pg_geqo.sample -rw------- 1 postgres postgres 0 Aug 12 16:12 pg_group -rw--w---- 1 postgres postgres 5191 Aug 12 17:05 pg_hba.conf -rw--w---- 1 postgres postgres 5192 Aug 12 16:12 pg_hba.conf~ -rw------- 1 postgres postgres 8192 Aug 18 11:00 pg_log -rw-rw-rw- 1 postgres postgres 51 Aug 12 16:12 pg_pwd -rw------- 1 postgres postgres 8192 Aug 12 16:12 pg_shadow -rw------- 1 postgres postgres 8192 Aug 18 11:00 pg_variable Do you spot anything else wrong? I tried to emacs pg_shadow, but that is one ugly files that looks compiled. I did see that powner resides in there. Shawn