[Pgpool-hackers] General SSL question

[ted wong]

Hi,

I'm new to pgpool implementation. I'm following the examples in the tutorial
and am having difficulty with the configuring replication setup.  I've found
very some info on this, but it
a bit confusing.

Thanks in advance.

Ted


Here are my steps.  I've configured pgpool.config with 5 nodes with 
replication and load balancing set to true.

I've setup 5 postgres instances on the same machine using port 5432-5436.
Each instance has its own data directory.

For example, postmaster -D /opt/PostgreSQL/8.4/data -h localhost
-p 5432 &


Port 5432 is the master.

I'm using localhost as the host so that everything is contained on a single
machine.

I've executed this command to start the server: 
/opt/bin/pgpool -c -f /usr/local/etc/pgpool.conf -F /usr/local/etc/pcp.conf
-a /usr/local/etc/pool_hba.conf -n -d

And, I've attempted to replicate a database with this: 
createdb -p 9999 -U postgres  bench_replication -T template_postgis -W

I get the followong message:
createdb: could not connect to database postgres: ERROR:  MD5 authentication
is unsupported in replication, master-slave and parallel modes.
HINT:  check pg_hba.con

The server logs shows:

2010-04-30 23:38:29 DEBUG: pid 29493: I am 29493 accept fd 5
2010-04-30 23:38:29 DEBUG: pid 29493: Protocol Major: 3 Minor: 0 database: 
postgres user: postgres
2010-04-30 23:38:29 DEBUG: pid 29493: new_connection: connecting 0 backend
2010-04-30 23:38:29 DEBUG: pid 29493: new_connection: connecting 1 backend
2010-04-30 23:38:29 DEBUG: pid 29493: pool_ssl: SSL requested but SSL support
is not available
2010-04-30 23:38:29 DEBUG: pid 29493: pool_ssl: SSL requested but SSL support
is not available
2010-04-30 23:38:29 DEBUG: pid 29493: pool_read_message_length: slot: 0 length:
12
2010-04-30 23:38:29 DEBUG: pid 29493: pool_read_message_length: slot: 1 length:
12