PostgreSQL

If PostgreSQL server was not installed before

It can be installed on Windows as well as on Unix.

The setup, as usual, is necessary to perform either on a separate server workstation or on administator's workstation (if separate server room is not available).

Attention! PostgreSQL versions below 11 are not supported!

During installation, you need to create a password for the superuser "postgres", with its account you can further perform complex setup.

If you need remote (non-localhost) access to the SQL-server, opening a port in the Firewall will not be enough.
In the file data\postgresql.conf of the SQL-server's folder need to make sure that parameter listen_addresses is set to "*"
In the file data\pg_hba.conf of the SQL-server's folder need to add an IP-address(es) or ranges, from which access will be allowed.
Example:
host all all 192.168.0.1/24 md5
or for all IPs:
host all all 0.0.0.0/0 md5
After the changes, you have to restart the SQL-server service!

Information about SSL-encryption is here.

If you need to be able to login with Active Directory accounts, then you need to make a number of settings (here).

If PostgreSQL is already installed

If PostgreSQL is already installed, then you only need to check the possibility of remote access to it (if required). See previous section "If PostgreSQL server was not installed before".

Also, if you manually changed the standard_conforming_strings parameter in the data\postgresql.conf file of the SQL server installation folder by setting it to off, then you need to change the value to on and restart the SQL Server service.

If you need to be able to login with Active Directory accounts, then you need to make a number of settings (here).

PostgreSQL-server re-installation

Removing the SQL server should be done in a standard way through the "Control Panel" -> "Add or Remove Programs" (information for Windows).
In this case, after deleting the server, the Mirobase database files will remain.
It is recommended to delete database files before reinstalling the SQL-server again.