the root cause for this error is mismatch the version of Postgresql

Please make sure the version of Created Database and Version of Postgres that is trying to backup that DB is the same.

if your VPS, hosting machine install many versions postgres, when odoo run psql backup it would take the oldest version to back up, while when you create DB with the db port at version that you want to run, and create DB.

Hi Diogo!  (MORE QUIKY WAY)

Yo pude resolverlo, el problema es cuando intentas importar la database seleccionando el objeto "dump.sql" , lo correcto es elejir el objeto .zip que obtienes al Exportar la database, en ese caso me importó con exito y sin errores la informacion completa.

I has been able to solve it , my problem was when i try to import the database clicking "Restore Database" and load the "dump.sql" archive, but the correct way its loading the entire .zip file that export the odoo when you clic in "backup".

i hope it works.

You could check to see if you have postgresql-client package installed in your OS. That could lead you to those errors

First check if you can create db from UI successfully. If not there is error in your Odoo installation or config.

If you can create db from UI but could not restore, please check your addons modules or addons_path settings.