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
>>> (/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..
> ​.
>

​The machine one tests their backup restoration process on should suffice
for this purpose...​

David J.


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 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!


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 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.



pg_basebackup restore a single table

2018-04-11 Thread camarillo
Hello how are you?

Currently, I'm doing a basebackup of a postgres instance 9.5 due to the
growth of it, doing a pg_dump took a long time.
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/*)?.  

Thanks,
Carlos 



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html