Re: pg_basebackup restore a single table

2018-04-13 Thread camarillo
Thank you! -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: pg_basebackup restore a single table

2018-04-11 Thread David G. Johnston
On Wed, Apr 11, 2018 at 8:22 AM, Ron 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 >>>

Re: pg_basebackup restore a single table

2018-04-11 Thread Melvin Davidson
On Wed, Apr 11, 2018 at 11:22 AM, Ron 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 file

Re: pg_basebackup restore a single table

2018-04-11 Thread Ron
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 machin

Re: pg_basebackup restore a single table

2018-04-11 Thread Andreas Kretschmer
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-recove