Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

PostgreSQL and pg_shadow

PostgreSQL and pg_shadow

PostgreSQL and pg_shadow

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
        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??

RE: PostgreSQL and pg_shadow

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close