/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 vote170 views1 answer
How to unmount drive in ubuntu
Shell/Bash
20 votes182 views2 answers
Telegram cli install ubuntu
Shell/Bash
0 vote168 views1 answer
Ca(oh)2 là gì
Shell/Bash
4 votes271 views5 answers
Find in linux
Shell/Bash
0 vote177 views1 answer
Shell align columns
Shell/Bash
4 votes186 views6 answers
Git remove file from staging
Shell/Bash
1 vote174 views1 answer
Install gromit-mpx to mint
Shell/Bash
0 vote188 views1 answer
Ubuntu delete all virtual hosts
Shell/Bash
0 vote182 views1 answer
Pod install not working bad interpreter: No such file or directory
Shell/Bash
0 vote228 views2 answers
Ffmpeg from frames range to video
Shell/Bash