Skip to content

Instantly share code, notes, and snippets.

@madi-madi

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

Created January 10, 2021 13:12
Show Gist options
  • Save madi-madi/6f81df796ed1f25ebd163bd1f56c3e9b to your computer and use it in GitHub Desktop.
Save madi-madi/6f81df796ed1f25ebd163bd1f56c3e9b 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
@madi-madi
Copy link
Author

related links
sous-chefs/postgresql#156
http://stackoverflow.com/questions/12087683/postgresql-wont-start-server-key-has-group-or-world-access
https://gist.github.com/GabLeRoux/0c60f9be0c28b6b41f64cb55474b0ccb

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