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)

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)

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)