Answers for "connect to remote database postgres ubuntu"

1

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
Posted by: Guest on August-11-2020
1

how to access remote pstgres

pg_dump -U postgres DATABASE_NAME > backup.sql
Posted by: Guest on August-11-2020

Code answers related to "connect to remote database postgres ubuntu"

Browse Popular Code Answers by Language