Postgres Pro
Downloads
Home   >   mailing lists

Re: horizontal sharding - Mailing list pgsql-general

From mobiledreamers@gmail.com
Subject Re: horizontal sharding
Date
Msg-id c1870d60906280951r5f5461f3h249db6dcfce6906c@mail.gmail.com
Whole thread Raw
In response to Re: horizontal sharding  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Tree view
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@gregsmith.com> wrote:
On Fri, 26 Jun 2009, mobiledreamers@gmail.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.html for 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@gregsmith.com http://www.gregsmith.com Baltimore, MD



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

pgsql-general by date:

Previous
From: Whit Armstrong
Date:
Subject: partitioning question -- how to guarantee uniqueness across partitions
Next
From: Justin
Date:
Subject: Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function