Re: pg_dumpall custom format?

On 13 May 2010 18:28, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:

> Le 13/05/2010 19:24, Thom Brown a écrit :
> > On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> >
> >> Le 13/05/2010 14:12, Thom Brown a écrit :
> >>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)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