Re: Relation 'pg_user' does not exist

Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
> I get the following error trying to make my backups:
> !2188 marauder(at)bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
> getTypes(): SELECT failed. Explanation from backend: 'ERROR:
> Relation 'pg_user' does not exist

Hmm, did you do something silly like delete pg_user?

It's only a view, so you could recreate it if so:

CREATE VIEW pg_user AS
SELECT
usename,
usesysid,
usecreatedb,
usetrace,
usesuper,
usecatupd,
'********'::text as passwd,
valuntil
FROM pg_shadow

regards, tom lane