Re: [GENERAL] Boneheaded Setup?

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(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
>
> 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(at)eskimo(dot)com