Postgres 10/12 into Linux 18

 

sudo systemctl status postgresql.service

sudo systemctl start postgresql.service

sudo systemctl restart postgresql.service

sudo -i -u postgres psql

SELECT version();

pg_config --version

psql --version

CREATE ROLE mysuperuser2 WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD 'mysuperpass2'  

$ sudo vi /etc/postgresql/12/main/pg_hba.conf
 

local   all             postgres                                trust #peer
# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     md5 #peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            md5
host    replication     all             ::1/128                 md5

Enable remote access

$ sudo vi /etc/postgresql/12/main/pg_hba.conf

host    all             all             127.0.0.1/32            md5 

host    all             all             192.168.0.1/24            md5 

$ sudo vi /etc/postgresql/12/main/postgresql.conf

listen_address='*' # host1, host2, ..., localhost