Re: pg_restore --no-post-data and --post-data-only
Dimitri Fontaine <dimitri@2ndquadrant.fr>
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org
Date: 2011-09-03T20:49:51Z
Lists: 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