error processing postgresql-8.3 (--configure)

[hansoylu]

Binary package hint: update-manager

Setting up zenity (2.24.0-0ubuntu1) ...

Setting up gerix-wifi-cracker (1.0-bt12) ...
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-11-15 15:23:39 EET 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
Setting up rar (1:3.8b2-2) ...
No apport report written because the error message indicates its a followup error from a previous failure.

[Armando Maceda (armando-maceda)]

I have a similar problem in postgresql-8.4 after having done this:

sudo rm -r /var/lib/postgresql/8.4
sudo mkdir /var/lib/postgresql/data
sudo chown postgres /var/lib/postgresql/data
su postgres
/usr/sbin/initdb -D /var/lib/postgresql/data
sudo gedit /etc/postgresql/8.4/main/postgresql.conf
   and I did this change: data_directory = '/var/lib/postgresql/data'

After that, reset my computer and got this message in / var / log / postgresql FATAL: could not load server certificate file "server.crt": No such file or directory

As a workaround I did #ssl = true in / etc/postgresql/8.4/main/postgres.conf

Please help.

[Martin Pitt (pitti)]

Do you have the ssl-cert package installed? Perhaps you removed the snakeoil SSL certificate in /etc/ssl/certs/ssl-cert-snakeoil.pem before the upgrade?

[Launchpad Janitor (janitor)]

[Expired for postgresql-8.3 (Ubuntu) because there has been no activity for 60 days.]