PostgreSQL management

Administration of PostgreSQL databases

Enhance automatically creates a PostgreSQL role matching the system username of the website at the time that the first PostgreSQL database is created. This role is automatically the owner of all databases created under the website.

The website user (via website level SSH) can use the psql binary to manage their databases. The credentials for the database owner are stored in the .pgpass file in the home directory.

Managing databases as root

You can also manage PostgreSQL databases as root. The root system user is mapped to the postgres role in PostgreSQL. To access PostgreSQL from root SSH, run psql -U postgres. No password is required.