Hi,

In odoo 10 while clicking on Backup and then entering master password getting following error,

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

what could be the reason as my hosting is on AWS. thanks

Hi Sathwik,

look this:

 https://medium.com/@nikhilkrishnan/how-to-restore-your-psql-database-for-odoo-fc7b0bdcfe28

Thanks

​If your had dowloaded the database from Odoo online can execute this command from the terminal line, just change the bold parameters with your owns:

curl -F 'master_pwd=your_db_pwd' -F backup_file=@/path_to_the_directory/file_to_import.zip -F 'copy=true' -F 'name=db_name' http://your_IP_Address:8069/web/database/restore

It is not allowing to restore from the front end. I tried it but it didn't worked.

so trying it from postgresql DB level, when I am trying to execute the dump file query it is showing errors as mentioned above.

I am trying it from psql console using command \i file_name.sql.  It gives syntax error as 

"psql:C:/Users/sevate/Desktop/trainingdb_2017-01-07_09-39-27/dump2.sql:117019: ERROR: invalid input syntax for integer: "/. " CONTEXT: COPY account_account, line 79, column id: " /. "

you can try through front end 

http://localhost/web/database/manager#action=database_manager or Manage database option and select restore then give master pwd and database name and user name and pwd. The database will restore

You can restore the database using terminal by following below listed commands.

createdb dbname

go to source file where you locate dump file

pg_restore -c -d db_name filename.dump(for dump file)