pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRecovey on Master / Primary Server
2+ messages / 2 participants
[nested] [flat]
* Recovey on Master / Primary Server
@ 2017-05-18 05:38 YangBy <yby@yangby.org>
0 siblings, 1 reply; 2+ messages in thread
From: YangBy @ 2017-05-18 05:38 UTC (permalink / raw)
To: 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@yangby.org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
Attachments:
signature.asc (application/pgp-signature, 800B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Recovey on Master / Primary Server
@ 2017-05-19 04:59 goutham goud <gouthamgoud@live.com>
parent: YangBy <yby@yangby.org>
0 siblings, 0 replies; 2+ messages in thread
From: goutham goud @ 2017-05-19 04:59 UTC (permalink / raw)
To: YangBy <yby@yangby.org>; 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of YangBy
Sent: 18 May 2017 11:09
To: pgsql-admin@postgresql.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@yangby.org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-05-19 04:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-05-18 05:38 Recovey on Master / Primary Server YangBy <yby@yangby.org>
2017-05-19 04:59 ` goutham goud <gouthamgoud@live.com>
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