Horton
Menu

Re: horizontal sharding

Greg Smith <gsmith@gregsmith.com>

View thread
From: Greg Smith <gsmith@gregsmith.com>
To: mobiledreamers@gmail.com
Cc: John R Pierce <pierce@hogranch.com>, Scott Marlowe <scott.marlowe@gmail.com>, David Fetter <david@fetter.org>, pgsql-general@postgresql.org
Date: 2009-06-28T05:59:56Z
Lists: pgsql-general 
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