Skip to content

Instantly share code, notes, and snippets.

@GabLeRoux

GabLeRoux/fix-ssl-cert-snakeoil.key-ubuntu-postgresql.sh

Created April 1, 2016 06:39
Show Gist options
  • Star 12 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save GabLeRoux/0c60f9be0c28b6b41f64cb55474b0ccb to your computer and use it in GitHub Desktop.
Save GabLeRoux/0c60f9be0c28b6b41f64cb55474b0ccb to your computer and use it in GitHub Desktop.
Download ZIP
Fix postgresql error FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
Raw
fix-ssl-cert-snakeoil.key-ubuntu-postgresql.sh
# > It happened to me and it turned out that I removed erroneously the postgres user from "ssl-cert" group, set it back with
gpasswd -a postgres ssl-cert
# Fixed ownership and mode
sudo chown root:ssl-cert /etc/ssl/private/ssl-cert-snakeoil.key
sudo chmod 740 /etc/ssl/private/ssl-cert-snakeoil.key
# now postgresql starts! (and install command doesn't fail anymore)
sudo /etc/init.d/postgresql start
@GabLeRoux
Copy link
Author

related links

sous-chefs/postgresql#156
http://stackoverflow.com/questions/12087683/postgresql-wont-start-server-key-has-group-or-world-access

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment