Home/ Questions/How To Connect To Remote Postgres Database From Command Line?
Next
Answered
Reece Tremblay
  • 17
Asked: 2022-04-19T22:34:02+00:00 In:

How To Connect To Remote Postgres Database From Command Line?

  • 17

. Advertisement .

..3..

. Advertisement .

..4..

I’m a newbie, and learning about Postgres Database. I am not sure how to Connect To Remote Postgres Database. Could you tell me how to connect to remote Postgres Database from Command Line

♦ Suggestions of ITtutoria Team
Ideas: If you are a Linux user, connect to a remote database from the command line is very simple. On Mac OSX, it’s just as easy, but for Windows 10 it would take an extra step to install the Windows Subsystem for Linux (WSL).

How to connect to remote Postgres Database from Command Line

The correct way to connect to remote Postgres database server is: Here are the steps:

    • First of all, open a command prompt and type below commands.
    • After that, when you are connected to Postgres database, you can use any of following commands here
    PostgreSQL is an open source relational database management system (RDBMS). It is developed by The PostgreSQL Global Development Group and many other developers from around the world. And it has been available since 1993. Currently, it runs on Linux, Unix, and Microsoft Windows operating systems. I would highly recommend PostgreSQL for your project in this day and age because of its user-friendliness and robustness as well as its excellent performance.
    remote postgres database
    Share

    5 Answers

    1. Best Answer

      I’ve tried some solutions but the simple method should be:

      How to connect to remore 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
      • 8
    2. pg_dump -U postgres DATABASE_NAME > backup.sql
​
      • 20

    3. Here is what you should do for this topic

      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
​
      • 16

    4. This is the solution that I found somewhere, this helped me and I hope that helps you

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

    5. My suggestions for this question

      psql -U postgres
drop database DATABASE_NAME;
create database DATABASE_NAME;
create user USER_NAME;
alter role USER_NAME with password 'BITNAMI_USER_PASSWORD';
grant all privileges on database DATABASE_NAME to USER_NAME;
alter database DATABASE_NAME owner to USER_NAME;
psql -U postgres DATABASE_NAME < backup.sql
​
      • 6

    Leave an answer

    You must login to add an answer.

    Need An Account,