Re: [GENERAL] increasing max_connections on freebsd
MF == Michael Fuhr [EMAIL PROTECTED] writes: MF On Tue, Dec 14, 2004 at 06:34:05PM +0100, Christian Kratzer wrote: At least on FreeBSD 5.x there is no need to build a customer kernel. The following can be set in /boot/loader.conf MF I forgot about /boot/loader.conf. If I get a chance I'll check if MF the settings you posted also work in FreeBSD 4. Thanks. Yes, they do. You can also bump maxfiles if necessary via a sysctl. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] increasing max_connections on freebsd
On Tue, Dec 14, 2004 at 10:01:47AM -0500, Frank D. Engel, Jr. wrote: On Dec 14, 2004, at 5:46 AM, Hengki Suhartoyo wrote: I want to increase my max_connections up to 128 connections, but I got that I need to recompile my kernel. I'm newbie in postgresql and freebsd. How to increase max_connections and recompile freebsd kernel. You might want to check some of these sites: http://www.silverwraith.com/papers/freebsd-kernel.php http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ kernelconfig.html Anyone have a clue why he would need to recompile his kernel for this, though? The error probably says something about not having enough shared memory or semaphores. On FreeBSD some IPC settings can be configured via sysctl but others might need to be built into the kernel. For example, on FreeBSD 4, trying to set kern.ipc.semmni or kern.ipc.semmns with sysctl fails, saying that the OID is read-only. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] increasing max_connections on freebsd
On Tue, 14 Dec 2004, Michael Fuhr wrote: On Tue, Dec 14, 2004 at 10:01:47AM -0500, Frank D. Engel, Jr. wrote: [snipp] The error probably says something about not having enough shared memory or semaphores. On FreeBSD some IPC settings can be configured via sysctl but others might need to be built into the kernel. For example, on FreeBSD 4, trying to set kern.ipc.semmni or kern.ipc.semmns with sysctl fails, saying that the OID is read-only. At least on FreeBSD 5.x there is no need to build a customer kernel. The following can be set in /boot/loader.conf # defaults for FreeBSD are as follows # SEMMNI=10, # of semaphore identifiers # SEMMNS=60, # of semaphores in system # SEMUME=10, max # of undo entries per process # SEMMNU=30, # of undo structures in system kern.ipc.semmni=40 kern.ipc.semmns=240 kern.ipc.semume=40 kern.ipc.semmnu=120 these will be set on boot. Greetings Christian -- Christian Kratzer [EMAIL PROTECTED] CK Software GmbHhttp://www.cksoft.de/ Phone: +49 7452 889 135 Fax: +49 7452 889 136 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] increasing max_connections on freebsd
On Tue, Dec 14, 2004 at 06:34:05PM +0100, Christian Kratzer wrote: At least on FreeBSD 5.x there is no need to build a customer kernel. The following can be set in /boot/loader.conf I forgot about /boot/loader.conf. If I get a chance I'll check if the settings you posted also work in FreeBSD 4. Thanks. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] increasing max_connections on freebsd
Hello... I want to increase my max_connections up to 128 connections, but I got that I need to recompile my kernel. I'm newbie in postgresql and freebsd. How to increase max_connections and recompile freebsd kernel. Help Me please. Thank's __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] increasing max_connections on freebsd
You might want to check some of these sites: http://www.silverwraith.com/papers/freebsd-kernel.php http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ kernelconfig.html Anyone have a clue why he would need to recompile his kernel for this, though? On Dec 14, 2004, at 5:46 AM, Hengki Suhartoyo wrote: Hello... I want to increase my max_connections up to 128 connections, but I got that I need to recompile my kernel. I'm newbie in postgresql and freebsd. How to increase max_connections and recompile freebsd kernel. Help Me please. Thank's __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ ___ $0 Web Hosting with up to 120MB web space, 1000 MB Transfer 10 Personalized POP and Web E-mail Accounts, and much more. Signup at www.doteasy.com ---(end of broadcast)--- TIP 8: explain analyze is your friend