Re: pg_dumpall custom format?

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: pg_dumpall custom format?
Дата
Msg-id AANLkTil4Vnguuh-G3-ZeKQ2oopdEYVUaysAVMxJu47wi@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dumpall custom format?  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: pg_dumpall custom format?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
On 13 May 2010 18:28, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le 13/05/2010 19:24, Thom Brown a écrit :
> On 13 May 2010 17:49, Guillaume Lelarge <guillaume@lelarge.info> wrote:
>
>> Le 13/05/2010 14:12, Thom Brown a écrit :
>>> On 5 March 2009 12:08, Thom Brown <thombrown@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

В списке pgsql-general по дате отправления:

Предыдущее
От: seiliki@so-net.net.tw
Дата:
Сообщение: Getting reference key elements in right orders
Следующее
От: Lew
Дата:
Сообщение: Re: 'Infinity' in date columns?