X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 196DD9FA30C for ; Mon, 5 Jun 2006 15:17:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57895-07 for ; Mon, 5 Jun 2006 15:17:15 -0300 (ADT) X-Greylist: delayed 00:59:57.402481 by SQLgrey- Received: from idngh1.idncafe.com (idngh1.idncafe.com [217.161.100.228]) by postgresql.org (Postfix) with ESMTP id D42B89FA12F for ; Mon, 5 Jun 2006 15:17:13 -0300 (ADT) Received: from [195.8.24.135] (account ) by idngh1.idncafe.com (CommuniGate Pro WebUser 4.0) with HTTP id 3092932 for ; Mon, 05 Jun 2006 17:03:12 +0000 From: "Callis" Subject: postgres dying To: pgsql-admin@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.4.0 Date: Mon, 05 Jun 2006 17:03:12 +0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1"; format="flowed" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/17 X-Sequence-Number: 21979 Hi all, Please pardon me if it sound naive or its been answered. I am running freeradius with postgresql for VOIP with Cisco gateways. But my server keeps dying and after tuning the SHMMX and number of connections and all that i still get the same results. Any form of help will be greatly appreciated. Thank you. System: Fedora 3 CPU : 3GHZ pentium(IV) RAM : 2GB HDD : 3 35GB hardisks Freeradius: freeradius-1.0.1-1 Postgresql: postgresql-7.4.6-1.FC3.1 Postgresql.conf: ================ tcpip_socket = true max_connections = 180 # note: increasing max_connections costs about 500 bytes of shared # memory per connection slot, in addition to costs from shared_buffers # and max_locks_per_transaction. superuser_reserved_connections = 4 #--------------------------------------------------------------------------- # RESOURCE USAGE (except WAL) #--------------------------------------------------------------------------- # - Memory - #Set to 256MB shared_buffers = 24000 # min 16, at least max_connections*2, 8KB each sort_mem = 32168 # min 64, size in KB #vacuum_mem = 8192 # min 1024, size in KB # - Free Space Map - #max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each #max_fsm_relations = 1000 # min 100, ~50 bytes each # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 #preload_libraries = '' ===================================== END ============