Wymored Login

allow remote connections postgresql 10 and 11 on ubuntu 18.04

12 de julho de 2019 por Alexandre Miguel de Andrade Souza

create a file postgresql.conf in pgsql directory

 sudo su postgres
 cd 
 cd 10/main
 nano postgresql.conf

edit the content of postgresql.conf as (or adding)

listen_addresses= '0.0.0.0'

note: the file pg_hba.conf to postgresql 10 is on /etc/postgresql/10/main/pg_hba.conf

Edit it adding

host    all             all             192.168.0.0/24         md5

where 192.168.0 is your local network. ?