[Pgpool-general] health_check user

2010-02-16 Thread Daniel . Crespo
Hi, I'm using pgpool-II 2.2.2. I password protected the database for every user, including 'postgres'. However, I made the .pgpass in the corresponding home directories in order to have access without explicitly providing password. If I password protect postgresql (by changing pg_hba.conf of

Re: [Pgpool-general] health_check user

2010-02-16 Thread Jaume Sabater
On Tue, Feb 16, 2010 at 4:40 PM, daniel.cre...@l-3com.com wrote: I’m using pgpool-II 2.2.2. I password protected the database for every user, including ‘postgres’. However, I made the .pgpass in the corresponding home directories in order to have access without explicitly providing password.

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

2010-02-16 Thread Tatsuo Ishii
If you just need to parse multi statement SQL, it is already possible. For example, see around line 197 of pool_proto_modules.c: parse_tree_list = raw_parser(string); Here parse_tree_list is a list of statements. If string is a multi statement SQL, parse_tree_list will be consisted of

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

2010-02-16 Thread Tatsuo Ishii
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

[Pgpool-general] pgpool Pid Error

2010-02-16 Thread Rahul Reddy
Hello, After installing pgpooll 2.2.2 on a pgpool directory inside where i installed PosgreSQL 8.4.2, I get the following error message when i type pgpool -n -d. right after I install the pgpooll: pool_config: could not open configuration file (pgpool.conf) pool_config: using default

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

2010-02-16 Thread nicolas prochazka
hello, we are using postgresql 8.3.7 for this test with postgresql-8.4-701.jdbc4.jar our tests is in this case simple bad sql request ( select * from table does not exist). this test with pgpool II 3.1 is ok, error is returning. Nicolas 2010/2/17 Tatsuo Ishii is...@sraoss.co.jp: Could not