Skip to content

Install PostgreSQL

Bruno Perles edited this page Apr 22, 2021 · 8 revisions

Install postgresql

sudo apt install postgresql postgresql-contrib -y to install

Create a new user:

sudo -u postgres createuser --superuser pia

Connect and change the pia password:

sudo -u postgres psql
\password pia

Configuring the database engine

Make a working copy of application and database config yaml files and update this file with your postgres configuration

cd /var/www/pia-back
cp config/database.example.yml config/database.yml

Open the file nano pia-back/config/database.yml and add 'pia' as username and its password in the 'production' section at the bottom

Clone this wiki locally