BUG #5303: Upgrade failure due to sever.key permissions

The following bug has been logged online:

Bug reference: 5303
Logged by: D Black
Email address: softcafe(at)inbox(dot)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