access remote postgresql database code example

Example 1: how to connect to remote postgres database from command line

psql -h <IP_Address> -p <port_no> -d <database_name> -U <DB_username> -W

-W option will prompt for password

psql -h 192.168.1.50 -p 5432 -d testdb -U testuser -W

Example 2: how to access remote pstgres

pg_dump -U postgres DATABASE_NAME > backup.sql

Tags:

Sql Example

Related