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 portal_db_user 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 portal_db_user -d portal -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.