Connexions question
Hi all,
I don't think it's a FAQ, Is it possible to limit then number of
simultaneous connexions one can make to a particular databse.
E.G: I have 128 connexions max of witch I wan't to restrict at most 60 to
database x, leaving in the worst case 68 for all others...
Am I clear?
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
It's a command line option for the server.
http://developer.postgresql.org/docs/postgres/app-postmaster.html
Show quoted text
-----Original Message-----
From: ohp@pyrenet.fr [mailto:ohp@pyrenet.fr]
Sent: Monday, November 17, 2003 11:21 AM
To: pgsql-hackers list
Subject: [HACKERS] Connexions questionHi all,
I don't think it's a FAQ, Is it possible to limit then number
of simultaneous connexions one can make to a particular databse.E.G: I have 128 connexions max of witch I wan't to restrict
at most 60 to database x, leaving in the worst case 68 for
all others...Am I clear?
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
--------------------------------------------------------------
----------------
Make your life a dream, make your dream a reality. (St Exupery)---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Import Notes
Resolved by subject fallback
Oops. Never mind. I did not read your message carefully.
Show quoted text
-----Original Message-----
From: Dann Corbit
Sent: Monday, November 17, 2003 11:51 AM
To: ohp@pyrenet.fr
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] Connexions questionIt's a command line option for the server.
http://developer.postgresql.org/docs/postgres/app-postmaster.html
-----Original Message-----
From: ohp@pyrenet.fr [mailto:ohp@pyrenet.fr]
Sent: Monday, November 17, 2003 11:21 AM
To: pgsql-hackers list
Subject: [HACKERS] Connexions questionHi all,
I don't think it's a FAQ, Is it possible to limit then number
of simultaneous connexions one can make to a particular databse.E.G: I have 128 connexions max of witch I wan't to restrict
at most 60 to database x, leaving in the worst case 68 for
all others...Am I clear?
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
--------------------------------------------------------------
----------------
Make your life a dream, make your dream a reality. (St Exupery)---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
Import Notes
Resolved by subject fallback
Er, that's a per-server limit, not a per-database limit (which is what
he asked for), isn't it?
cheers
andrew
Dann Corbit wrote:
Show quoted text
It's a command line option for the server.
http://developer.postgresql.org/docs/postgres/app-postmaster.html
-----Original Message-----
From: ohp@pyrenet.fr [mailto:ohp@pyrenet.fr]
Sent: Monday, November 17, 2003 11:21 AM
To: pgsql-hackers list
Subject: [HACKERS] Connexions questionHi all,
I don't think it's a FAQ, Is it possible to limit then number
of simultaneous connexions one can make to a particular databse.E.G: I have 128 connexions max of witch I wan't to restrict
at most 60 to database x, leaving in the worst case 68 for
all others...Am I clear?