Re: pgpool

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