Re: pg_dumpall storing multiple copies of DB's?

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:39:45
Message-ID: m3bsebx3ym.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:

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antoine Reid 2002-02-26 22:45:23 Re: terminal with horizontal scrollbar
Previous Message Jean-Luc Lachance 2002-02-26 21:54:28 Re: help with getting index scan