From: | Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: restore a specific schema from physical backup |
Date: | 2016-07-29 21:31:12 |
Message-ID: | CAJBB=EUYFDGBY3-ctoCdhfhA9dXRrv+a2zidqgDOT2dYOSodbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
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 database
(schema/database)
3- Put the cluster live on node-2 after (2) completes. Essentially the
cluster will now be a small
subset of cluster on node-1.
Benefit: If I have to restore only 5% of entire db, it should be lot faster.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-07-29 21:37:36 | Re: restore a specific schema from physical backup |
Previous Message | Adrian Klaver | 2016-07-29 21:25:08 | Re: restore a specific schema from physical backup |