user is not in "pg_shadow"

Поиск
Список
Период
Сортировка
От Terence Dixon
Тема user is not in "pg_shadow"
Дата
Msg-id 35D21825.BD5498F0@rochgrp.com
обсуждение исходный текст
Список pgsql-admin
Hi all -
I just upgraded from 6.1 to 6.3.2, on x86 RedHat Linux 5.0 (ELF).
Version 6.1 was great, I can't wait to use 6.2.3!
I ran this:

postgres@some_machine> psql -d template1 -c "create user some_user
createdb createuser"
CREATE USER
postgres@some_machine> psql -e template1 < db.out
\connect template1
connecting to new database: template1
select datdba into table tmp_pg_shadow       from pg_database where
datname = 'template1';
QUERY: select datdba into table tmp_pg_shadow       from pg_database
where datname = 'template1';
SELECT
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
QUERY: delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
DELETE 1
drop table tmp_pg_shadow;
QUERY: drop table tmp_pg_shadow;
DROP
copy pg_shadow from stdin;
QUERY: copy pg_shadow from stdin;
\connect template1
connecting to new database: template1
create database scud;
QUERY: create database scud;
ERROR:  createdb: database scud already exists.
\connect scud
connecting to new database: scud
\connect - some_user
connecting as new user: some_user
FATAL 1:  SetUserId: user "some_user" is not in "pg_shadow"

Could not connect to new database. exiting

#-------------------

I've scoured all the documentation I can find, plus the mailing list
archive, and I've yet to find any info that can help me.

My question is, what is "pg_shadow" and how do I get users into it?

Thanks.
- Terry

Terence W. Dixon
The Rochester Group, Inc.
Rochester, NY
USA

В списке pgsql-admin по дате отправления:

Предыдущее
От: adm@pu.go.id
Дата:
Сообщение: HELP all women were raped during the May riots in Jakarta
Следующее
От: Bernd Johannes Wuebben
Дата:
Сообщение: FATAL 1: SetUserId: