Thread: Connexions question

Connexions question

From
ohp@pyrenet.fr
Date:
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)


Re: Connexions question

From
"Dann Corbit"
Date:
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 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)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


Re: Connexions question

From
"Dann Corbit"
Date:
Oops.  Never mind.  I did not read your message carefully.


> -----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 question
>
>
> 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 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)
> >
> > ---------------------------(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
>


Re: Connexions question

From
Andrew Dunstan
Date:
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:

>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 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?
>>
>>    
>>