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

Bill McGonigle <mcgonigle@medicalmedia.com> writes:
> Just checked pg_shadow, and each usesysid is unique.

Drat, another perfectly good theory down the drain.

Please look in the pg_dumpall script to see the query it uses to get the
list of database names, and run that query by hand to see if you get
duplicates.  If so, can you figure out why?

> In pg_database, every datlastsysoid is the same, 18539 - is that OK?

Yes, that's expected.

            regards, tom lane