From: | goutham goud <gouthamgoud(at)live(dot)com> |
---|---|
To: | YangBy <yby(at)yangby(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Recovey on Master / Primary Server |
Date: | 2017-05-19 04:59:19 |
Message-ID: | CY4PR22MB09332AFADE5E55081762769AD7E50@CY4PR22MB0933.namprd22.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of YangBy
Sent: 18 May 2017 11:09
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] 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(at)yangby(dot)org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
From | Date | Subject | |
---|---|---|---|
Next Message | Sumeet Shukla | 2017-05-19 13:50:50 | error installing oracle_fdw extension |
Previous Message | YangBy | 2017-05-18 05:38:39 | Recovey on Master / Primary Server |