Re: [Pgpool-general] function save_pending_data

for save_pending_data. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Bug report pgpool-II-2.3.1 plus ODBC

Hi, Toshihiro Kitagawa fix the problem. I have committed the changes into CVS Head. Please try it out. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I'm not familiar with unixODBC, but I guess it uses older protocol (version

Re: [Pgpool-general] psql: server closed the connection unexpectedly

stale one. Can you stop pgpool, remove the file and start pgpool? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] pgpool 2.3.x never connect to backend0

say there is problem with permissions of logdir. Don't know. Maybe SE Linux thing? strace might show some hints... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Thank you ! Tatsuo Ishii a écrit : It seem's to be a problem

Re: [Pgpool-general] pg_dump

for other people. 1. Does pgpool have a special treatment of pg_dump? No. 1.a If load balancing is enabled, are the SELECT commands of pg_dump also balanced? Since pg_dump always starts a transaction, the SELECT commands of pg_dump are always executed on the master. -- Tatsuo Ishii SRA OSS, Inc

Re: [Pgpool-general] Online recovery during load

and write requests. Great! -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

[Pgpool-general] pgpool-II 2.3.2 released

PARSE in all nodes, this was pointless and caused problem (kind mismatch when executing DEALLOCATE)(Tatuso) You can download the source code from: http://pgfoundry.org/frs/download.php/2562/pgpool-II-2.3.2.tar.gz -- Tatsuo Ishii SRA OSS, Inc. Japan English: http

Re: [Pgpool-general] pgpool locking

to have pgpool just degenerate any backend that is not available within some configurable period of time. Have you enabled health checking? It should be able to detect this network failure. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Difficulty keeping things in sync

pgpool-II 2.3.1 has a problem with unixODBC(=older protocol). pgpool-II 2.3.2 should have solved the problem. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I'm looking through the logs on some of the other affected programs

[Pgpool-general] pgpool-II 2.3.x problem

will release pgpool-II 2.3.3 soon. If you hurry, please use included patches. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Index: pool_process_query.c === RCS file

Re: [Pgpool-general] all backends are down

Hi, You might have corrupted pgpool_status file as $logdir/pgpool_status. Please stop pgpool, remove it and start pgpool. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I get from pgpool-II (2.3.2) Cannot accept() new

Re: [Pgpool-general] pgpool-II 2.3.x problem

. That's one of the reasons why I didn't notice until today (my gcc is 3.3.6). So you may or may not see the bug depending on the version of gcc. I will release pgpool-II 2.3.3 soon. If you hurry, please use included patches. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp

Re: [Pgpool-general] Incorrect port (9999) for pgpool?

it If you have logdir directive in pgpool.conf, say, /var/log/pgpool, it's located at: /var/log/pgpool/pool_status If you do not have, the default value for logdir is /tmp. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Howto analyse sql statement.

the query is BEGIN, you can check if it is either TRANS_STMT_BEGIN or TRANS_STMT_START. Hope this helps, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool

Re: [Pgpool-general] Howto analyse sql statement.

of two or more nodes. However rest of codes does not support multi statment SQL. So there's a long way before we supoort it. I would like to make some progress this year. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp On this case

Re: [Pgpool-general] Probleme with pgpool-II-2.3.2.1 and JDBC drivers

Could not reproduce here. I'm using postgresql-8.4-701.jdbc4.jar as well. Can you provide me a complete test case? (Java program) -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp hello, pgpool-II-2.3.2.1 is buggy from jdbc

Re: [Pgpool-general] server closed the connection unexpectedly on sql syntax errors

This has been fixed in 2.3.2.1. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp running pgpool-II (2.3.2), replication mode with 2 backends when running select * from testtable; and the table does not exist, instead

Re: [Pgpool-general] pgpool Pid Error

In addition to this, I would suggest to use strace to track file accesses. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hi Rahul, Check that the file you moved is an init-script (which accepts the start and stop

Re: [Pgpool-general] Cluster pgpool-II + PHP

because number of messages returned from vacuum may vary on each backend(I have a plan to improve this). Otherwise you could made these commands over pgpool or over each backend. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] [GENERAL] pgpool error, pid not found!

. can you advice me which linux compiler I can use? Plane gcc is fine. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Thanks On Thu, Feb 18, 2010 at 7:26 PM, Tatsuo Ishii is...@sraoss.co.jp wrote: The last version of pgpool

Re: [Pgpool-general] pgpool Pid Error

Just use ps to find pgpool parent process and kill it by SIGTERM (smart shutdown) or SIGINT/SIGQUIT(fast/immediate shutdown). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I guess i know what the problem is. I have

[Pgpool-general] pgpool-II 2.3.x problem

(current_timestamp, current_date, now() etc) I'm going to release 2.3.2.2 today. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] pgpool losing queries

How do you judge your queries lost? If an insert query commits *and* you do not see the data, that's definitely a serious problem. On the contrary if you do not confirm the query gets committed, then it's not surprising at all. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp

Re: [Pgpool-general] JDBC autocommit and hanging locks

we need is, not to send parse/bind message to unneccessary backends in load balance mode. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I think you may have missed where the problem is. Pgpool-II never sends the sync message

Re: [Pgpool-general] thousands of queries from pgpool to one of the backends (queries I don't do)

Unless you have those queries in reset_query_list, there's no possibilty for pgpool to send such queries. It seems you have a back door on backend1. I recommend you to enaale log_connections to see who is sending the query. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp

Re: [Pgpool-general] health check failed due an Interrupted system call

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 English: http://www.sraoss.co.jp

Re: [Pgpool-general] handling of sequences

may involves SERIAL rewriting. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool

Re: [Pgpool-general] The Unplugged wire

not receive any SIGALARM, so, it waits (I think) till the system closes the connection. The retry should be turn off if it's called from health_check(). Will fix. Thanks again for good testing and analysis. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese

Re: [Pgpool-general] handling of sequences

challenging. I assume you are talking about tables having SERIAL column. We already have such that technology for TIMESTAMP rewriting and should be no problem. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] pgpool crashing(?) at startup

Sorry for delay. Toshihiro Kitagawa identified your problem was fixed in pgpool-II 2.2.4. Please upgrade. http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/main.c.diff?r1=1.49r2=1.50f=u -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Pgpool-general Digest, Vol 64, Issue 2

/write, next round health checking will detect the failure and do fail over. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] Pgpool with many inserts and updates

obtain better than it, still it is slightly lower than 100%. So first thing you should do is, to prepare good hardwares and to tune PostgreSQL to get enough write performance for your applications. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] The Unplugged wire

Daniel, I have committed fix into CVS HEAD. Could you try it out? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Thanks to you Tatsuo,... I am glad my report helped you! As soon as you tell me it is done I will start

Re: [Pgpool-general] The Unplugged wire

Daniel, Looks like interrupted connect() ought to check if SIGQUIT has been delivered. Will check. I have no time until next week though. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hi Tatsuo, I did some more debug

Re: [Pgpool-general] pgpool ii logs

, which is overkill. Sorry for inconvenience. Currently there's no way to do it. Actually it's easy to implement to enable/disable the debug log by reloading pgpool.conf. Patches are welcome... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] The Unplugged wire

Daniel, I have committed fix for this. Please check it out. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Daniel, Looks like interrupted connect() ought to check if SIGQUIT has been delivered. Will check. I have no time

Re: [Pgpool-general] Multi-statement queries

are not synchronized. With multi-statement query, type select;select.;select seems run well. Not really. What if: SELECT 1;SELECT nextval(..);... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Regards. 2010/3/9 Glyn Astill

Re: [Pgpool-general] Cannot trigger out-of-sync

. Can you prvide concrete examples? i.e. pgpool-II version, data and SQL. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] pgpool freeze when pcp_recovery_node fails

Sometimes, recovery fails with the second node saying i.e.: Mar 12 05:38:28 db20 postgres[32140]: [5-1] 2010-03-12 05:38:28 SGT LOG: invalid primary checkpoint record Mar 12 05:38:28 db20 postgres[32140]: [6-1] 2010-03-12 05:38:28 SGT LOG: could not open file

Re: [Pgpool-general] The Unplugged wire

This will miss some house keeping jobs such as count down connection counter. Thus you will be in trouble when you do online recovery. You would want to use child_exit(0) instead exit(0). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] pgpool handling slaves and disconnect and reconnect

Does pgpool 2 queue the sql statements when a slave gets disconnected? so that when it reconnects it will catch up? No. Or does this handle it differently? You should considier online recovery in this case. See docs for more details. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http

Re: [Pgpool-general] The Unplugged wire

Thanks again Tatsuo, You are welcome! -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I've been giving it a try, and, it seems, as you say, that with exit(0) something goes wrong with the recovery, but, agains as you say

Re: [Pgpool-general] The Unplugged wire

between (1) and (2) the information that we were interrupted will be lost. This window cannot be removed. So the only way is to call child_exit(0) in the signal handler. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Online recovery during load

to fail. The only soltuin is for pgpool to force disconnecting such connections. Such patches has been already proposed and I've been looking into this. http://lists.pgfoundry.org/pipermail/pgpool-hackers/2010-March/000292.html -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp

Re: [Pgpool-general] race conditions in master-slave configuration

are not available. The other idea is using replication mode, instead of master_slave mode. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Tomasz Stachewicz Here's our pgpool.conf: # # pgpool-II configuration file

Re: [Pgpool-general] The Unplugged wire

Thanks for the report. Can you inspect what consumes the 10 seconds? I think strace can be used for the purpose. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Ok, thanks Tatsuo, I testet the latest code (the one of 2010-04

Re: [Pgpool-general] Online recovery timeouts

of pgpool-II 2.2 and 2.3 tree. We expect that this will be done within one or two weeks and after that we will start 2.4 development which will include the functionality mentioned above. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] can't attach two nodes simultaneously

Am 15.04.2010 06:34, Tatsuo Ishii wrote: 2. Is there a way to attach multiple nodes in an atomic way? Why do you need atomicity for this? Because only then it is guaranteed that the databases will be in sync. Consider this: 1. pgpool with 2 backends 2. 2 backends are detached

Re: [Pgpool-general] Online recovery timeouts

of the value of client_idle_limit_in_recovery. In this case you can set -1 to client_idle_limit_in_recovery so that pgpool-II immediately disconnect such busy clients before entering the 2nd stage. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Pgpool and DBT2

your question... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Pgpool and DBT2

pgpool-II forks child processes and you need to attach one of them. If you can run pgpool-II with num_init_children = 1, that's the easiest way since you don't need to worry about chosing the right process. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese

[Pgpool-general] PGCon 2010

Hi, I'm going to attend PGCon 2...@ottawa(no plan to have a talk. Sorry). If you have a plan to attend it, le's discuss on pgpool-II there! Maybe with some beer:-) -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

:50 DEBUG: pid 2460: pool_process_query: kind from backend: D 2010-05-11 09:49:50 DEBUG: pid 2460: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1 2010-05-11 09:49:50 DEBUG: pid 2460: pool_process_query: kind from backend: D -- Tatsuo Ishii SRA OSS, Inc. Japan English: http

Re: [Pgpool-general] pg_terminate_backend triggers failover on pgpool when used as standalone pool

a failover). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Index: main.c === RCS file: /cvsroot/pgpool/pgpool-II/main.c,v retrieving revision 1.66 diff -c -r1.66

Re: [Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

. But I am not sure that solves the problem at all. Actually you still have a problem. I will investigate the problem further, but if somebody on this list who are really familiar with OpenSSL could help me, I will really appreciate. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http

Re: [Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

better thing. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp But it can't load in the web. The following query runs from our application: SELECT p.proname,p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n

Re: [Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

Sean, Glad to see your reply! Your work was great and I appreciate your contribution. Please take a look at the issue when you have eough time. Yes, I came across to some conclusions but I will appreciate if you check whether my modifications are sane at all. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4

) libc.so.6 = /lib/i686/libc.so.6 (0xb7cf3000) libdl.so.2 = /lib/libdl.so.2 (0xb7cef000) /lib/ld-linux.so.2 (0x8000) Do you have libdl.so shown? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp After upgraded

Re: [Pgpool-general] about num_init_children and max_pool

. For example, default setting of max_pool = 4 and num_init_children = 32 requires max_connections = 131 at least(assuming superuser_reserved_connections = 3) for #1, 259 for #2. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4

Probably your SA forgot to install PostgreSQL dev packages? I saw similar complains in the list: http://archives.postgresql.org/pgsql-bugs/2009-09/msg00286.php -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp No, I don't see

Re: [Pgpool-general] pool_flush_it: write failed to backend(0)

closed the connection by some reasons. Check the PostgreSQL log file. Running PostgreSQL in debug mode might give you more info. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool

Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4

enable SSL support in pgpool-II. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Probably your SA forgot to install PostgreSQL dev packages? I saw similar complains in the list: http://archives.postgresql.org/pgsql-bugs/2009

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

handle it in he's free time Looks reasonable idea to me. I would like to include it in the next major release. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

. Anyway I will add a switch to enable/disable the functionality for the backward compatibility sake. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool

[Pgpool-general] My blog regarding PostgreSQL and pgpool-II

Hi, I just want to let you know that I have started my *first* English blog at: http://pgsqlpgpool.blogspot.com/. I will post articles regarding PostgreSQL and pgpool-II. Thanks, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

to true. If false, pgpool-II just terminates the session. Default is false. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org

Re: [Pgpool-general] Basics of replication with pgpool-II - how does it work? compared to Slony? to Postgres log shipping?

any automatic failover/load balancing functionality while pgpool-II has. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] website : link of current download is inorrect

on home page: The latest version of pgpool-II is 2.3.3. , links to: http://pgfoundry.org/frs/download.php/2572/pgpool-II-2.3.3.tar.gz which downloads file named: pgpool-II-2.3.2.2 Thanks for letting know me. Will fix. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

nodes: Node 0: A Node 1: A Node 2: B Node 3: B Unfortunately no one looses. In this case we chose Node 2 3 as victims since Node 0 votes A. Can you please modify your proposal? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

without throwing an error to the client part would be extremely hard to implement since other concurrent sessions might connects to the victim backend in the middle of processing. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Basics of replication with pgpool-II - how does it work? compared to Slony? to Postgres log shipping?

will allow user to choose degeneration in this case or not in addition to reporting errors. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp I am concerned because I have an environment with seven backends in load_balance_mode

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

Thanks. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp When set to true, if a SELECT statement returns a result set of records different between the backends, the backends that differ from most frequent result set

Re: [Pgpool-general] Basics of replication with pgpool-II - how does it work? compared to Slony? to Postgres log shipping?

Thanks for the suggestion, Aleksey. I'm not very good at writing English, so if someone come up with addition to the doc, I will appreciate. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Dear Tatsuo, Thanks, that's

[Pgpool-general] Talk at CHAR(10)

Hi, I'm going to give a talk at CHAR(10) on July 2nd in England. Conference home page: http://www.char10.org/ Talk schedule: http://www.char10.org/talk-schedule If someone on the list is going to the conference, I'm looking forward to meeting you there! -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] installing pgpool-recovery.sql : no schema has been selected to create in

the function into the pubic schema, then that is your own problem, not pgpool's. You should already have same issum with other functions. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] rawmode failover

connection after backend_hostname0 goes down? Enabling health checking should help you. If the health checking find backend goes down, it will trigger failover immediately, rather than first attempt to access the database via pgpool. So next attempt to connect pgpool will success. -- Tatsuo Ishii SRA OSS

Re: [Pgpool-general] Duration of commit on more than one backend configuration

. Is this correct? Correct. This is a known behavior of all synchronous replication systems. This ensures that committed data (from client's point of view) is actually committed to all backends. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Duration of commit on more than one backend configuration

On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: As far as I know, pgpool-II waits for [all] backends to commit the SQL statements (under replication mode) before returning to the client, right? This means that if, for example, one of the backends is very busy (100% CPU, etc.), pgpool

Re: [Pgpool-general] Duration of commit on more than one backend configuration

On 06/21/2010 10:16 PM, Tatsuo Ishii wrote: On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: As far as I know, pgpool-II waits for [all] backends to commit the SQL statements (under replication mode) before returning to the client, right? This means that if, for example, one of the backends

Re: [Pgpool-general] doubt with log!!!

. That means for the first time you run pgpool it will not find the file and automatically creates it for the next time. Bottom line is, don't worry about it. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Order of Query Results

to look into this. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Order of Query Results

very old PostgreSQL protocol(call version 2 protocol), implemented in PostgreSQL 7.3 or before. But you said your PostgreSQL is 8.4.4. Is there anything special with your DB application? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Order of Query Results

PostgreSQL is 8.4.4. Is there anything special with your DB application? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Is there anything special with your DB application? Ya, to put it nicely, it's old as dirt thanks

[Pgpool-general] Preview of pgpool-II 3.0

failover when there's only one DB node(Tatsuo) - -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list

Re: [Pgpool-general] Problem with tables with same name

Is there any function provided by PostgreSQL which returns schema_name.table_name (or table oid) from table name which is not schema qualified? If such function exists, we could fix pgpool-II... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Problem with tables with same name

Great! -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp It works now. Thanks! On 10 August 2010 01:14, Tatsuo Ishii is...@sraoss.co.jp wrote: Marcin, I have made one line patch to make pgpool consider schema search

Re: [Pgpool-general] Setting up connections config for load-balancing

? DB nodes' information(backend_hostname, backend_port, backend_weight, backend_data_directory, only if you need to do the online recovery) must be set as the replication mode. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Setting up connections config for load-balancing

? Yeah, it has been in TODO list for a while. Probably stealing logger process code from PostgreSQL is the easiest. I just don't have time until now... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp

Re: [Pgpool-general] Combining pgpool and pgbouncer

a client finishes the transaction, pgbouncer disconnects to PostgreSQL. Question is, what does pgbouncer deal with session span data, such as temporary tables or datestyle set by SET command? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http

Re: [Pgpool-general] Setting up connections config for load-balancing

, if two backends are assigned 1.0, * then each backend will get RAND_MAX/2 normalized weight. */ -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing

Re: [Pgpool-general] Combining pgpool and pgbouncer

in Transaction mode. Ok. Also I guess in Transaction mode extended protocol cannot be used (i.e. Java cannot be used). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general

Re: [Pgpool-general] Setting up connections config for load-balancing

node which previously went down and admin forgot to resync with database. Upcoming 3.0 has an option to remove it before starting up BTW. Hmmm. You might want to display a more user-friendly value for the user, though, no? Good point:-) I'm thinking about to change it for coming 3.0. -- Tatsuo

Re: [Pgpool-general] Cool web interface?

://pgfoundry.org/frs/download.php/2494/pgpoolAdmin-2.3.tar.gz -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http

Re: [Pgpool-general] function epoch seems to be causing error

Looking into this now. Pgpool-II is not very smart in rewriting complex default values. I think you hit the case. Let me think about work arounds for this... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hello, I am trying

Re: [Pgpool-general] function epoch seems to be causing error

not, do no perform query rewriting. Ideally we'd better to rewrite such column, I have no idea how to do it... -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Looking into this now. Pgpool-II is not very smart in rewriting complex

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

Le 20/08/2010 15:04, Guillaume Lelarge a écrit : Le 20/08/2010 01:49, Tatsuo Ishii a écrit : hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti can't find getopt.h file , i just have an getopt_.h from gnulib but is not enough to compile it. There is a way

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

Le 21/08/2010 09:25, Tatsuo Ishii a écrit : Le 20/08/2010 15:04, Guillaume Lelarge a écrit : Le 20/08/2010 01:49, Tatsuo Ishii a écrit : hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti can't find getopt.h file , i just have an getopt_.h from gnulib

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

Le 22/08/2010 08:36, Tatsuo Ishii a écrit : Le 22/08/2010 00:35, Tatsuo Ishii a écrit : Le 21/08/2010 09:25, Tatsuo Ishii a écrit : Le 20/08/2010 15:04, Guillaume Lelarge a écrit : Le 20/08/2010 01:49, Tatsuo Ishii a écrit : hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7

Re: [Pgpool-general] Replication conncetions failing; help with debugging?

and 60 seconds (and since this is pgreplay, it's running the exact same queries each time). So it's not on the first statement. What does detect error: kind: S mean? It's normal. pgpool just finds that backend returns S(parameter status). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http

Re: [Pgpool-general] [Pgpool-hackers] Plan for pgpool-II 3.0 beta2 and more...

goes well, RC1 will be turned into official 3.0 release and will be released on Friday September 10th. Cross fingers... Please note that all dates are in JST(+0900). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hi pgpool

<    1   2   3   4   5   6   >