So I've got the following:
port = 9999
.
.
backend_hostname0 = 'localhost'
backend_port0 = 5434
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/master'
backend_hostname1 = 'localhost'
backend_port1 = 5435
backend_weight1 = 1
backend_data_directory1 = '/data/pgsql/mwv'
In my pgpool.conf file and I've restarted the pgpool processes. I can
connect to the first entry as follows:
psql -p 9999 master
But if I attempt to connect to the second postmaster as follows:
psql -p 9999 mwv
I can not connect. What am I missing?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson