2011/10/6 Guillaume Lelarge guilla...@lelarge.info:
On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge
guilla...@lelarge.infowrote:
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
Hi everyone,
I'm experiencing
2011/10/6 Guillaume Lelarge guilla...@lelarge.info:
[...]
And it's not. Ok, there is some overhead, but it's veeery slow.
How did you check that?
You may be right in a specific setting, but I have no issues getting
better performance with pgpool.
We tested our java webapp with pgpool and
2011/10/6 Guillaume Lelarge guilla...@lelarge.info:
On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote:
2011/10/6 Guillaume Lelarge guilla...@lelarge.info:
[...]
And it's not. Ok, there is some overhead, but it's veeery slow.
How did you check that?
You may be right
Hi,
I compiled and installed pgpool 3.1 on Debian Wheezy yesterday. No
compile errors.
But I have a LOT of errors :
Oct 4 10:09:48 pgpool01 pgpool: 2011-10-04 10:09:48 ERROR: pid 1198:
Child process 7712 was terminated by segmentation fault
Oct 4 10:09:48 pgpool01 pgpool: 2011-10-04 10:09:48
2011/10/4 Olivier NOEL noli...@gmail.com:
The conf file you're using is a 3.0 one. I hope you don't use that for
3.1, as it may not work at all.
The conf file is essentially the same, no real differences, with the
exception of backend_socket_dir, which is deprecated
Your num_init_children
2011/8/22 Toshihiro Kitagawa kitag...@sraoss.co.jp:
Hello,
On Fri, 19 Aug 2011 18:11:52 +0200
Olivier NOEL noli...@gmail.com wrote:
Hello,
new problem :
2011-08-19 17:52:03 LOG: pid 8968: find_primary_node:
pgpool_walrecrunning does not exist
2011-08-19 18:01:25 LOG: pid 8990
2011/8/22 Toshihiro Kitagawa kitag...@sraoss.co.jp:
OK, I think I found :
In my config file :
# system DB info
system_db_hostname = 'fpg01'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = 'password'
2011/8/22 Toshihiro Kitagawa kitag...@sraoss.co.jp:
OK
All the backend have the functions since the streaming and replication
are working.
I have the same error, the functions are in public and pgpool_catalog :
2011-08-22 10:00:55 LOG: pid 10849: find_primary_node:
pgpool_walrecrunning
2011/8/22 Olivier NOEL noli...@gmail.com:
Yes, f and t are boolean values.
pgpool-II calls pgpool_walrecrunning() in postgres database.
Can you select pgpool_walrecrunning() in postgres database?
I will try to import the sql to the postgres database.
It works now
2011-08-22 11:38:12 LOG
2011/8/22 Olivier NOEL noli...@gmail.com:
2011/8/22 Olivier NOEL noli...@gmail.com:
Yes, f and t are boolean values.
pgpool-II calls pgpool_walrecrunning() in postgres database.
Can you select pgpool_walrecrunning() in postgres database?
I will try to import the sql to the postgres database
-only transaction
Pgpool seems to send the DML queries to all the backends, instead of
just the master. Is it normal ? Same config file as above.
I followed this tutorial :
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html
Olivier
2011/8/17 Olivier NOEL noli
2011/8/16 Tatsuo Ishii is...@sraoss.co.jp:
What operation did you do when you were getting errors below? Did you
try to connect to pgpool using psql? Or starting pgpool immediately
causes the errors?
Starting pgpool causes the errors
Also turning on debug mode of pgpool-II will give you
12 matches
Mail list logo