Re: pg_dumpall storing multiple copies of DB's?

Bill McGonigle <mcgonigle@medicalmedia.com> writes:

> On Tuesday, February 26, 2002, at 05:39 , Doug McNaught wrote:
>
> > 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.
>
> I hadn't done that, but I did drop the databases first.  The data is
> stored multiple times in the backup, so the other problem is that this
> problem gives me 1.8GB backups when I should have 300-400MB backups.

Hmmm, that's very odd.  I'm guessing that something was screwed up in
the data area that you dumped--I haven't seen this happen.

Are all the copies identical?

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