Re: copy a database - Mailing list pgsql-general

David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela@xsto.info> writes:
> The problem is that pg_dump always give me the next error:

> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  relation "pg_user" does not exist

Have you tried re-creating that view?

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

            regards, tom lane