/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

0 vote129 views1 answer
TypeError: Cannot read property 'R' of undefined snackbar.android.js:160:0
Shell/Bash
1 vote146 views1 answer
Vim discard changes and quit command
Shell/Bash
11 votes166 views1 answer
Install intellij idea on ubuntu 20.04
Shell/Bash
1 vote121 views2 answers
React native toast
Shell/Bash
2 votes134 views2 answers
Install for [ 'create-react-app@latest' ] failed with code 1
Shell/Bash
0 vote116 views1 answer
How to compare files in terminal
Shell/Bash
47 votes126 views5 answers
Loop bash
Shell/Bash
1 vote116 views1 answer
Dpkg: error processing package gitweb (--configure): installed gitweb package post-instal
Shell/Bash
12 votes130 views1 answer
Linux check used space in folder
Shell/Bash
0 vote123 views2 answers
How to run command in background bash linux
Shell/Bash