user is not in "pg_shadow"

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

Responses

Browse pgsql-admin by date

  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