From: Shawn Pursley <shawn.pursley@acorncomputers.com>
To: Simon Drabble <simon@eskimo.com>
Cc: pgsql-general@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [GENERAL] Boneheaded Setup?
Date: Tue, 24 Aug 1999 12:14:54 -0500
Message-ID: <00d501beee54$2ff37320$9f5305c7@go.servicetransport.com> (raw)
References: <Pine.LNX.3.96.990824124143.17871A-100000@dragon>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: shawn.pursley@acorncomputers.com, simon@eskimo.com, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Boneheaded Setup?
In-Reply-To: <00d501beee54$2ff37320$9f5305c7@go.servicetransport.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox