enable postgresql remote access 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
pg_dump -U postgres DATABASE_NAME > backup.sql