/Shell/Bash/How to access remote pstgres

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

Source: docs.bitnami.com

How to access remote pstgres

pg_dump -U postgres DATABASE_NAME > backup.sql

Source: docs.bitnami.com

Similar codes

1 vote368 views1 answer
Your repository has no remotes configured to push to
Shell/Bash
26 votes385 views6 answers
Npm install
Shell/Bash
8 votes354 views6 answers
Show services linux
Shell/Bash
6 votes317 views2 answers
Install chrome in ubuntu 16.04 using terminal
Shell/Bash
0 vote328 views1 answer
Steps to deploy your flutter project with surge
Shell/Bash
0 vote324 views1 answer
Helm install namespace example
Shell/Bash
22 votes313 views6 answers
Git untrack file
Shell/Bash
2 votes325 views1 answer
Composer one liner
Shell/Bash
10 votes372 views4 answers
Install expo npm
Shell/Bash
0 vote421 views3 answers
Best website downloader ubuntu
Shell/Bash