how to access postgresql database hosted in another machine code example
Example 1: how to access remote pstgres
psql -U postgres DATABASE_NAME < backup.sqlExample 2: how to access remote pstgres
pg_dump -U postgres DATABASE_NAME > backup.sqlpsql -U postgres DATABASE_NAME < backup.sqlpg_dump -U postgres DATABASE_NAME > backup.sql