Re: [GENERAL] Boneheaded Setup?
От | Simon Drabble |
---|---|
Тема | Re: [GENERAL] Boneheaded Setup? |
Дата | |
Msg-id | Pine.LNX.3.96.990824133514.18365A-100000@dragon обсуждение исходный текст |
Ответ на | Re: [GENERAL] Boneheaded Setup? ("Shawn Pursley" <shawn.pursley@acorncomputers.com>) |
Список | pgsql-general |
On Tue, 24 Aug 1999, Shawn Pursley wrote: > 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. Yeah, my bad - it is indeed -R > > [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 > > 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. Oops. Looks like you installed as powner, which will cause powner to be the postgres super user. My advice to you if you haven't created any databases yet is to blow away the postgres directory completely and re-run the installation, this time as postgres. Once you have done this, you can add powner as a postgres user and assign rights as necessary. the postgres super-user should really be only used to start/ stop the back-end, and create new users (i.e. admin tasks). Use powner to create databases and work with them. Simon. -- "This message will expire soon. Please contact your vendor for an update." Simon Drabble It's like karma for your brain. simon@eskimo.com
В списке pgsql-general по дате отправления: