/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

19 votes212 views2 answers
What to add to gitignore
Shell/Bash
3 votes245 views2 answers
Aws-sdk npm
Shell/Bash
1 vote214 views1 answer
Grep two lines together
Shell/Bash
9 votes209 views2 answers
Vs code terminal open file in separate window
Shell/Bash
69 votes249 views6 answers
Clone branch git
Shell/Bash
0 vote211 views1 answer
How to overwrite main branch git
Shell/Bash
0 vote219 views1 answer
Sed all except last
Shell/Bash
0 vote249 views1 answer
How to kill looped process by command name
Shell/Bash
32 votes214 views5 answers
How to check my git username
Shell/Bash
1 vote184 views1 answer
I am not able to start bluetooth in ubantu
Shell/Bash