Submitted by JoelM on Sun, 03/10/2013 - 17:07
Starting PostgreSQL 8.3 database server: mainError: could not exec /usr/lib/postgresql/8.3/bin/pg_ctl /usr/lib/postgresql/8.3/bin/pg_ctl start -D /var/lib/postgresql/8.3/main -l /var/log/postgresql/postgresql-8.3-main.log -s -o -c config_file="/etc/postgresql/8.3/main/postgresql.conf" : failed! failed!
any help on how to fix this error
Status:
Active
Comments
Submitted by andreychek on Sun, 03/10/2013 - 17:38 Comment #1
Howdy -- there should be a Postgres log in "/var/log/postgresql". If you look at the end of the log, do you see any errors that are occurring when you try to start Postgres?
Submitted by JoelM on Wed, 05/01/2013 - 15:34 Comment #2
All I have is an old log that says: incomplete startup packet ive tried installing via yum but get errors about config file missing or now setup?
Submitted by andreychek on Wed, 05/01/2013 - 15:42 Comment #3
What output do you receive if you run these two commands:
dpkg -l 'postgres*'
ls -l /etc/postgresql/8.3/main/postgresql.conf
Submitted by JoelM on Wed, 05/01/2013 - 19:34 Comment #4
Desired=Unknown/Install/Remove/Purge/Hold| Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
iU postgresql 8.3.17-0lenny1 object-relational SQL database (supported ve
un postgresql-7.4 <none> (no description available)
un postgresql-8.0 <none> (no description available)
iF postgresql-8.3 8.3.16-0lenny1 object-relational SQL database, version 8.3
ii postgresql-cli 8.3.17-0lenny1 front-end programs for PostgreSQL (supported
ii postgresql-cli 8.3.17-0lenny1 front-end programs for PostgreSQL 8.3
ii postgresql-cli 94lenny1 manager for multiple PostgreSQL client versi
ii postgresql-com 94lenny1 PostgreSQL database-cluster manager
iU postgresql-con 8.3.17-0lenny1 additional facilities for PostgreSQL (suppor
iU postgresql-con 8.3.16-0lenny1 additional facilities for PostgreSQL
un postgresql-dev <none> (no description available)
ii postgresql-doc 8.3.17-0lenny1 documentation for the PostgreSQL database ma
ii postgresql-doc 8.3.17-0lenny1 documentation for the PostgreSQL database ma
un postgresql-pl <none> (no description available)
-rw-r--r-- 1 postgres postgres 16755 2010-05-29 15:34 /etc/postgresql/8.3/main/postgresql.conf
Submitted by andreychek on Wed, 05/01/2013 - 23:14 Comment #5
I'm not really sure what the problem is... would it be possible to log into your system in order to further troubleshoot the issue?
If that's okay, you can either enable Remote Support using the Virtualmin Support module, or you can email root login details to eric@virtualmin.com.
Submitted by JoelM on Thu, 05/09/2013 - 23:45 Comment #6
I have enabled remote support.... thankyou
Submitted by andreychek on Sat, 05/11/2013 - 20:42 Comment #7
Did this problem just begin occurring recently? If so, do you know what changes occurred around the time this problem began?
Or has this problem been occurring for awhile?
Also, are you using Postgres? Or is it safe to remove it?