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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
