From: | Terence Dixon <tdixon(at)rochgrp(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | user is not in "pg_shadow" |
Date: | 1998-08-12 22:33:09 |
Message-ID: | 35D21825.BD5498F0@rochgrp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)some_machine> psql -d template1 -c "create user some_user
createdb createuser"
CREATE USER
postgres(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Johannes Wuebben | 1998-08-13 00:36:26 | FATAL 1: SetUserId: |
Previous Message | Antonio Garcia Mari | 1998-08-12 20:50:47 | ERROR: fmgr_info: function 18375: cache lookup failed |