Search code examples
databasepostgresqlodooodoo-10

Can't restore or backup Odoo Databases

I am getting the following error. I can't backup and cant't restore any database. This will be a huge issue if the database crashes:

Database restore error: Postgres subprocess ('/usr/bin/pg_restore', u'--dbname=back', '--no-owner', '/tmp/tmpKY434e') error 1

Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmp40EUve/dump.sql', u'Live_GasandOil') error 1

Please help this is very critical

Solution

  • The issue was that there was an extra table in the database which was not supposed to be there. on drooping that table i got that fixed.