Backup PostgreSQL Database

To backup PostgreSQL database, run

pg_dump  -h HOSTNMAME -p PORT -U USER -d DBNAME -W -f file.psql

1	pg_dump -h HOSTNMAME -p PORT -U USER -d DBNAME -W -f file.psql

Example

pg_dump  -h ukgaa1vy7o672pj.caqdhl3x5dow.us-east-1.rds.amazonaws.com -p 5432 -U serveroku -d serverokdb -W -f file.psql

1	pg_dump -h ukgaa1vy7o672pj.caqdhl3x5dow.us-east-1.rds.amazonaws.com -p 5432 -U serveroku -d serverokdb -W -f file.psql