Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_basebackup restore a single table - Mailing list pgsql-general

From David G. Johnston
Subject Re: pg_basebackup restore a single table
Date
Msg-id CAKFQuwZeLeMsdSLag2g7axqBCH_Nr=wJ44MdSXfCd=LNPtD0JQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup restore a single table  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: pg_basebackup restore a single table
Next
From: Don Seiler
Date:
Subject: Archiving Data to Another DB?