phorum@code.campware.org wrote on 09/18/2007 05:35 PM:
> Author: hammer v2
> Link: http://code.campware.org/phorum/read.php?20,5733,5734#msg-5734
> --------------------------------------------------------------------------------
> Setting up postgresql-8.2 (8.2.3-3) ...
> * Starting PostgreSQL 8.2 database server * The PostgreSQL server failed to start. Please check the log output:
> 2007-09-18 22:34:53 ICT FATAL: unsafe permissions on private key file "server.key"
> 2007-09-18 22:34:53 ICT DETAIL: File must be owned by the database user or root, must have no write permission for "group", and must have no permissions for "other".
>
> invoke-rc.d: initscript postgresql-8.2, action "start" failed.

I don't know any more about this than you, but I can read the error
message for you, if that helps.

Something messed up the permissions of the "server.key" file in your
Postgresql data directory (which is /var/lib/postgresql/8.2/main/ on
Ubuntu Feisty). This is a softlink to the file
/etc/ssl/private/ssl-cert-snakeoil.key. I don't know which package
generated this (could be libssl0.9.8, but I'm not sure); if you can find
that out, the cleanest solution would be to reinstall that package.

Short of that, you can fix the permissions for the file manually; the
error message above tells you what it should look like. Mine has these
permissions: -rw-r----- root ssl-cert. Afterwards, try to fix the state
of your packages with "sudo apt-get install -f". If it complains about
another file, fix that one as well, etc.

Ferenc