Create PostgreSQL database backup

Create a database dump using the PostgreSQL pg_dump utility.

info

Valid credentials are required to connect to the database. The mconsole username is used in the example below and should be updated as needed. The utility will prompt for a password.

pg_dump -h localhost -U mconsole -d management_console -p 5432 -f dbexport.sql

Done

A backup of the database has been successfully created. The specified output file in the command above should be copied to the new server and used for the restore process.