'How to import database from odoo 14 to postgresql?

I am trying to take a backup from Odoo enterprise 14 through query. When I try to export the dump file I get this message Can anyone guide me, how to export all the tables with data ?



Solution 1:[1]

You can simply backup odoo database with this command :

pg_dump –format=c your_database_name > your_backup_name.dump

This will save your entire database to .dump format.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 altela