From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
To: | Bill McGonigle <mcgonigle(at)medicalmedia(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dumpall storing multiple copies of DB's? |
Date: | 2002-02-26 22:49:23 |
Message-ID: | m37kozx3ik.fsf@varsoon.denali.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bill McGonigle <mcgonigle(at)medicalmedia(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2002-02-26 22:55:01 | pltcl: Invalid return list from trigger - must have even # of elements |
Previous Message | Martijn van Oosterhout | 2002-02-26 22:47:52 | Re: terminal with horizontal scrollbar |