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

From Andreas Kretschmer
Subject Re: pg_basebackup restore a single table
Date
Msg-id a79a8e76-87a2-0d85-9f7e-4a1134cff19a@a-kretschmer.de
Whole thread Raw
In response to pg_basebackup restore a single table  (camarillo <carlos.amarillo@gmail.com>)
Responses Re: pg_basebackup restore a single table  (Ron <ronljohnsonjr@gmail.com>)
Re: pg_basebackup restore a single table  (camarillo <carlos.amarillo@gmail.com>)
List pgsql-general

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.


Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: dblink: give search_path
Next
From: Ron
Date:
Subject: Re: pg_basebackup restore a single table