[Pgpool-general] problem to use the replication

[Gary Fu]

Both master and secondary use md5.

In the previous test, the pgpool and master are on one system, and the secondary
is on another system.

I just did another test to put the secondary on the system with pgpool and master.
Now, I got the following error message:
By the way, I use .pgpass to skip the password for postgres.  Also, if the replication
mode is off, I don't have problem to connect either one (by setting the main backend
host to either db server).

 
4pm 396 postgres at nppdist:/var/lib/pgsql2/data> psql -p 9999 -c 'show pool_status' template1
FATAL:  password authentication failed for user "postgres"
2006-08-18 13:25:00 ERROR: pid 16498: pool_do_auth: backend does not return authenticaton ok
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

-- In the file postgresql.conf: (both master and secondary, with different port)

listen_addresses = '*'  # what IP interface(s) to listen on; 
                                # defaults to localhost, '*' = any
port = 5432


-- In the file pg_hba.conf: (both master and secondary)
local   all         postgres,nppsd3                   md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

# other hosts
host    all         all         192.168.10.75/32      md5    #nppdist
host    all         all         192.168.10.76/32      md5    #nppsds1




>Hi,
>
>From: Gary Fu <gfu at saicmodis.com>
>Subject: [Pgpool-general] problem to use the replication
>Date: Fri, 18 Aug 2006 12:43:01 -0400
>
>  
>
>>2006-08-16 17:08:03 DEBUG: pid 2755: Protocol Major: 3 Minor: 0 
>>database: template1 user: postgres
>>2006-08-16 17:08:04 DEBUG: pid 2755: pool_read_message_length: lenghth: 12
>>2006-08-16 17:08:04 ERROR: pid 2755: pool_read_message_length: length 
>>does not match between backends master(12) secondary(8)
>>psql: server closed the connection unexpectedly
>>       This probably means the server terminated abnormally
>>       before or while processing the request.
>>    
>>
>
>Are you setting md5 authentication at master, and trust authentication
>at secondary?
>
>--
>Yoshiyuki Asaba
>y-asaba at sraoss.co.jp
>_______________________________________________
>Pgpool-general mailing list
>Pgpool-general at pgfoundry.org
>http://pgfoundry.org/mailman/listinfo/pgpool-general
>  
>