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 m37kozx3ik.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: 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
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: terminal with horizontal scrollbar
Next
From: "Ian Harding"
Date:
Subject: pltcl: Invalid return list from trigger - must have even # of elements