Re: pg_restore --no-post-data and --post-data-only - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: pg_restore --no-post-data and --post-data-only
Date
Msg-id m2aaalfj0w.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: pg_restore --no-post-data and --post-data-only  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_restore --no-post-data and --post-data-only
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
>> Oh, I meant just having it create separate custom format files for each
>> database. As shell scripts all over the world have been doing for years,
>> but it would be nice if it was simply built in.
>
> I guess it could be done, although I'm not going to do it :-) I'm more about
> making somewhat hard things easier than easy things slightly easier :-)

Then what about issuing an archive (tar or ar format here) containing
one custom file per database plus the globals file, SQL, plus maybe a
database listing, and hacking pg_restore so that it knows what to do
with such an input ?

Bonus points if that supports the current -l and -L options, of course.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: sha1, sha2 functions into core?
Next
From: Dimitri Fontaine
Date:
Subject: Re: WAL "low watermark" during base backup