Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Boneheaded Setup?

From: "Shawn Pursley" <shawn(dot)pursley(at)acorncomputers(dot)com>
To: "Simon Drabble" <simon(at)eskimo(dot)com>
Cc: <pgsql-general(at)postgreSQL(dot)org>, <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Boneheaded Setup?
Date: 1999-08-24 17:14:54
Message-ID: 00d501beee54$2ff37320$9f5305c7@go.servicetransport.com (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-generalpgsql-interfaces
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(at)pusher bin]# chown -R postgres /usr/local/pgsql/
[postgres(at)pusher pgsql]$ nohup postmaster > regress.log 2>&1 &
[1] 1443
[postgres(at)pusher pgsql]$ createuser
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user 'postgres' is not in 'pg_shadow'

createuser: database access failed.
[postgres(at)pusher pgsql]$ cd /usr/local/pgsql/data
[postgres(at)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



In response to

Responses

pgsql-announce by date

Next:From: Simon DrabbleDate: 1999-08-24 17:39:26
Subject: Re: [GENERAL] Boneheaded Setup?
Previous:From: Simon DrabbleDate: 1999-08-24 16:45:37
Subject: Re: [GENERAL] Boneheaded Setup?

pgsql-interfaces by date

Next:From: Constantin TeodorescuDate: 1999-08-24 17:28:03
Subject: Re: [INTERFACES] pgaccess
Previous:From: Rusty BrooksDate: 1999-08-24 16:54:32
Subject: Re: [INTERFACES] pgaccess

pgsql-general by date

Next:From: Simon DrabbleDate: 1999-08-24 17:39:26
Subject: Re: [GENERAL] Boneheaded Setup?
Previous:From: Daniel P├ęderDate: 1999-08-24 17:00:31
Subject: RE: [GENERAL] PostgreSQL, Inc Site Redone ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group