Re: restore a specific schema from physical backup - Mailing list pgsql-general

From Adrian Klaver
Subject Re: restore a specific schema from physical backup
Date
Msg-id 76375e3b-2ca5-98b7-11ae-aa3a5c12d9b2@aklaver.com
Whole thread Raw
In response to restore a specific schema from physical backup  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Responses Re: restore a specific schema from physical backup
List pgsql-general
On 07/29/2016 02:16 PM, Rakesh Kumar wrote:
> If a cluster is backed up physically using pg_basebackup, how can we
> restore only a particular schema from it. Is it even possible?

Are you saying that?:

1) You ran pg_basebackup against a live cluster and sent the output to
another location.

2) At the other location the cluster is not in use.

3) You want to grab the contents of the inactive cluster directly off
the disk.

If that is the case, then no it is not possible without making the
cluster live.

If you mean something else then more details are needed.

>
> Thanks
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: restore a specific schema from physical backup
Next
From: Rakesh Kumar
Date:
Subject: Re: restore a specific schema from physical backup