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

From Melvin Davidson
Subject Re: pg_basebackup restore a single table
Date
Msg-id CANu8FiyMUPMLhWeAA5mamS5RHVohQLuFbHpPQuJpz4Zmq9PsyA@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup restore a single table  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general


On Wed, Apr 11, 2018 at 11: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...

--
Angular momentum makes the world go 'round.


>Can I do a restore of a single table or single base using the archive
>generated for the basebackup ...

As Ron has previously stated, this is not possible, but it begs the question...why not simply do a pg_dump of one table and restore that?

--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_basebackup restore a single table
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_basebackup restore a single table