[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Limiting user connnections on 7.4
From:       Jim Nasby <decibel () decibel ! org>
Date:       2007-04-30 16:36:24
Message-ID: 11691995-7A7F-43F7-8104-E99E61EAC7A2 () decibel ! org
[Download RAW message or body]

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@decibel.org]
> Sent: Saturday, March 24, 2007 2:26 PM
> To: Saqib Awan
> Cc: pgsql-general@postgresql.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@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
>
>

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]