Backup PostgreSQL Database

To backup PostgreSQL database, run

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

PostgreSQL

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *