Re: pg_dumpall storing multiple copies of DB's? - Mailing list pgsql-general

On Wednesday, February 27, 2002, at 12:08 , Tom Lane wrote:

> If you happen to have multiple entries in pg_shadow with the same
> usesysid, then the SELECT will generate multiple rows for the matching
> databases.
>
> 7.2 has a unique index on pg_shadow.usesysid, so hopefully this failure
> mode is a thing of the past now.  In the meantime, get rid of the extra
> pg_shadow entries and dump again.

Just checked pg_shadow, and each usesysid is unique.  In pg_database,
every datlastsysoid is the same, 18539 - is that OK?

-Bill