On Wed, Apr 11, 2018 at 11:22 AM, Ron <ronljohnso...@gmail.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... > > -- > 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!
