Thread: pg_shadow?

pg_shadow?

From
Fredrick Bartlett
Date:
Started postmaster with -i.  Why do I get the following error?  What is
pg_shadow?

>psql -h 10.54.3.16 template1
psql: FATAL 1:  SetUserId: user 'bartletr' is not in 'pg_shadow'

Fredrick


Re: pg_shadow?

From
"Ryan Williams"
Date:
My guess?  There is no DB user 'bartletr'.

Try connecting as 'postgres', and then adding the user 'bartletr' (use
"create user bartletr with password 'whatever' createdb createuser;" to
create "bartletr" with password "whatever" who can create more users and
dbs...).

----- Original Message -----
From: "Fredrick Bartlett" <palmtreefrb@earthlink.net>
To: "PostgreSQL novice mailing list" <pgsql-novice@postgresql.org>
Sent: Friday, August 25, 2000 1:43 PM
Subject: [NOVICE] pg_shadow?


> Started postmaster with -i.  Why do I get the following error?  What is
> pg_shadow?
>
> >psql -h 10.54.3.16 template1
> psql: FATAL 1:  SetUserId: user 'bartletr' is not in 'pg_shadow'
>
> Fredrick
>