On 13 May 2010 18:28, Guillaume Lelarge <guilla...@lelarge.info> wrote:
> Le 13/05/2010 19:24, Thom Brown a écrit : > > On 13 May 2010 17:49, Guillaume Lelarge <guilla...@lelarge.info> wrote: > > > >> Le 13/05/2010 14:12, Thom Brown a écrit : > >>> On 5 March 2009 12:08, Thom Brown <thombr...@gmail.com> wrote: > >>>> [...] > >>> I'm bringing this thread back to life to see if there are any further > >>> thoughts on this. It would be nice to have a complete backup of a > >> database > >>> cluster in custom format, and use pg_restore to restore an individual > >>> database in the same way that it can restore individual schemas and > >> tables > >>> etc. > >>> > >> > >> Nope. But this is something I'd like to have too. I didn't actually look > >> into it much more (I mean, in the code), but I intend to work on this > >> for 9.1 (and other pg_dump stuff). > >> > >> > >> > > You're now my favourite PostgreSQL developer! Thanks Guillaume! > > > > Don't get your expectations too high. I just said I'll try :) > > I guess this will also require changes to pg_restore to support: -g globals only -r roles only -t tablespaces (conflicts with pg_restore's table specification of -t) And of course being able to restore individual databases and specifying restoration of a table/function/trigger within specific databases. I guess that could be done by specifying a database to restore, then asking for a single function. e.g.: pg_restore --database=my_source_database -P my_function(argtype) -d my_destination_database /database/backup/file And adding database entry support to the listing file. Thom
