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
FATAL: terminating connection due to conflict with recovery
DETAIL: User query michg have needed to see row versions that must be
HINT: In a moment you should be able to reconnect to the database and repeat
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,
pgsql-novice by date
|Next:||From: A B||Date: 2010-08-18 15:56:17|
|Subject: how to add "on delete cascade" to a foreign key constraint?|
|Previous:||From: Sean Anderson||Date: 2010-08-18 15:15:27|
|Subject: Re: List of User Defined Types?|