Connection pooling for differing databases?

From: Arjun Ranade <ranade(at)nodalexchange(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connection pooling for differing databases?
Date: 2019-03-07 19:27:43
Message-ID: CANrrCRzh-mJx4nmsn4Av5dH7S=9ONoQY=rzn8CnkNp_mOEBSNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm wondering if there's a tool like pgpool that can provide a single
origin point (host/port) that will proxy/direct connections to the specific
servers that contain the db needing to be accessed.

For example... lets say we had two databases: db1.company.com:5432 and
db2.company.com:5433

Db1 has the database: env1
Db2 has the database: env2

Is there a tool that will accept connections, so that when users connect
they see there are two databases they can go to: env1 and env2.

If they choose to connect to the env1 db, it routes all traffic to
db1.company.com:5432 and if they choose env2 it routes them to
db2.company.com:5433

Of course there would have to be some requirement such as the databases on
any given server cannot have name collisions with database names on another
server, etc. Is there a way to do something like this?

Thanks,
Arjun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2019-03-07 19:35:16 Re: Connection pooling for differing databases?
Previous Message Robert Haas 2019-03-07 13:54:17 Re: Update does not move row across foreign partitions in v11