Hi all
We are running postgres 9.1 on CentOS 5. We can’t start up postgres . It complains about memory allocation . Please help
FATAL: shmat(id=3342337) failed: Cannot allocate memory
# - Memory -
shared_buffers = 310251
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
# It is not advisable to set max_prepared_transactions nonzero unless you
# actively intend to use prepared transactions.
work_mem = 32MB # min 64kB
maintenance_work_mem = 512MB # min 1MB
#max_stack_depth = 2MB # min 100kB
/etc/sysctl.conf
# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 26843545
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x7a014a02 32768 zabbix 666 971500 6
------ Semaphore Arrays --------
key semid owner perms nsems
0x7a014a02 0 zabbix 666 3
------ Message Queues --------
key msqid owner perms used-bytes messages
Thanks