Re: pg_dump bug fixing - Mailing list pgsql-hackers

From Harald Fuchs
Subject Re: pg_dump bug fixing
Date
Msg-id pu7jszm26q.fsf@srv.protecting.net
Whole thread Raw
In response to Re: pg_dump bug fixing  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
In article <1090256502.414.17.camel@jester>,
Rod Taylor <pg@rbt.ca> writes:

> On Mon, 2004-07-19 at 12:36, Josh Berkus wrote:
>> Rod,
>> 
>> > I think what we want is a clean template without all of the extras that
>> > template1 has.
>> 
>> We have this, it's called Template0.

> Doesn't work for me. I remove a number of things that are included by
> default in template0, but yes, it's close.

I think pg_dump should do a kind of "diff" between template1 and the
database in question and include the necessary statements in the dump
to allow pg_restore to "replay" the diff after it has created the
database from template1.



pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: localhost redux
Next
From: "Andrew Dunstan"
Date:
Subject: Re: pg_config