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 does not exist >> >> On master : >> >> 10:36 pgsql@fpg01:~$ psql -U pgpool pgpool >> psql (9.0.4) >> Saisissez « help » pour l'aide. >> >> pgpool=> select pgpool_walrecrunning(); >> pgpool_walrecrunning >> ---------------------- >> f >> (1 ligne) >> >> On slave 1 : >> >> pgpool=> select pgpool_walrecrunning(); >> pgpool_walrecrunning >> ---------------------- >> t >> (1 ligne) >> >> On slave 2 : >> >> pgpool=> select pgpool_walrecrunning(); >> pgpool_walrecrunning >> ---------------------- >> t >> (1 ligne) >> >> >> f for false and t for true ? So why doesn't pgpool found my master node? > > 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. > -- > Toshihiro Kitagawa > SRA OSS, Inc. Japan > > _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general