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
Attachment:
signature.asc
Description: PGP signature
