Le 17/05/2010 14:28, Thom Brown a écrit : > On 13 May 2010 18:28, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote: > >> Le 13/05/2010 19:24, Thom Brown a écrit : >>> On 13 May 2010 17:49, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote: >>> >>>> Le 13/05/2010 14:12, Thom Brown a écrit : >>>>> On 5 March 2009 12:08, Thom Brown <thombrown@xxxxxxxxx> 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) > Yes. > 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 > Yes. > And adding database entry support to the listing file. > And adding a role and a tablespace entries. And prefixing every object with the database they belong too. It won't be easy, but it's really something lacking right now. Or at least, I think so :) -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
