| 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: | Whole Thread | Raw Message | 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?
| 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 |