Using pg_dump Command:

1. Open a terminal on your server.
2. Run pg_dump Command:

pg_dump -h localhost -p 5432 -U postgres -d your_database_name -F c -b -v -f /path/to/backup_file.backup

Adjust the parameters based on your setup.

Explanation of some options:

• -h:   Hostname (replace "localhost" with your actual hostname).
• -p:   Port number (replace "5432" with your actual port).
• -U:   Database user (replace "postgres" with your actual database user).
• -d:   Database name.
• -F c:  Output file format (custom format).
• -b:   Include blobs (binary large objects) in the dump.
• -v:   Verbose mode.
• -f:   Specify the output file.

Enter Password:

You may be prompted to enter the password for the PostgreSQL user.

Verify Backup:

Check the specified backup file to ensure that the backup completed successfully.

Login to Odoo:

1. Open your web browser and navigate to the Odoo web interface. Typically, this is done by entering the URL where Odoo is hosted (e.g., http://your_server_ip:8069, https://your_server_domain/web/database/selector).
2. Access the Odoo web interface and log in using an account with sufficient privileges to perform database backups.

Navigate to Database Manager:

Find the "Database Manager" or a similar section in the Odoo interface.

Select Database:

Choose the database for which you want to create a backup. In this case, you mentioned "xyz_database."

Initiate Backup:

Look for an option or button labeled "Backup" or "Backup Now." Click on it to start the backup process.

Enter Password:

If the system prompts you for a password, enter the password associated with your Odoo user account. This is typically the password you use to log in to Odoo.

Download Backup:

After entering the password, the backup process should continue, and upon completion, you should be provided with an option to download the backup file. Follow the prompts to download the file to your local machine.