PostgreSQL¶
Table of Contents
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 2 3 4 5 6 7 | local all all trust host all all 127.0.0.1 255.255.255.255 md5 host all all 0.0.0.0/0 md5 host all all ::1/128 md5 hostssl all all 127.0.0.1 255.255.255.255 md5 hostssl all all 0.0.0.0/0 md5 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 3 4 5 6 7 8 9 10 11 12 13 | #------------------------------------------------------------------------------ # CONNECTIONS AND AUTHENTICATION #------------------------------------------------------------------------------ # - Connection Settings - listen_addresses = '*' ) # - SSL - ssl = on |
Above are excepts.
Webmin PostgreSQL Module¶
On installation, the native PostgreSQL Database Server module is also activated.
It is located under Servers > PostgreSQL Database Server
