[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] user is not in "pg_shadow"
From:       Terence Dixon <tdixon () rochgrp ! com>
Date:       1998-08-12 22:33:09
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]