Date: Thu, 18 May 2017 13:38:39 +0800
From: YangBy <yby@yangby.org>
To: pgsql-admin@postgresql.org
Subject: Recovey on Master / Primary Server
Message-ID: <20170518053839.GA8870@yangby.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="d6Gm4EdcadzBjdND"
Content-Disposition: inline
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--d6Gm4EdcadzBjdND
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hello,

    Can I recovery a point in master/primary server, just step back, not=20
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,=20
also successfully.=09

    But those solutions seems too complex.

    I try to recovey the data in the same database, just step back, but I=
=20
didn't find any docs about this.

    Am I missing something, or just PG can not do this?

    Thanks!

--=20

May joy and health be with you always!
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -
Name   : YangBy
Email  : yby@yangby.org
Website: www.yangby.org
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -

--d6Gm4EdcadzBjdND
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----

iQIcBAEBCAAGBQJZHTNfAAoJEAvs2yDbW8Q4OJQP/RZRaHLt/EIdbmNdo1LOqHhb
NOMDFm/O5bZ38jEWzJ9KG28YYMVhQp7mY6pNcdh595/JYUWeBBxZxPjbwU1GKBjR
vlyGG4YVjR8jh9P3upAx8quybTosNfhA3xZzN1VjRIUL6YrgZijv/7FPOVmrrCcF
AoIFVC7moAt+aj669OMsQzC+YEzJtDxkFqeq+Lx+X10gFuL9My9Xjm/xl4Uc5ZNT
APqpwiivnrcgYzlnsTT/kPRIwSmU4lEV0C3Ne8jSeCalaF0nLCwB6PZw51kHy8RQ
BqPeWURTpdeMnCTBRb2Egw7xKow2U8gzKcKw3BvKHtMEtVOXWFXVhfUMJ+arQLsq
XP+wLiaf/AJNOIaMVE+twawXhjq/Y5tKOtzHqtIDaBphfB5bX6NH2ZbapzAGNASv
3e/6kulyrz9tMSWiBgaD74p2QnXb+jbHYglHZ6mYJUVVDs5DArk/qHpffzMCGXaJ
ueCYih+e4M0WePqwEMAjFERdL2iRnXyNhuPbNAhus0lnSfv8+onrNBApQN9MejUb
xkGvZEQaALRhR0lHrSbeGsCULimQjPkOfG7jWcb9NSYvBB81zQuWXrKxV/tAde9Q
JPTo6xDlfPE1/2bXPuOz7mkF9RyZ0Gq735Cz60Qr6JRmllK05nnhZT/JGDQiM27R
lRGIPaIt2CjcGi1moAFt
=X0oC
-----END PGP SIGNATURE-----

--d6Gm4EdcadzBjdND--