> 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; }; do
> > 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
> > 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
> 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
> Thanks for answering Tatsuo,
> The test I did was:
>
> 1) for loop inserting 50 values to a table.
> 2) stop one of the servers (in that moment the client in
> the loop gives the
> error I commented)
> 3) The online backup starts and works perfectly.
> 4) I look for all the values in the table,
> Hi,
> I do not directly use a Serial data type.
> I would like to understand the reasons that are behind your advice.
> Could you explain why?
> Thanks,
> Christophe Philemotte
If use serial for async ( or everything that log base ) will cause time
diferent and value different on heavy load or
> # Force to flush current value of sequences to xlog
> psql -p $port -t -c 'SELECT datname FROM pg_database WHERE
> NOT
> datistemplate AND datallowconn' template1|
> while read i
> do
> if [ "$i" != "" ];then
> psql -p $port -c "SELECT setval(oid,
> nextval(oid)) FROM pg_class
> WHERE relkin
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
is pgpool handle transaction before call
send_simplequery_message or
pool_write_and_flush
i mean that every sql statement will collect , just before 'commit transaction'
which one function that should be user for that purpose ?.
___
Pgpoo
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
Some information that I want to Know,
is there any separate execution between select and update ( SQL INSERT or SQL
UPDATE ) ?.
___
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
Which one should modified ?
Try linking against the .so containing the function.
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
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 (
sqlite_
15 matches
Mail list logo