[Pgpool-general] Pgpool 3.1 errors

[Olivier NOEL]

2011/10/4 Olivier NOEL <nolivfr at gmail.com>:

>> The conf file you're using is a 3.0 one. I hope you don't use that for
>> 3.1, as it may not work at all.
>
> The conf file is essentially the same, no real differences, with the
> exception of backend_socket_dir, which is deprecated
>
>> Your num_init_children seems way too big. 1000... it means pgpool will
>> launch 1000 subprocesses when it starts. Kinda crazy :) Moreover, with
>> the max_pool at 8, it means pgpool can have 8000 connections to your
>> PostgreSQL server. Have you really configured PostgreSQL with a
>> max_connections of 8000?
>
> Each Postgresql have a max_connections of 1000 (we have above 600
> connections per , we planned to have 8 servers. Actually max_pool is
> at 3
>
>> On the load balancing configuration, you didn't deny load balancing of
>> nextval and setval, which is obviously an error.
>
> I use white_function_list for that, I have about 450 functions that
> are DDL/DML requests, so I only list the read only functions
>
>> On your backend configuration, you set backend_hostname0, and then go
>> directly to backend_hostname7. It may be an issue. Try to set them in
>> order (O, then 1, then 2). Not sure it has a real value, I never tried
>> that, but it works for me when they are set in order, and without hole.
>
> It doesn't seems to disturb pgpool, but it was having problem starting
> without a node 0.

Ok, I tried with a 3.1 config file, and I have this error :

2011-10-04 13:35:44 ERROR: pid 1251: add_to_patterns: invalid regex
pattern: ^getuseruid$

config :

white_function_list = 'getuseruid'
                                   # Comma separated list of function names
                                   # that don't write to database
                                   # Regexp are accepted
black_function_list = ''