Thread: Limiting user connnections on 7.4
is there an existing mechanism to do user based connection controls in Postgres 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)