Re: no more pg_dump cause of multiple declared database??

bboett(at)erm1(dot)u-strasbg(dot)fr (Bruno Boettcher) writes:
> fibu=# \l
> List of databases
> Database | Owner | Encoding
> -----------+----------+-----------
> admin | www | SQL_ASCII
> fibu | bboett | SQL_ASCII
> fibu | hordemgr | SQL_ASCII
> horde | www | SQL_ASCII
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
> (6 rows)

> how can this be?

You have multiple users registered in pg_shadow with the same usesysid.

Alter the usesysid of the one you don't want to own that database.
(You will then have to find the objects he *should* own, and fix
their owner ID values...)

There should be a unique index on pg_shadow.usesysid, but due to an
old oversight there isn't. Fixing this is on the TODO list.

regards, tom lane