On Wed, Apr 11, 2018 at 11:22 AM, Ron <ronljohnsonjr@xxxxxxxxx> 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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
