Hey johnthanks i did read both extensively, but finishing all the steps parallel mode or horizontal partitioning mode doesnot work!
but this is my conf file # backend_hostname, backend_port, backend_weight # here are examples backend_hostname0 = 'localhost' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/mnt/work/database' backend_hostname1 = 'marc.somehost.com' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/mnt/work/database' *this is the problem* * pgpool-II-2.2.2]$ createdb -p 9999* *createdb: could not connect to database postgres: server closed the connection unexpectedly* * This probably means the server terminated abnormally* * before or while processing the request.* ------------------------------------------------------------------------------------------------------------------------------------ Error in log *tail -f /tmp/pgpool.log 2009-06-26 17:24:07 LOG: pid 5561: pgpool successfully started 2009-06-26 18:48:34 ERROR: pid 5563: pool_read_int: data does not match between between master(0) slot[1] (50331648) 2009-06-26 18:48:34 ERROR: pid 5563: pool_do_auth: read auth kind failed* * * *tail -f /tmp/pgpool.log 2009-06-26 18:49:37 DEBUG: pid 23506: s_do_auth: backend key data received 2009-06-26 18:49:37 DEBUG: pid 23506: s_do_auth: transaction state: I 2009-06-26 18:49:40 DEBUG: pid 23466: I am 23466 accept fd 7 2009-06-26 18:49:40 DEBUG: pid 23466: Protocol Major: 3 Minor: 0 database: postgres user: mark 2009-06-26 18:49:40 DEBUG: pid 23466: new_connection: connecting 0 backend 2009-06-26 18:49:40 DEBUG: pid 23466: new_connection: connecting 1 backend 2009-06-26 18:49:40 DEBUG: pid 23466: pool_read_message_length: slot: 0 length: 8 2009-06-26 18:49:40 DEBUG: pid 23466: pool_read_message_length: slot: 1 length: 8 2009-06-26 18:49:40 ERROR: pid 23466: pool_read_int: data does not match between between master(0) slot[1] (50331648) 2009-06-26 18:49:40 ERROR: pid 23466: pool_do_auth: read auth kind failed * * *On Fri, Jun 26, 2009 at 5:56 PM, John R Pierce <pie...@hogranch.com> wrote: > mobiledream...@gmail.com wrote: > >> can someone show how to setup pgpool 2 in parallel *query* mode ie >> horizontal partitioning >> > > did you look at > http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html#parallel? > > I'd pay close attention to the restrictions here, too... > http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#restriction > > > -- Bidegg worlds best auction site http://bidegg.com
