[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4

[Toshihiro Kitagawa]

On Mon, 22 Aug 2011 10:42:48 +0200
Olivier NOEL <nolivfr at gmail.com> wrote:

> 2011/8/22 Toshihiro Kitagawa <kitagawa at 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'
> >>
> >> 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.
> 
> 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 at 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?

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan