PostgreSQL
Repository Manager
The Repository installer and manager allows you to install your selected version of the PostgreSQL Repository.
It can be access via the Pg Installer tab as shown below:
You can also use the manager to install and update packages as well.
As certain packages require EPEL for CentOS, the EPEL repository is installed as well when installing on CentOS.
File Locations
On CentOS, the PostgreSQL config direcotry is located at:
/var/lib/pgsql/12/data
On Ubuntu, the PostgreSQL direcotry is located at:
/etc/postgresql/12/main
The pg_hba.conf File
On installation via the Wizard, PostgreSQL is configured for use with SSL and uses md5 authentication for all users and databases.
1 local all all trust
2 host all all 127.0.0.1 255.255.255.255 md5
3 host all all 0.0.0.0/0 md5
4 host all all ::1/128 md5
5 hostssl all all 127.0.0.1 255.255.255.255 md5
6 hostssl all all 0.0.0.0/0 md5
7 hostssl all all ::1/128 md5
The postgresql.conf File
On installation via the Wizard, PostgreSQL is configured to accept connections on all interfaces as well as SSL connections.
1 #------------------------------------------------------------------------------
2 # CONNECTIONS AND AUTHENTICATION
3 #------------------------------------------------------------------------------
4
5 # - Connection Settings -
6
7 listen_addresses = '*'
8 )
9
10
11 # - SSL -
12
13 ssl = on
Above are excepts.
Version
GeoHelm has been tested with PostgreSQL 10, 11 and 12.
Webmin PostgreSQL Module
On installation, the native PostgreSQL Database Server module is also activated.
It is located under Servers > PostgreSQL Database Server
