Re: pgpool

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool
Date: 2010-06-21 12:37:10
Message-ID: 4C1F5CF6.4080305@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gerd Koenig wrote:
> Hi Geoffrey,
>
> you do not need to connect to your database directly, just connect to pgpool
> itself.
> e.g.: your database runs on port 5434, pgpool runs on port 5432
> =>
> * pgpool has to be configured in that way that it connects to the database on
> port 5434
> * you/your app's should connect to the server where pgpool is running on port
> 5432 (the connection to the database is established by pgpool)
>
> hth...::GERD::...

So I've got 13 different databases on 13 different postmasters, now does
pgpool know which databases I'm trying to connect to?

>
>
> On Monday, June 21, 2010 02:10:22 pm Geoffrey wrote:
>> So, I've got it installed, and tweaked the configuration, but I simply
>> can not figure out how to connect to my databases via pgpool. Is this
>> simply transparent? I don't see how.
>>
>> So I have a postmaster running on port 5434, how do I connect to that
>> database via pgpool? I simply can not find this piece of info 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

In response to

  • Re: pgpool at 2010-06-21 12:26:21 from Gerd Koenig

Responses

  • Re: pgpool at 2010-06-21 18:53:16 from John R Pierce

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Katkar 2010-06-21 12:48:23 disable password prompt - command line
Previous Message Lew 2010-06-21 12:35:02 Re: A thought about other open source projects