Prepare PostgreSQL ================== There should already be a system user, likely ``postgres``. Become root: .. code-block:: console $ su Switch to the ``postgres`` user: .. code-block:: console # su postgres Create a database user named ``byceps``: .. code-block:: console postgres@host$ createuser --echo --pwprompt byceps You should be prompted to enter a password. Do that. In your :doc:`BYCEPS configuration file `, replace the example password in the value of :confval:`database.password` with the one you just entered. Create a schema, also named ``byceps``: .. code-block:: console postgres@host$ createdb --encoding=UTF8 --template=template0 --owner byceps byceps To run the tests (optional), a dedicated user and database have to be created: .. code-block:: console postgres@host$ createuser --echo --pwprompt byceps_test postgres@host$ createdb --encoding=UTF8 --template=template0 --owner byceps_test byceps_test Connect to the database: .. code-block:: console $ psql