/Shell/Bash/How to connect to a remote postgresql database

How to connect to a remote postgresql database

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

Source: stackoverflow.com

How to connect to a remote postgresql database

$ psql -h <host> -p <port> -U <username> <database>

Similar codes

17 votes340 views3 answers
Snap uninstall
Shell/Bash
75 votes345 views4 answers
Upload new repo to git
Shell/Bash
0 vote386 views1 answer
Project requires ghc but it isn't installed
Shell/Bash
6 votes383 views2 answers
How to download using curl
Shell/Bash
0 vote329 views1 answer
Yum list installed packages from specific repo
Shell/Bash
0 vote355 views1 answer
How to install Klavaro
Shell/Bash
0 vote337 views1 answer
Sourcetree permission denied (publickey) github mac
Shell/Bash
0 vote351 views1 answer
Normalize-audio: command not found
Shell/Bash
0 vote351 views1 answer
How to open ssh on port 22 manjaro
Shell/Bash
1 vote341 views2 answers
Django.core.exceptions.ImproperlyConfigured: The SECRET_KEY setting must not be empty
Shell/Bash