From: Gerd König <koenig@transporeon.com>
To: pgsql-admin@postgresql.org
Subject: pgpool-II question
Date: Fri, 23 Jan 2009 13:24:39 +0100
Message-ID: <4979B707.8030402@transporeon.com> (raw)
Hello,
while evaluating pgpool-II (replication mode) I ran into a situation
where I don't know the reason why....
The setup looks like:
---------------------
host "one": postgres8.3.5 (defined as backend_0) and pgpoolII (port 9999)
host "two": postgres8.3.5 (defined as backend_1)
According to the tutorial I created database "bench_replication" and
inserted dummy data => everything's fine
In the next step I wanted to create some error scenarios:
a) shutdown "two" while a running update statement
aa) psql -p 9999 bench_replication
ab) update history set tid=<whatever>;
ac) while the update is running, kill postgres on host "two"
=> pgpool got noticed about that and cancelled the update
b) shutdown "one" while statement is running
ba) psql -p 9999 bench_replication
bb) update history set tid=<whatever>;
bc) kill postgres on host "one" (same host where pgpool is running)
=> nothing happens, psql never ends the statement, even no debug entry
in the logfile of pgpool...?!?!?!
why doesn't pgpool recognize that postgres isn't running on host "one" ?
Am I missing something..?!?!
any help appreciated....GERD....
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: koenig@transporeon.com
Subject: Re: pgpool-II question
In-Reply-To: <4979B707.8030402@transporeon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox