Re: [ADMIN] Max connections

2009-08-11 Thread Benjamin Krajmalnik
guidance. As always, thank you so much for your assistance. > -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Tuesday, August 11, 2009 7:54 AM > To: Benjamin Krajmalnik > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Max connecti

Re: [ADMIN] Max connections

2009-08-11 Thread Tom Lane
"Benjamin Krajmalnik" writes: > I am setting up a test environment to simulate a very high load. We > have a server farm which is receiving data (cold be thousands of > simultaneous users posting data). I currently have max_connections set > to 500 and the server is starting ok. If I try to inc

Re: [ADMIN] Max connections

2009-08-10 Thread Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Max connections On Tue, Aug 11, 2009 at 3:42 PM, Benjamin Krajmalnik wrote: I am setting up a test environment to simulate a very high load. We have a server farm which is receiving data (cold be thousands of simultaneous users posting

Re: [ADMIN] Max connections

2009-08-10 Thread Shoaib Mir
On Tue, Aug 11, 2009 at 3:42 PM, Benjamin Krajmalnik wrote: > I am setting up a test environment to simulate a very high load. We have > a server farm which is receiving data (cold be thousands of simultaneous > users posting data). I currently have max_connections set to 500 and the > server i

Re: [ADMIN] max connections per user

2007-11-12 Thread Carol Walter
Yes, you can use the connection limit parameter when you create or alter a user. Carol On Nov 12, 2007, at 10:39 AM, [EMAIL PROTECTED] wrote: hi, i would like to know if it is possible to limit the number of connections per user. if postgresql.conf, i just see a "max connections" paramet

Re: [ADMIN] max connections from one ip

2004-11-14 Thread Gaetano Mendola
Миков Николай wrote: Hi all! Can I restrict max number of connections from one IP address? -- Thanks No within postgres, may be you can play with iptables or something like that Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain a