PostgreSQL not starting on BackTrack 4 Pre-Final
If you are following the latest releases in regards to BackTrack, following a recent update you may have experienced error when PostgreSQL attempts to start:
Starting PostgreSQL 8.3 database server: main* The PostgreSQL server failed to start. Please check the log output:
Then further down:
could not load server certificate file “server.crt”: No such file or directory
Here is a quick fix - at the console, type:
cd /etc/ssl/certs
ls -ld /etc/ssl/private
sudo ls -l /etc/ssl/private/
make-ssl-cert generate-default-snakeoil -force-overwrite
cd /etc/ssl/certs
Re-run the update commands, and you should be good to go:
apt-get update
apt-get upgrade
apt-get dist-upgrade