Re: Postgres streaming replication

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.
>
> * 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?

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.
2) Read the documentation:
https://www.postgresql.org/docs/current/high-availability.html
--
Michael