Re: Connection pooling for differing databases?

2019-03-08 Thread Moreno Andreo
Il 07/03/2019 21:19, Arjun Ranade ha scritto: I'm looking at pgbouncer and it does most of what I need.  I'm wondering about clients connecting via pgadmin, is there a way for users using pgadmin or another tool to see all the

Re: Connection pooling for differing databases?

2019-03-07 Thread Jerry Sievers
Arjun Ranade writes: > 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:

Re: Connection pooling for differing databases?

2019-03-07 Thread Arjun Ranade
I'm looking at pgbouncer and it does most of what I need. I'm wondering about clients connecting via pgadmin, is there a way for users using pgadmin or another tool to see all the databases that are part of the configs? Thanks, Arjun On Thu, Mar 7, 2019 at 2:39 PM Moreno Andreo wrote: > Il

Re: Connection pooling for differing databases?

2019-03-07 Thread Moreno Andreo
Il 07/03/2019 20:27, Arjun Ranade ha scritto: 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. Yes, I think there are many, but I'm

Re: Connection pooling for differing databases?

2019-03-07 Thread Fabrízio de Royes Mello
Em qui, 7 de mar de 2019 às 16:10, Arjun Ranade escreveu: > > 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

Connection pooling for differing databases?

2019-03-07 Thread Arjun Ranade
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