Thread: 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@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

D Black wrote:
> 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.

Thanks for your detailed report.

You'd need to report this as a bug on the postgresql package in Ubuntu's
Launchpad. It's an issue with the postgresql packaging for Ubuntu and
can't really be resolved by the upstream PostgreSQL project.

See:
  https://launchpad.net/ubuntu/+source/postgresql-8.3/+bugs

--
Craig Ringer