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 _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
