/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

2 votes215 views1 answer
Sshpass mac os x brew
Shell/Bash
0 vote157 views1 answer
Sed add newline
Shell/Bash
2 votes179 views1 answer
Wget download website for offline viewing
Shell/Bash
2 votes187 views1 answer
Git not taking file name change
Shell/Bash
3 votes146 views1 answer
How to check if am using wayland
Shell/Bash
1 vote145 views1 answer
Ubuntu ufw list rules
Shell/Bash
0 vote157 views1 answer
Watch coomnd bash
Shell/Bash
9 votes152 views1 answer
Bash: gulp: command not found
Shell/Bash
0 vote165 views1 answer
:flutter Android\Sdk/platform-tools/adb shell am start -n com.react2010/com.react2010.MainActivity
Shell/Bash
4 votes180 views3 answers
Remove iptables rule
Shell/Bash