Re: Postgres streaming replication

--1hKfHPzOXWu1rh0v
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Jan 08, 2020 at 05:04:21AM +0000, Daulat Ram wrote:
> I have to implement the streaming replication for our prod environment.
> Can you please share the list of parameters to setup the PostgreSQL
> 11 streaming replication with continuous archiving and give clarity
> on the below.
>=20
>   *   Do we need to enable the archive_mode and archive_command
> parameters at standby side if implementing PostgreSQL 11
> streaming replication with continuous archiving  ?
>   *   What is the benefits for implementing streaming replication
> with continuous archiving over the PostgreSQL Streaming
> replication?=20

I think that you need to do two things and take the necessary time to
do both:
1) List on a sheet of paper all your requirements, your expectations
and what kind of tradeoffs you are ready to make for your cluster
configuration when it comes to potential data loss, and the amount of
data retention you are willing to have around.  There is no way to
tell what's good or not for your product if you don't know that
first.=20
2) Read the documentation:
https://www.postgresql.org/docs/current/high-availability.html
--
Michael

--1hKfHPzOXWu1rh0v
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4WrcIACgkQnvQgOdby
QH0J1Q/+PQXzujT8MYOaH/V65pdzCS7F7uTXEh4Foy3ElnGd2PlWirLf+FMitnCH
PgywkLYCg8stlT08aTh074Fhy1guQLgECvZ0tYUIz6dDVVgl0ggKc9abffOm2njH
8aMdUHdSl+9Rep+EvwWgP2Jg/Ye8FNqCRJRL9zE0d1jgXDpVdR9RVLGhXC2Zzs/l
hB2O49RjldWekYCdZRg4jRZqept1bMD8iSpZww0dl1GPoq8+dNm5nvJBuolGqWkd
o4vi5ofqoxNlN1kpjOV/vd6d/kY41Qdkdn/rfzhHDcLlCZtbu+2puN8iOAZKknlD
WA5gEvv1lGB5QuPMNXS4D7abcNMt9ubZdHwnyU6c30ByiLVmCSH5u3a2ecjukJkk
cAM1VaRxbLpFd7m8MzSu2zOzQZVXz8oOtKnGOO9xWx0xHKPSQmGTUnO4ewoqijk3
8RDj8a3YM9LfDUWv0cc6ZG8S87lnjs9pyp0YZ0Wfibl+1m8p7+dbi55HPk1H/FDZ
qABii3aTSz0jCJlnVjwr9RpcQ2uZcDvGfk0fDfsW9KPjWL1hAiH7+U31GqKvUO0a
jUGNjhD1Dt8teygQ+SjR0hz+w3g1hel4gY5MVUNzPMMQILHWwSP6mRdbZB1CjULk
LDn/noIplE4MaESGkLUpaBJDlRdAzLSrqRQDao7Ns/5z04+p/bg=
=i6xf
-----END PGP SIGNATURE-----

--1hKfHPzOXWu1rh0v--