Re: Converting from single user w/pool to multiple users

From: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting from single user w/pool to multiple users
Date: 2005-03-24 16:14:21
Message-ID: 4242E75D.8050207@istreamimaging.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Could we continue to use our existing connection pool (via our app
server) and every time the application 'gets' a connection (as a
superuser) , we then 'SET SESSION AUTHORIZATION' to the appropriate user
who is performing the action?

>>Under the new scheme, we are limited by max_connections
>>(postgresql.conf)...and would return an error immediately when no
>>connections were available. Is there any way to mitigate this?
>>
>>
>
>This is doubtless the worst problem...
>
> regards, tom lane
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-03-24 16:16:39 Re: Converting from single user w/pool to multiple users
Previous Message John Hughes 2005-03-24 16:03:56 Major Performance issue