Re: pg_dumpall storing multiple copies of DB's?

Bill McGonigle <mcgonigle@medicalmedia.com> writes:

> Under what circumstances might pg_dumpall store several copies of the
> database?  When I restore the database with psql < dumpfile I see 4-5
> occurances of each database.  This is on 7.1.3.

Are you doing the restore into a "fresh" data area (just initdb'd)?
That's what pg_dumpall assumes you are going to do AFAICS.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863