How To Connect To Remote Postgres Database From Command Line?

Question

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

[su_box title="♦ Suggestions of ITtutoria Team" box_color="#2d6ff7" radius="1"]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.

[/su_box]

Chelsea O'Kelly · Accepted Answer

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

How to connect to remore postgres database from command line

psql -h  -p  -d  -U  -W

-W option will prompt for password

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

Ariella Lam · Answer

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

Lilith Johnson · Answer

pg_dump -U postgres DATABASE_NAME > backup.sql

Isabella Thomas · Answer

Here is what you should do for this topic

psql -h  -p  -d  -U  -W

-W option will prompt for password

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

Scott Rodriguez · Answer

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

$ psql -h  -p  -U

Sign Up

Sign In

Forgot Password

ITtutoria Latest Questions

How To Connect To Remote Postgres Database From Command Line?