/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

3 votes270 views1 answer
Install ruby on linux [without snap]
Shell/Bash
0 vote236 views1 answer
Gitignore all log files
Shell/Bash
-1 vote280 views2 answers
Netstat
Shell/Bash
0 vote240 views1 answer
@react-navigation/bottom-tabs install
Shell/Bash
8 votes250 views1 answer
Git log show summary
Shell/Bash
1 vote244 views1 answer
Tried accessing the FileTransfer plugin but it's not installed.
Shell/Bash
0 vote245 views1 answer
Git discard all unpushed commits
Shell/Bash
1 vote256 views5 answers
Kali linux command download
Shell/Bash
3 votes250 views1 answer
Unix if directory
Shell/Bash
1 vote241 views1 answer
Check pod verion
Shell/Bash