Recovey on Master / Primary Server

From: YangBy <yby(at)yangby(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Recovey on Master / Primary Server
Date: 2017-05-18 05:38:39
Message-ID: 20170518053839.GA8870@yangby.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(at)yangby(dot)org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message goutham goud 2017-05-19 04:59:19 Re: Recovey on Master / Primary Server
Previous Message Stéphane KANSCHINE 2017-05-18 04:30:35 Re: Do backups on slave. Is it OK?