Re: horizontal sharding

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 <pierce(at)hogranch(dot)com> wrote:

> mobiledreamers(at)gmail(dot)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