/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 vote132 views1 answer
Powershell tolower
Shell/Bash
0 vote126 views1 answer
Linux make home dir
Shell/Bash
7 votes152 views5 answers
It is required that your private key files are not accessible by others
Shell/Bash
0 vote141 views1 answer
Php ini linux apache2 file sizer
Shell/Bash
2 votes132 views2 answers
Error: package android.support.annotation does not exist
Shell/Bash
19 votes137 views2 answers
Firebase tools
Shell/Bash
0 vote137 views1 answer
Flutter : command not found
Shell/Bash
0 vote177 views1 answer
Install kubernetes plg
Shell/Bash
0 vote137 views1 answer
Linux command line print the occurrences of "'suasua'"
Shell/Bash
25 votes162 views6 answers
Install bootstrap in angular
Shell/Bash