Server Not Running

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Server Not Running
Date: 2011-08-04 05:46:12
Message-ID: 4E3A3224.6060300@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-08-04 06:55:05 Re: How to get last Error Message/Code
Previous Message Earth Analizer 2011-08-04 05:03:48 How to get last Error Message/Code