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.
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 |