/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 vote172 views1 answer
Ubuntu time tracker
Shell/Bash
6 votes169 views3 answers
Change linux user password
Shell/Bash
11 votes186 views2 answers
Git add file to last commit
Shell/Bash
1 vote172 views1 answer
Brew apps list
Shell/Bash
0 vote128 views1 answer
Rename npm
Shell/Bash
15 votes166 views2 answers
Show env in bash
Shell/Bash
69 votes158 views6 answers
Clone branch git
Shell/Bash
14 votes160 views3 answers
Cp -r copy linux directory or file
Shell/Bash
0 vote168 views1 answer
Uninstall appx
Shell/Bash
0 vote146 views1 answer
Keep services up no matter what
Shell/Bash