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

bboett@erm1.u-strasbg.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