allow remote connections to postgresql code example

Example 1: postgresql allow remote connections

host    all             all              0.0.0.0/0                       md5
host    all             all              ::/0                            md5

Example 2: postgresql allow remote connections

listen_addresses = '*'

Example 3: how to access remote pstgres

psql -U postgres DATABASE_NAME < backup.sql

Example 4: how to access remote pstgres

psql -U postgres
drop database DATABASE_NAME;
create database DATABASE_NAME;
create user USER_NAME;
alter role USER_NAME with password 'BITNAMI_USER_PASSWORD';
grant all privileges on database DATABASE_NAME to USER_NAME;
alter database DATABASE_NAME owner to USER_NAME;
psql -U postgres DATABASE_NAME < backup.sql