/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 vote160 views1 answer
Xrandr configure crtc 2 failed ubuntu
Shell/Bash
0 vote172 views1 answer
Shorten terminal prompt linux
Shell/Bash
0 vote163 views1 answer
How to remove vertical line in pycharm
Shell/Bash
0 vote230 views1 answer
Pwa install
Shell/Bash
0 vote173 views1 answer
Git repo add
Shell/Bash
18 votes168 views2 answers
Ubuntu change permissions on folder and subfolders
Shell/Bash
0 vote163 views1 answer
How to disable suspend in ubuntu 20.04
Shell/Bash
0 vote172 views1 answer
Connect to open vpn with conf file linux
Shell/Bash
0 vote175 views6 answers
Convert bash script to ansible playbook online
Shell/Bash
0 vote162 views1 answer
Virtualbox ubuntu mouse scroll not working
Shell/Bash