postgresql allow remote connections from specific ip address code example

Example 1: postgresql allow remote connections

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

Example 2: how to access remote pstgres

psql -U postgres DATABASE_NAME < backup.sql

Example 3: how to access remote pstgres

pg_dump -U postgres DATABASE_NAME > backup.sql

Example 4: postgresql allow remote connections

listen_addresses = 'localhost'