/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 vote101 views1 answer
Git roll back to a point
Shell/Bash
0 vote95 views1 answer
How to change size of icons in applications menu UBUNTU
Shell/Bash
0 vote113 views1 answer
Install pavucontrol
Shell/Bash
0 vote91 views1 answer
Cut command in unix set diameter
Shell/Bash
0 vote64 views2 answers
How to run nessus in kali
Shell/Bash
24 votes99 views5 answers
Check ram in linux
Shell/Bash
7 votes103 views2 answers
Laravel command not found after installing laravel mac
Shell/Bash
0 vote177 views1 answer
Pm2 don't have have synchronised list
Shell/Bash
0 vote105 views1 answer
How to compile a python prohram that uses PyQt
Shell/Bash
0 vote100 views1 answer
Matplotlib change he yticks to two number after digit
Shell/Bash