> 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 don’t think we can do it. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of YangBy Sent: 18 May 2017 11:09 To: pgsql-admin@xxxxxxxxxxxxxx Subject: Recovey on Master / Primary Server 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@xxxxxxxxxx Website: www.yangby.org ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- - -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
