Postgres Pro
Downloads
Home   >   mailing lists

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

From Doug McNaught
Subject Re: pg_dumpall storing multiple copies of DB's?
Date
Msg-id m3bsebx3ym.fsf@varsoon.denali.to
Whole thread Raw
In response to pg_dumpall storing multiple copies of DB's?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
Responses Re: pg_dumpall storing multiple copies of DB's?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Zak Greant
Date:
Subject: [pgsql-advocacy] eWeek Poll: Which database is most critical to your organization?
Next
From: Bill McGonigle
Date:
Subject: Re: pg_dumpall storing multiple copies of DB's?