| 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: | Whole Thread | Raw Message | 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
| 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 |