Re: horizontal sharding

From: mobiledreamers(at)gmail(dot)com
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, David Fetter <david(at)fetter(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: horizontal sharding
Date: 2009-06-28 16:51:41
Message-ID: c1870d60906280951r5f5461f3h249db6dcfce6906c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks a lot greg trying it out
If it does not work i ll post to pgpool groups
thanks again

but i think what you have pointed out is the right solution

On Sat, Jun 27, 2009 at 10:59 PM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:

> On Fri, 26 Jun 2009, mobiledreamers(at)gmail(dot)com wrote:
>
> 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
>>
>
> My guess is that you have different types of connections being made between
> the local database and the remote one. See
> http://pgfoundry.org/pipermail/pgpool-general/2007-September/000708.htmlfor some comments about the restrictions here, and
> http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html for
> background on the file you'll need to edit in order to change this
> situation.
>
> If you still can't resolve your problem, you should ask about it on the
> pgpool-general mailing list rather than this one:
> http://lists.pgfoundry.org/pipermail/pgpool-general/
> --
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>

--
Bidegg worlds best auction site
http://bidegg.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2009-06-28 17:17:55 Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
Previous Message Whit Armstrong 2009-06-28 16:28:21 partitioning question -- how to guarantee uniqueness across partitions