On 01/04/2012 12:41 PM, Saurabh wrote:
Thank you all for the valuable information. Now we have decide to go
with streaming replication. I did the setup on machine and it is
working good. Now I have to implement the automatic failover. Please
share a solution for the same.
Saurabh Gupta
You ca u
Thank you all for the valuable information. Now we have decide to go
with streaming replication. I did the setup on machine and it is
working good. Now I have to implement the automatic failover. Please
share a solution for the same.
Saurabh Gupta
--
Sent via pgsql-performance mailing list (pgsq
On 12/29/2011 05:00 PM, Claudio Freire wrote:
Second, is that WAL activity on streaming replication or WAL shipping
is documented to contain more data than on non-replicated setups. What
is not clear is how much more data. This not only affects our network
bandwidth estimations, but also I/O load
On Thu, Dec 29, 2011 at 3:33 AM, sgupta wrote:
> I am doing POC on Posgtresql replication. I am using latest version of
> postgresql i.e. 9.1. There are multiple replication solutions avaliable in
> the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built
> replication solution
On Thu, Dec 29, 2011 at 11:33 AM, Aleksej Trofimov
wrote:
> Postgres Streaming replication is WAL based replication, so using this type
> of replication you will have absolutely identical database servers, what is
> best choice for HA and scaling reads. Also this choice is not practically
> affect
On 12/29/2011 11:33 AM, sgupta wrote:
I am doing POC on Posgtresql replication. I am using latest version of
postgresql i.e. 9.1. There are multiple replication solutions avaliable in
the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built
replication solutions (Streaming rep
I am doing POC on Posgtresql replication. I am using latest version of
postgresql i.e. 9.1. There are multiple replication solutions avaliable in
the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built
replication solutions (Streaming replication, Warm Standby and hot standby).