Re: Relation 'pg_user' does not exist

Matt Beauregard <matt@designscape.com.au> writes:
> I get the following error trying to make my backups:
> !2188 marauder@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