On Mon, 22 Aug 2011 14:07:42 +0200
Olivier NOEL noli...@gmail.com wrote:
2011/8/22 Toshihiro Kitagawa kitag...@sraoss.co.jp:
I have to put in the blacklist all the functions which contain DML/DDL
? I have 700+ functions...
There is white_function_list too, just in case.
In addition,
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'
On Mon, 22 Aug 2011 10:42:48 +0200
Olivier NOEL noli...@gmail.com wrote:
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'
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.
On Mon, 22 Aug 2011 11:52:35 +0200
Olivier NOEL noli...@gmail.com wrote:
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()
On Mon, 22 Aug 2011 12:41:13 +0200
Olivier NOEL noli...@gmail.com wrote:
2011/8/22 Toshihiro Kitagawa kitag...@sraoss.co.jp:
On Mon, 22 Aug 2011 11:52:35 +0200
Olivier NOEL noli...@gmail.com wrote:
2011/8/22 Olivier NOEL noli...@gmail.com:
2011/8/22 Olivier NOEL noli...@gmail.com:
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: pool_send_and_wait: Error or
notice message from backend: : DB node id: 1 backend pid: 10280
statement: message: cannot execute UPDATE in a
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
Are you able to connect to pgpool-II using psql?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
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
12 matches
Mail list logo