Error with Postgresql after recent dist-upgrade

[davehardy20]

I just applied the latest batch of updates, as the twitter post announced.

Everything went well apart from the Postgresql upgrade, the following error was given.

Setting up postgresql-8.3 (8.3.8-0ubuntu8.10) ...
Starting PostgreSQL 8.3 database server: main* The PostgreSQL server failed to start. Please check the log output:
2009-09-29 12:21:43 BST FATAL: could not load server certificate file "server.crt": No such file or directory
failed!
invoke-rc.d: initscript postgresql-8.3, action "start" failed.
dpkg: error processing postgresql-8.3 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-8.3; however:
Package postgresql-8.3 is not configured yet.
dpkg: error processing postgresql (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
postgresql-8.3
postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm not conversant with Postgresql and after a bit of google'ing around I cant find a fix.

Anyone else got this problem or does anyone have any pointers or a fix??

Regards
Dave

Done some more Google'ing and found a fix, maybe.

Do we need ssl?, if not just turn off ssl in /etc/postgresql/8.3/main/postgresql.conf

And then /etc/init.d/postrgresql start and it runs

If we need ssl then we need a new certificate, the certs are linked to a snake-oil cert

lrwxrwxrwx 1 root root 36 Jun 22 17:19 server.crt -> /etc/ssl/certs/ssl-cert-snakeoil.pem
lrwxrwxrwx 1 root root 38 Jun 22 17:19 server.key -> /etc/ssl/private/ssl-cert-snakeoil.key

which is not present in the /etc/ssl/certs.

The new certificates can be created by :-

cd /etc/ssl/certs
make-ssl-cert generate-default-snakeoil --force-overwrite

Now retstart postgresql

/etc/init.d/postgresql restart

This should be everything back to life.

[macubergeek]

When you try to start postgres with ssl set to true it fails because Postgres can't find a server certificate file named server.cert. Should we just create with openssl? Just did it it works. Thanks for your posting!!!

Mcugk

[thepretender84]

Fixed my issue also. Thanks!

[Kernelpanic]

I got the same problem, after a dist-upgrade,
and the trick done it well
thank's davehardy20

[sunsin.yi]

Same here. Searching for a fix last 2 days :-)
thanks for fix.

[console]

hello, I can not English so well, I have the same problem, I have made so

backtrack new install

now
console

cd /etc/ssl/certs

ls -ld /etc/ssl/private
sudo ls -l /etc/ssl/private/

make-ssl-cert generate-default-snakeoil --force-overwrite

BackTrack 4 Pre Final Kernel Update

apt-get update
apt-get install -d linux-image
cd /var/cache/apt/archives/
dpkg -i –force all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb
apt-get dist-upgrade
apt-get install madwifi-drivers
apt-get install r8187-drivers

After a reboot, you might want to run:

fix-splash

no error with Postgresql

[ronnyaggr]

THX a lot DAVE..

[jackal7]

I had this problem too but this fixed me right up.


Thank you!

[Nirvana1289]

dpkg -i –force all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb

WARNING: this command cannot work, because it's wrong. For make it work you must enter:

dpkg -i --force-all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb

bye!

[TomSawyer]

Same problem. Fix worked. I had spent a while learning how to make cert files, which was some righteous learning, but I couldn't figure out which directory they went in. Google searches all yielded advice that did not apply to BT4.