Re: restore a specific schema from physical backup

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: restore a specific schema from physical backup
Date: 2016-07-29 21:25:08
Message-ID: 76375e3b-2ca5-98b7-11ae-aa3a5c12d9b2@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2016-07-29 21:31:12 Re: restore a specific schema from physical backup
Previous Message Rakesh Kumar 2016-07-29 21:16:49 restore a specific schema from physical backup