Idea #8331
open[Documentation] Clarify PostgreSQL setup commands for Software Collections users
Description
API install guide tells you to run various database setup commands with sudo -u postgres …
. It's not obvious how to run these when you install a PostgreSQL Software Collection. If you already enabled the collection, sudo loses that information. If you scl enable postgresql92 sudo -u postgres …
throws a weird library error. The most direct translation is sudo -u postgres scl enable postgresql92 "…"
.
To help keep instructions cross-platform, install guide should tell users to start a shell as postgres, just like arv-git-httpd guide does for the git user. People using Software Collections will start the shell with sudo -u postgres scl enable postgresql92 bash
. All others will use sudo -u postgres -i bash
. From there, all PostgreSQL commands will be the same.