.. _PostgreSQL:

==========
PostgreSQL
==========

-------------------------------------
Install PostgreSQL on a Linux machine
-------------------------------------

Type those lines in the command line to install postgreSQL::
  
  sudo apt update
  sudo apt install postgresql postgresql-contrib

Create the root user for postgreSQL::
  
  sudo -i -u postgres
  psql
  CREATE USER <linuxUser> WITH PASSWORD <password>;
  CREATE DATABASE <linuxUser> WITH OWNER <linuxUser>;
  ALTER ROLE <linuxUser> WITH SUPERUSER;
  exit
  exit

Create a 'client' for wizard users access to the databases::
  
  CREATE USER client WITH PASSWORD <clientPassword>;
  CREATE DATABASE client WITH OWNER client;
  ALTER ROLE client WITH CREATEDB;

Allow connections to postgreSQL server::
  
  sudo nano /etc/posgresql/13/main/postgresql.conf

Modify the following line and save::

  listen_addresses = '*'

Open the pg_hba.conf file::

  sudo nano /etc/postgresql/13/main/pg_hba.conf

Modify the following line and save::

  # TYPE DATABASE USER CIDR-ADDRESS  METHOD
  host  all  all 0.0.0.0/0 md5

Restart postgreSQL::
  
  sudo service postgresql restart

The postgreSQL server should now be accessible via the ip address of the linux machine and the default postgreSQL port ( 5432 )