| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE>, Jose Antonio Martinez <lfbbes(at)yahoo(dot)es> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: max connections |
| Date: | 2003-02-21 10:50:17 |
| Message-ID: | 200302211050.18447.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 20 Feb 2003 5:31 pm, Thomas Beutin wrote:
> On Thu, Feb 20, 2003 at 04:17:33PM +0100, Jose Antonio Martinez wrote:
> > how can i limit the number of concurrent connections
> > to the same database at a postgresql server (wich
> > have several databases)?
> >
> > is there any easy way?
>
> command line: "-N x"
> config file: "max_connections = x"
>
> It's all explained in the very good documentation.
I think Jose wanted to restrict access such as:
# this exists
max_connections = 32
# these don't
max_connections.db1 = 20
max_connections.db2 = 15
which I don't think you can do at the database level - it'll have to be
something you do at the application level I believe.
--
Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christian Imbeault | 2003-02-21 10:59:19 | type casting a subselect as an interval |
| Previous Message | Jean-Christian Imbeault | 2003-02-21 10:40:03 | Problem with aliasing |