Re: pg_dumpall custom format?

Le 17/05/2010 14:28, Thom Brown a écrit :
> 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)
>

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