Search Postgresql Archives

Re: restore a specific schema from physical backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux