From: | Jim Nasby <decibel(at)decibel(dot)org> |
---|---|
To: | Saqib Awan <ssawan786(at)hotmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Limiting user connnections on 7.4 |
Date: | 2007-04-30 16:36:24 |
Message-ID: | 11691995-7A7F-43F7-8104-E99E61EAC7A2@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I think you might be able to accomplish this by setting up a pgpool
instance for just the read-only connections and limiting how many
connections are allowed there.
On Mar 26, 2007, at 3:20 PM, Saqib Awan wrote:
> Yes other than max_connections. I have a read-only user whose
> connections
> need to be limited to a number far less than max_connections.
> Unfortunately,
> I cannot upgrade to latest version of the portgres since the newer
> ones has
> the support.
>
> -----Original Message-----
> From: Jim Nasby [mailto:decibel(at)decibel(dot)org]
> Sent: Saturday, March 24, 2007 2:26 PM
> To: Saqib Awan
> Cc: pgsql-general(at)postgresql(dot)org general
> Subject: Re: [GENERAL] Limiting user connnections on 7.4
>
> Dropping -hackers
>
> On Mar 22, 2007, at 4:23 AM, Saqib Awan wrote:
>> is there an existing mechanism to do user based connection
>> controls in
>> Postgres 7.4?
>
> Other than max_connections?
> --
> Jim Nasby jim(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2007-04-30 16:45:44 | Re: Stemming not working with tsearch2() function |
Previous Message | Craig A. James | 2007-04-30 16:18:51 | Re: Feature Request --- was: PostgreSQL Performance Tuning |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2007-04-30 17:04:25 | Re: Feature freeze progress report |
Previous Message | Heikki Linnakangas | 2007-04-30 15:46:29 | Heap page diagnostic functions |