<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi all,<br>
<br>
I saw the email thread below and suspect I am experiencing the same
or a similar problem. I am running 2 independent pgpool instances
on separate servers against a primary/hot standby postgres pair.
The two pgpools don't seem to recognize each other's cache
invalidating activity. (I have enable_query_cache = true,
load_balance_mode = on, master_slave_mode = on and pgpool regclass
installed on both PG servers.) Do I really have to turn caching
off, or can watchdog or something else resolve this problem?<br>
<br>
The example below shows updates on pgpool 1 not being recognized by
the pgpool 2:<br>
<pre><i>From PGP1 create table family(name text);
</i><i>From PGP1 insert into family values('Bob');</i><i><i></i>