Re: Restoring a postgres database - Mailing list pgsql-general

From Dennis Björklund
Subject Re: Restoring a postgres database
Date
Msg-id Pine.LNX.4.44.0307091044430.1516-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Restoring a postgres database  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Restoring a postgres database  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Wed, 9 Jul 2003, Martijn van Oosterhout wrote:

> In fact, you could take the ultra pessimistic route and change pg_dump to
> dump in such a way that it will always work. That should be possible. Say
> in the order:

That is probably simplest way even if the dumps will be ugly. There might
also be some places in pg where you can't make the change needed to do it
like this. But pg have been getting a lot better in this respect with a
nice sql syntax to do things that you previously could only do by changing
system tables.

> I've never had a database with recursive dependancies so maybe I'm
> underestimating the problems here.

I've had it several times, and I don't think it's that uncommon.

--
/Dennis


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Native dataprovider on Windows
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Restoring a postgres database