| From: | Geoffrey <lists(at)serioustechnology(dot)com> |
|---|---|
| To: | Gerd Koenig <koenig(at)transporeon(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgpool |
| Date: | 2010-06-21 13:52:38 |
| Message-ID: | 4C1F6EA6.3070301@serioustechnology.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-06-21 14:23:06 | Re: Inserting additional data into pg_statistics |
| Previous Message | Geoffrey | 2010-06-21 13:42:04 | Re: pgpool |