The following bug has been logged online:
Bug reference: 5303
Logged by: D Black
Email address: softcafe@inbox.com
PostgreSQL version: 8.3
Operating system: Ubuntu 8.04
Description: Upgrade failure due to sever.key permissions
Details:
PostgreSQL 8.3 upgrade failed due to wrong permissions on server.key link to
ssl-certs-snakeoil.key. Unknown package install changed permissions or
added the link - reason uknown.
Work Around:
1) Enter the relevant directory (use> locate server.key)
2) Back up old server.key link.
3) Copy ssl-cert-snakeoil.key to server.key
4-5) Change its owner & group to postgres
6) Ensure the permissions are 700 or 740 (as requested by error message)
Recipe for my Ubuntu 8.04 w/ postgresql-8.3 (beware of typos):
1) sudo cd /var/lib/postgresql/8.3/main/
2) sudo mv server.key server.key-0
3) sudo cp /etc/ssl/private/ssl-cert-snakeoil.key server.key
4) sudo chown postgres server.key
5) sudo chgrp postgres server.key
6) sudo chmod 740 server.key
7) sudo /etc/init.d/postgres-8.3 start
I will let you reverse engineer the bug.
Good luck.
Don V Black