PostgreSQL and pg_shadow

[willcf]

I have successfully installed Postgresql on my Linux machine (using Red
Hat version 7). Before I can use "psql", the front end for entering sql
commands, I have to create a database. I used "createdb" with the name
of a database, as was shown in the example in the MAN page. I got the
error:
psql: FATAL 1: SetUserId: user 'johndoe' is not in 'pg_shadow'
createdb: database creation failed
I have looked through HOWTOS - PostgreSQL for something about pg_shadow
and for an explanation of adding my login name to the authorization file to become a superuser.
Any suggestions??
willcf

 

[Guest_imported]

Ok.. i've seen that error but only when accessing data from a perl script. The solution I took then was to simply create a user for the perl script to use and then grant permissions to that user for the relevant tables.

Make sure that you are using the postgres user (su to postgres) when you do a createdb. If you do that there should be no problem.

Hope everything works out.

-mark
mrampton@hotmail.com