On Tue, 2011-10-04 at 14:36 +0200, Olivier NOEL wrote: > 2011/10/4 Olivier NOEL <noli...@gmail.com>: > > 2011/10/4 Olivier NOEL <noli...@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 = '' > > > > The above error is on FreeBSD. > > On Debian pgpool starts, on FreeBSD, pgpool won't start. Missing dependency? > > Pgpool on both OS are compiled : one from sources (Debian) and one > from ports (FreeBSD). >
On 3.1, black_function_list and white_function_list are regular expressions. I guess the patch wasn't checked on BSD (the patch coder worked on Linux). But this is a bug that should be fixed. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general