Re: pg_basebackup restore a single table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_basebackup restore a single table
Date: 2018-04-11 15:56:16
Message-ID: CAKFQuwZeLeMsdSLag2g7axqBCH_Nr=wJ44MdSXfCd=LNPtD0JQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Don Seiler 2018-04-11 16:15:12 Archiving Data to Another DB?
Previous Message Melvin Davidson 2018-04-11 15:39:25 Re: pg_basebackup restore a single table