Guillaume Lelarge wrote:
Le 21/06/2010 15:52, Geoffrey a écrit :
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?
You can't. backend_hostnamen, with n greater then 0, is only used in
replication, and load balancing mode.
If you want to be able to connect on various databases from various
servers, pgBouncer is what you're looking for.
Ouch, okay, thanks for the clarification. I simply did not pick up on
that in the docs.
--
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
