Answers for "how to connect to remote postgres database from command line"

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

how to access remote pstgres

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
Posted by: Guest on August-11-2020
1

how to access remote pstgres

pg_dump -U postgres DATABASE_NAME > backup.sql
Posted by: Guest on August-11-2020
0

how to connect to a remote postgresql database

$ psql -h <host> -p <port> -U <username> <database>
Posted by: Guest on July-19-2021
0

how to connect to remote postgres database from command line

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
Posted by: Guest on September-01-2021

Code answers related to "how to connect to remote postgres database from command line"

Browse Popular Code Answers by Language