Date: Sat, 19 Mar 2016 13:01:10 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Aldo Sarmiento <aldo@bigpurpledot.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_backrest restore & streaming replication
Message-ID: <20160319170110.GC3127@tamriel.snowman.net>
References: 
 <CAHX=r6yBFDmsCq9-h0PibcbpKHYSXru0Mn+EF1k4HqOmx_X7Fg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="/WyilgS7+6IU2yVA"
Content-Disposition: inline
In-Reply-To: 
 <CAHX=r6yBFDmsCq9-h0PibcbpKHYSXru0Mn+EF1k4HqOmx_X7Fg@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--/WyilgS7+6IU2yVA
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Aldo,

* Aldo Sarmiento (aldo@bigpurpledot.com) wrote:
> This is the command I used: /usr/lib/backrest/bin/pg_backrest.pl
> --stanza=prod-9.4 restore --log-level-console=info
> --db-path=/var/lib/postgresql/9.4/replica --thread-max=4 --delta

> After starting the replica back up, I noticed that it was no longer doing
> streaming replication. Also I noticed the logs said something about not
> finding WAL logs that it expected to find (not sure if these two things are
> related).

The pgbackrest restore command which you used doesn't appear to have
included any of the settings necessary to set up a streaming replica.
I'm guessing they also weren't included in the pg_backrest.conf file.

The only parameters that pgbackrest sets in the recovery.conf by default
are those necessary to acquire the necessary XLOGs during restore (the
recovery_command option).

To add other options to the recovery.conf file (such as those required
to start the system as a replica), you can use the --recovery-option to
pgbackrest, or add a '[stanza:restore:recovery-option]' section to the
pg_backrest.conf file being used.

The pgbackrest user guide includes an example of setting up the
pg_backrest.conf file with the necessary options:

http://www.pgbackrest.org/user-guide.html

The "not found" messages are completely normal and expected, PG will ask
for XLOGs which don't exist and pgbackrest is just logging that it was
asked for an XLOG which didn't exist.

Thanks!

Stephen

--/WyilgS7+6IU2yVA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJW7YXWAAoJEO1sijiDR2RV/EIP/AnEspBMpmc64LLzZoiZQEUr
6NE2jaQ56TyZpPQqWEVuqUOupbXMfx6hw3sVkBb2Jg6y66mTO8cY+Y0LCi2UjdU6
mgDtOGLd145jYeuUCQ3/W2+FM5c9ksAu64cJYfmWZ1+BS2Vw0JDb1eSXWZi5KzZF
MUk9PKJLJMs1Xbfx/kHJpPB53rkBD5I0TJfGyBaP9NDF6E4EZqz3ugzfc/v69TCp
sqI+597ePkHftNBvhww81P8PWDOg8vCbv7sPiM4Urz0bxBzWFTEbQv2Ip6xq5UEU
kD1+54HUIa9IDwa2Wk5CvwGO6p3c3Qum1zo3BTdEp5YFFq5rxz0DXhVu9VTYwGwB
ZbHsPn98vYtx/OUEhm6lwnPdPzcGo7Dhil+ssqlabUFnnZW5enX3uxk5lv6+CPxP
MzhW3VXPpy13xgHkXoU2XiAmbqT64tzhDmQFegqYWUVEDGPvcO+0xRHA+T+ZDOmj
FBGAdp4qLLMm2azLXAVqcOGZXknfmlmhMnP8IIpj5ZojsYR2AbM00W7qwYhqkETb
v0G4i53KgfPBSRfenE2QXJW/67aoDqmZXRUrxSt2xFfzzr75NeNL/3I52OM0jMVE
E7IqH91Ha9gyZvbBJIqkjnnTWgMw1FQILA0mbKwWlxQ76bSBF98yMQ6H2ZNprpf0
da76BUw2o4zn0pY/B1ZM
=MxdN
-----END PGP SIGNATURE-----

--/WyilgS7+6IU2yVA--