As the error message says, pgpool-II does not support MD5 authentication. Plesae use trust or clear text password authentication. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> 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 _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
