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: | Raw Message | Whole Thread | 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 |