Installing postgresql on Debian 9

wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O

- | sudo apt-key add

-

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main"
>> /etc/apt/sources.list.d/pgdg.list'

sudo apt-get update sudo apt-get install postgresql postgresql-contrib

sudo su

- postgres psql

postgres-# \conninfo

postgres-# \q

su

- postgres

createuser --interactive --pwprompt

find / -name "postgresql.conf"

#listen_addresses = 'localhost'

listen_addresses = '*'

host all all 0.0.0.0/0 md5

systemctl restart postgresql