List all database names

You can generate a list of PostgreSQL database names.

  1. Switch to the pe-postgres user by running:
    sudo su - pe-postgres -s /bin/bash
  2. Open the PostgreSQL command-line by running:
    /opt/puppetlabs/server/bin/psql
  3. To list the databases, run: \l
  4. To exit the PostgreSQL command line, run: \q
  5. To log out of the pe-postgres user, run: logout