Answers for "enable remote access to postgresql database for all ip"

5

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
Posted by: Guest on September-25-2020
1

postgresql allow remote connections

host    all             all              0.0.0.0/0                       md5
host    all             all              ::/0                            md5
Posted by: Guest on January-03-2021

Code answers related to "enable remote access to postgresql database for all ip"

Browse Popular Code Answers by Language