Skip site navigation (1) Skip section navigation (2)

Streaming Replication in PostgreSQL9.0 b4: Standby dropping connections

From: Chip Steele <steele(dot)chip(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Streaming Replication in PostgreSQL9.0 b4: Standby dropping connections
Date: 2010-08-18 15:20:20
Message-ID: AANLkTi=ttkhK+u91H0rqmkBH-2Yycupa+q7KP=mQDxuG@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

   In PG9.0-b4 I have successfully set up a primary-secondary pair with
streaming replication, with the secondary in hot_standby mode.

 I have an application on the standby (and primary) which has constant
connections open to the database. Occasionally it refreshes its cache of
data from the hot_standby secondary server.
I am intermittently getting and error when updating the application's cache.
When I check the PostgreSQL logs with the same timestamp, I see the
following messages:

FATAL: terminating connection due to conflict with recovery
DETAIL: User query michg have needed to see row versions that must be
removed.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.

Now, this message seems to explain the problem, but I couldn't find anything
in the streaming replication documentation indicating that this sort of
thing might occur. Is there any way to avoid it?
Any further information about this specific problem?

Thanks in advance,

Chip

pgsql-novice by date

Next:From: A BDate: 2010-08-18 15:56:17
Subject: how to add "on delete cascade" to a foreign key constraint?
Previous:From: Sean AndersonDate: 2010-08-18 15:15:27
Subject: Re: List of User Defined Types?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group