/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 vote342 views1 answer
Github desktop arch linux
Shell/Bash
14 votes308 views4 answers
Install filezilla ubuntu
Shell/Bash
0 vote331 views1 answer
How to install scrapy-user agents
Shell/Bash
0 vote307 views1 answer
Lancer gradle en bash
Shell/Bash
0 vote305 views1 answer
Npm warn ws butterfly install peer dependencies
Shell/Bash
0 vote307 views1 answer
Kent c dodds
Shell/Bash
0 vote312 views1 answer
How to start hiveserver2 manually
Shell/Bash
0 vote340 views1 answer
Creat a new repository
Shell/Bash
0 vote312 views1 answer
Cant install pyscopg2 win?
Shell/Bash
5 votes311 views4 answers
Ffmpeg mp4 to webm
Shell/Bash