postgres dying

From: "Callis" <callis(at)idncafe(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres dying
Date: 2006-06-05 17:03:12
Message-ID: web-3092932@idngh1.idncafe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2006-06-05 18:41:13 Re: postgres dying
Previous Message Bruno Wolff III 2006-06-05 16:03:09 Re: restoring data tree from old 7.3 database