Oh crap I think I mixed it up in my head with slony II. nevermind. :) On Sat, Jun 27, 2009 at 1:17 AM, <mobiledreamers@xxxxxxxxx> wrote: > no it is very good and well designed the whole app code doesnt need to > change > > we jus need to configure the pgpool insertion logic > > and it has a cool pgpooladmin in php like phppgadmin > > if only i can get it to work > > On Fri, Jun 26, 2009 at 10:53 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> > wrote: >> >> I thought pgool II was abandonware... >> >> On Fri, Jun 26, 2009 at 7:50 PM, <mobiledreamers@xxxxxxxxx> wrote: >> > Hey john >> > thanks >> > 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 <pierce@xxxxxxxxxxxx> >> > wrote: >> >> >> >> mobiledreamers@xxxxxxxxx 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 >> > >> >> >> >> -- >> When fascism comes to America, it will be intolerance sold as diversity. > > > > -- > Bidegg worlds best auction site > http://bidegg.com > -- When fascism comes to America, it will be intolerance sold as diversity. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
