pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Callis <callis@idncafe.com>
To: pgsql-admin@postgresql.org
Subject: postgres dying
Date: Mon, 05 Jun 2006 17:03:12 +0000
Message-ID: <web-3092932@idngh1.idncafe.com> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <web-3092932@idngh1.idncafe.com>
Permalink:  ../web-3092932@idngh1.idncafe.com/
Also on:    postgresql.org/message-id/web-3092932@idngh1.idncafe.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: callis@idncafe.com
  Subject: Re: postgres dying
  In-Reply-To: <web-3092932@idngh1.idncafe.com>
  References: <web-3092932@idngh1.idncafe.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox