Re: pg_basebackup restore a single table

On Wed, Apr 11, 2018 at 11:22 AM, Ron <ronljohnsonjr(at)gmail(dot)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!