/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 votes233 views2 answers
Failed to load module canberra-gtk-module
Shell/Bash
1 vote192 views1 answer
Vlc not opening any video in ubuntu
Shell/Bash
0 vote260 views1 answer
Ubuntn nginx restart
Shell/Bash
0 vote203 views1 answer
Raspi ssh passwort vergessen
Shell/Bash
3 votes209 views1 answer
Git clone vs git pull
Shell/Bash
0 vote182 views1 answer
Npm install apmplify
Shell/Bash
38 votes198 views6 answers
Unzip command ubuntu
Shell/Bash
-3 votes192 views6 answers
Flush dns
Shell/Bash
0 vote177 views1 answer
Ligne de commande pour installer lex sur linux
Shell/Bash
-1 vote200 views3 answers
Kubernetes windows install
Shell/Bash