Обсуждение: user not in pg_shadow

Поиск
Список
Период
Сортировка

user not in pg_shadow

От
James Clawson
Дата:
Hi:

In trying to set up my work environment(using
DebianGNU linux) I am unable to create a new user.I
can connect to server as postgres, but when I try
"CREATE USER 'joe' WITH PASSWORD 'apples' " I get
Connection to database template1 failed; FATAL 1 :
SetUserId 'joe' is not in 'pg_shadow' " when I try to
connect  as joe??
     Thanks in advance for any pointers here. Jim
Clawson





__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Re: user not in pg_shadow

От
Michele Heikkilä
Дата:
> same message.

What user did you run initdb as?  Apparently it wasn't "postgres" ...

No, I must have done that as root. (Which is not in
pg_shadow either)

Cheers,
Michele Heikkilä