Re: horizontal sharding - Mailing list pgsql-general

I thought pgool II was abandonware...

On Fri, Jun 26, 2009 at 7:50 PM, <mobiledreamers@gmail.com> 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@hogranch.com> wrote:
>>
>> mobiledreamers@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
>

--
When fascism comes to America, it will be intolerance sold as diversity.