setup postgresql to be access from another host code example
Example 1: how to access remote pstgres
psql -U postgres DATABASE_NAME < backup.sql
Example 2: how to access remote pstgres
pg_dump -U postgres DATABASE_NAME > backup.sql
psql -U postgres DATABASE_NAME < backup.sql
pg_dump -U postgres DATABASE_NAME > backup.sql