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 по дате отправления: