On Mon, 22 Aug 2011 09:38:09 +0200 Olivier NOEL <[email protected]> wrote:
> >> It seems that you failed in installation of pgpool_walrecrunning(). > >> pgpool_walrecrunning() is the function that is necessary to recognize > >> a primary node in pgpool-II 3.0.x. > >> You have to execute install-functions.sh again. > >> install-functions.sh can download from tutorial page. > > > > I installed them afterwards, but still have these errors. > > > > I will check the database. > > 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' > > but the pgpool_* scripts are stored in the public schema. I will try > with the scripts in the pgpool_catalog schema. No, system DB is used in parallel query mode or query cache. So it is unrelated. The installation of the functions is required on all backends, not system DB. -- Toshihiro Kitagawa SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
