Postgresql not running... cant do updates

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

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?

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?

What output do you receive if you run these two commands:

dpkg -l 'postgres*'

ls -l /etc/postgresql/8.3/main/postgresql.conf

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

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.

I have enabled remote support.... thankyou

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?