I saw a unique error on the log:
Jul 15 10:37:27 pg-mx-srv pgpool: 2011-07-15 10:37:27 ERROR: pid 23970:
pool_init_pool_passwd: couldn't open /etc/pgpool2/pool_passwd. reason:
Permission denied
Which are the permissions of this file on your system?
Which is the log directory and its permissions?
Are you using JDBC for establish the connection with your Java application?
You should read the pgpool's resctrictions with JDBC because, this
driver uses PREPARED STATEMENT and it is not supported yet by the
middleware.
El 7/15/2011 4:55 AM, David Hartveld escribió:
Op 14-07-11 20:29, Marcos Ortiz schreef:
Can you send to us the pgpool's logs?
Attached the log file (+/- 665 kB). Note that it unpacks into a 56+ MB
file.
On 07/14/2011 11:53 AM, David Hartveld wrote:
Hi all,
I'm experimenting with PGPool2 v3.0.4 in load-balancing master-slave
mode with streaming replication, with two slaves. I'm running a java
application, and once in a while a PSQLException with the message
'org.postgresql.util.PSQLException: ERROR: portal "" does not exist' is
thrown when executing a statement. I was wondering whether this is a
known problem - I regularly run into it when using multiple (test)
clients to connect to the server.
I've attached the pgpool conf file I'm using. If more information is
needed to diagnose this problem, I can provide it.
Thanks,
David Hartveld
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
--
Marcos Luís Ortíz Valmaseda
Software Engineer (UCI)
Linux User # 418229
http://marcosluis2186.posterous.com
http://twitter.com/marcosluis2186
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
