Re: pgpool

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

In response to

Responses

  • Re: pgpool at 2010-06-21 15:06:15 from Guillaume Lelarge

Browse pgsql-general by date

  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