Re: pg_basebackup restore a single table

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pg_basebackup restore a single table
Дата
Msg-id CAKFQuwZeLeMsdSLag2g7axqBCH_Nr=wJ44MdSXfCd=LNPtD0JQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_basebackup restore a single table  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
On Wed, Apr 11, 2018 at 8:22 AM, Ron <ronljohnsonjr@gmail.com> wrote:
On 04/11/2018 10:21 AM, Andreas Kretschmer wrote:
Am 11.04.2018 um 15:53 schrieb camarillo:
Can I do a restore of a single table or single base using the archive
generated for the basebackup without having to delete the filesystem
(/var/lib/pgsql/9.5/*)?.

No, but you can use a spare machine to restore the hole database (point-in-time-recovery) and restore the table from that using pg_dump or copy.

Not everyone has a spare machine and a few TB lying around..
​.

​The machine one tests their backup restoration process on should suffice for this purpose...​

David J.

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: pg_basebackup restore a single table
Следующее
От: Don Seiler
Дата:
Сообщение: Archiving Data to Another DB?