/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

8 votes193 views1 answer
Intsalling pycharm in ubuntu
Shell/Bash
0 vote181 views1 answer
Docker sh: react-scripts: not found
Shell/Bash
1 vote152 views1 answer
How to kill all tmux sessions (or at least multiple sessions) from the CLI?
Shell/Bash
0 vote243 views1 answer
CMake Error: Could not find CMAKE_ROOT !!!
Shell/Bash
0 vote180 views1 answer
No matching key exchange method found. Their offer: diffie-hellman-group1-sha1,diffie-hellman-group14-sha1
Shell/Bash
0 vote223 views1 answer
Push my logs to elk using filebeat
Shell/Bash
0 vote189 views9 answers
Ruby install on fedora
Shell/Bash
6 votes171 views4 answers
Ionic
Shell/Bash
0 vote194 views3 answers
Git see tags
Shell/Bash
9 votes203 views1 answer
Bash assign $1 value
Shell/Bash