help.
On Monday, April 14, 2014 1:35 PM, Albe Laurenz wrote:
Anupama Ramaswamy wrote:
> I would like to setup a 2 servers with streaming replication, one master and
> another hot standby.
> I want to use the standby for read-only queries. So I want the replication
> lag to be
Thanks so much. That clarifies.
-Anupama
On Monday, April 14, 2014 12:09 PM, Michael Paquier
wrote:
On Sat, Apr 12, 2014 at 3:12 PM, Anupama Ramaswamy wrote:
> Lets suppose at this point there is 0 delivery lag but bytes of replay
> lag.
>
All your answers are h
Hi All,
I would like to setup a 2 servers with streaming replication, one master and
another hot standby.
I want to use the standby for read-only queries. So I want the replication lag
to be as small as possible.
So I choose streaming replication over WAL shipping.
When the master fails, I want
Thanks for your response.
>>There are two lag types to consider about in case of a normal
>>streaming replication - delivery lag and replay lag. The secondary
>>will completely catch up to what have been delivered, but what have
>>not been is going to be lost. See [1][2].
Ok, I understand. I want
I have 2 postgres nodes setup in a replication and hot standby configuration. I
am using pgpool for automatic failover and load balancing the read queries.
I have setup scripts for automatic failover when the master node fails. I want
to understand how it would work in the following 2 scenarios.
Hi,
I am trying to use plperl for one of my triggers. The trigger executes a
query.
So I am preparing the query and caching it as below:
if (!defined $_SHARED{'base_table_query'}) {
my $base_columns_query = "select column_name from
inf
