Thanks Sim , I solved the problem .
It's due to my pg_xlog is not mounted in the server.
Cheers!
Sim Zacks wrote:
body p { margin-bottom: 0cm; margin-top: 0pt; } On 08/04/2011 08:46 AM, Adarsh Sharma wrote: Dear all,
Today I do some changes in postgresql.conf &shmmax parameters as :
root~# cat /proc/sys/kernel/shmall
8388608
root~# cat /proc/sys/kernel/shmmax
4294967296
max_connections = 80
shared_buffers = 2048MB
work_mem = 32MB
maintenance_work_mem = 512MB
fsync=off
full_page_writes=off
synchronous_commit=off
checkpoint_segments = 32
checkpoint_completion_target = 0.7 effective_cache_size = 4096MB
Now when I start the server , it fails as
root@sun-cloud:/opt/PostgresPlus/8.4SS/data# /etc/init.d/postgresql-8.4 start
Starting PostgreSQL 8.4:
waiting for server to start...............................................................could not start server
PostgreSQL 8.4 did not start in a timely fashion, please see /opt/PostgresPlus/8.4SS/data/pg_log/startup.log for details
My startup.log is empty & ps command shows no server running before :
root~# ps aux | grep 5432
root 1840 0.0 0.0 7620 880 pts/0 S+ 11:14 0:00 grep --color=auto 5432
Do anybody knows what went wrong
Look in your messages or syslog log. I have seen shmmax messages get written there before.
Sim