replication help ... - Mailing list pgsql-admin

From Sunil N Shinde
Subject replication help ...
Date
Msg-id KL1PR0601MB14133B228F47192BC59F0C6EEEC90@KL1PR0601MB1413.apcprd06.prod.outlook.com
Whole thread Raw
Responses Re: replication help ...
List pgsql-admin

Hi,

 

I need to create some concrete document regarding the replication method.

We want to suggest best method for load balancing to client.

 

I have gone through the below link. But could not formulate the exact document to put forward to  client regarding the best solution .

 

                https://www.postgresql.org/docs/9.5/static/high-availability.html

 

I am bit confused with the terms Hot standby, warm standby, streaming replication, log shipping, synchronous, asynchronous, etc.

I can understand the meaning and definition. But I am unable to consolidate in a proper manner or order or unable to correlate with each other.

 

Can someone please help me in this regard?

 

 

Thanks & Regards,

Sunil N Shinde

 

pgsql-admin by date:

Previous
From: David DeMann
Date:
Subject: Streaming basebackup initialization does not capture pg_xlog transfer on replica.
Next
From: Tomáš Uko
Date:
Subject: Re: Problem with extension