Re: pg_restore --no-post-data and --post-data-only
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Greg Sabino Mullane <greg@turnstep.com>,
pgsql-hackers@postgresql.org
Date: 2011-09-03T21:04:42Z
Lists: pgsql-hackers
On 09/03/2011 04:49 PM, Dimitri Fontaine wrote: > 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. > > That's probably a lot of code for a little benefit, at least from my POV, but others might find it useful. cheers andrew