1) Start postgres node2
2) Start postgres node1
3) start pgpool (node1)
4) From a remote terminal (client1):
for i in $(seq 0 2000); do { echo $(date +%H:%M:%S); psql
-d database -p
-h 192.168.1.5 -U postgres -c insert into pri values
($i, 'nom$i');;
echo $i; sleep 1; }; done
5)
What happen if in heath check, a backend is ok, soon
after health check, backend will unpluged ( so there is an
error backend ).
is there any query will failed ?
No problem.
Health checking is done by a separate process, i.e. pgpool
parent. So
even if pgpool children are blocked by
What happen if in heath check, a backend is ok, soon
after health check, backend will unpluged ( so there is an
error backend ).
is there any query will failed ?
No problem.
Health checking is done by a separate process, i.e. pgpool
parent. So
even if pgpool children are blocked by
Health check failed because PostgreSQL does not reply
within
health_check_timeout seconds. Please check PostgreSQL log.
If you
don't find anything strange there, probably the cause is
network
physical problem. Maybe switch or hub hardware problem?
Tatsuo Ishii
SRA OSS, Inc. Japan
What for function save_pending_data in pool_stream.c ?.
Thank you.
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
I read news that pgpool not include postgresql cluster favorite.
No Problema, pgpool still my favorite clustering.
Moch. Isnaini.
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
features include:
.
.
Let's populate t1:
INSERT INTO t1(id) VALUES(1);
Actual query executed by pgpool-II is:
INSERT INTO t1(id, regdate) VALUES
(1,'2009-11-15 21:35:01.783053+09');
which function will execute ?.
is it send_simplequery_message or another else ?.
I have a clue to add -lsqlite3 like information gcc -o simplesqlite3
simplesqlite3.c -Wall -W -O2 -Wl,-R/usr/local/lib -lsqlite3.
But in pgpool, compiling just
#make all
But howto modify in order make all should add -lsqlite3 ?.
I am sorry for poor english.
Thanks.
Muhammad Isnaini
Hi.
I am a student that beginner in pgpool.
I want to make a paper for my study that a topic is logging sql to sqlite.
Why SQL lite ?.
So simple.
I use pgpool II 2.2.2 ( latest ).
I have read pool_proccess_query.c.
I modified send_simplequery_message adding some line that use sqlite (