Question concerning replicated server using streaming replication used as a read-only reporting server

From: "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Question concerning replicated server using streaming replication used as a read-only reporting server
Date: 2013-01-17 17:49:32
Message-ID: F4E6A2751A2823418A21D4A160B6898892B84F@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have 2 servers which are using streaming replication (pg 9.0.4).

The secondary server is there primarily as a disaster recovery server,
but we are also using it for reporting, so as not to place undue load on
the primary server.

As I review the logs on the secondary server, I frequently see the
following:

2013-01-17 06:05:47 MST [local]ERROR: canceling statement due to
conflict with recovery

2013-01-17 06:05:47 MST [local]DETAIL: User query might have needed to
see row versions that must be removed.

2013-01-17 06:05:47 MST [local]STATEMENT: Select statement goes here

2013-01-17 06:05:47 MST [local]FATAL: terminating connection due to
conflict with recovery

2013-01-17 06:05:47 MST [local]DETAIL: User query might have needed to
see row versions that must be removed.

2013-01-17 06:05:47 MST [local]HINT: In a moment you should be able to
reconnect to the database and repeat your command.

Is there anything that can be done to mitigate this situation?

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2013-01-17 17:54:20 Re: centos install
Previous Message Ray Stell 2013-01-17 17:35:03 Re: Replication monitoring questions