Re: pg_basebackup restore a single table

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_basebackup restore a single table
Date: 2018-04-11 15:21:14
Message-ID: a79a8e76-87a2-0d85-9f7e-4a1134cff19a@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-04-11 15:22:53 Re: pg_basebackup restore a single table
Previous Message Adrian Klaver 2018-04-11 14:26:32 Re: dblink: give search_path