For some applications within the UTN infrastructure our preferred database is used, PostgreSQL. This database is preferred because of its efficiency, availability, and superior system tooling. Most applications using a PostgreSQL database are automatically deployed using Ansible, and configurations for those database users and databases should be done within the Ansible repository.
PostgreSQL automatically creates a standard user with the root rights for the
databases on the server, named
postgres. This user does not have a password,
sudo -upostgres should be used to run postgreSQL commands.
The following commands are useful when working with PostgreSQL:
psql [database], enter the command line interface of PostgreSQL.
createuser -P, create a new PostgreSQL user (with password).
dropuser [username], remove user from PostgreSQL.
createdb --encoding=UNICODE --owner=[username] [database], create a unicode database owned by specified user.
dropdb [database], remove database from the server.