Re: [GENERAL] restore a specific schema from physical backup

2016-07-30 Thread Stephen Frost
* David Steele (da...@pgmasters.net) wrote: > On 7/29/16 5:31 PM, Rakesh Kumar wrote: > > Sure. > > > > 1 - You ran pg_basebackup on node-1 against a live cluster and store > > it on NFS or tape. > > 2 - Do a restore on node-2 from the backup taken on (1), but only for > > a subset of the

Re: [GENERAL] restore a specific schema from physical backup

2016-07-29 Thread David Steele
On 7/29/16 5:31 PM, Rakesh Kumar wrote: >> 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

Re: [GENERAL] restore a specific schema from physical backup

2016-07-29 Thread Adrian Klaver
On 07/29/2016 02:31 PM, Rakesh Kumar wrote: 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

Re: [GENERAL] restore a specific schema from physical backup

2016-07-29 Thread Rakesh Kumar
> 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

Re: [GENERAL] restore a specific schema from physical backup

2016-07-29 Thread Adrian Klaver
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)

[GENERAL] restore a specific schema from physical backup

2016-07-29 Thread Rakesh Kumar
If a cluster is backed up physically using pg_basebackup, how can we restore only a particular schema from it. Is it even possible? Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: