From: YangBy <yby@yangby.org>
To: pgsql-admin@postgresql.org
Subject: Recovey on Master / Primary Server
Date: Thu, 18 May 2017 13:38:39 +0800
Message-ID: <20170518053839.GA8870@yangby.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello,
Can I recovery a point in master/primary server, just step back, not
re-create the database by all archives or use a backup?
I create a point by use `pg_create_restore_point`.
Then I re-create the database, set `recovery_target_name` in `recovery.conf`,
and recovery the database by all archives, successfully.
I use `pg_start_backup` to create a copy and re-create the database,
also successfully.
But those solutions seems too complex.
I try to recovey the data in the same database, just step back, but I
didn't find any docs about this.
Am I missing something, or just PG can not do this?
Thanks!
--
May joy and health be with you always!
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
Name : YangBy
Email : yby@yangby.org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
Attachments:
signature.asc (application/pgp-signature, 800B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: yby@yangby.org
Subject: Re: Recovey on Master / Primary Server
In-Reply-To: <20170518053839.GA8870@yangby.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox