replication help ...

From: Sunil N Shinde <Sunil(dot)Shinde(at)mastek(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: replication help ...
Date: 2016-09-22 04:51:00
Message-ID: KL1PR0601MB14133B228F47192BC59F0C6EEEC90@KL1PR0601MB1413.apcprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomáš Uko 2016-09-22 10:46:59 Re: Problem with extension
Previous Message David DeMann 2016-09-21 22:40:48 Streaming basebackup initialization does not capture pg_xlog transfer on replica.