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

[Olivier NOEL]

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

I will try to import the sql to the postgres database.

> --
> Toshihiro Kitagawa
> SRA OSS, Inc. Japan
>
>