How to restore a dump.sql file to new postgresql database ?

Question

Hi I am having a backup of database of odoo as dump.sql.
When I am trying to restore it back to a  new database in postgresql, I am unable to restore it shows "*psql:D:/dump/dump.sql:117019: ERROR: invalid input syntax for integer: " /. "CONTEXT: COPY account_account, line 79, column id: " /.* "
I am using command as* \i file_path/dump.sql *
when I am trying to execute a
Copy tale_name (fields....) from stdin;
1 . . . .data
it shows error
How can I execute this and how can I restore dump.sql wit

imed · Accepted Answer

you can try this process:
First copy your dump.sql into desired server or desktop if you re in localhost
Next create manually a database with createdb dbname;
And after that import your dump.sql definition in your database created via psql dbname <  yourpath/dump.sql
next affect your database to owner odoo

ALTERDATABASE OdooDb OWNER TO odoo

Afterwards give the role odoo in database the SUPER USER rights with

*   ** ALTER USER user_name with
SUPER USER; *
Finall

Malik Sikandar Hayat · Answer

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

Nikhil Krishnan · Answer

Hi Sathwik,
look this:
https://medium.com/@nikhilkrishnan/how-to-restore-your-psql-database-for-odoo-fc7b0bdcfe28 [1]
Thanks

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

Didier Hernandez M · Answer

​ 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

Sathwik · Answer

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: " /. "*

NareshKumar.P · Answer

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

Related Posts	Replies	Views
Problem- Restore Database on Odoo 8 restore restoredb databasebackup	3 जून 16	8366
restore database from terminal database restore restoredb databasebackup	1 मई 16	9324
Issue Restoring a Database in Odoo 17 CE : Database already exists community restore databasebackup zipfile OdooV17	2 अप्रैल 25	2285
The following modules are needed by other modules but have not been defined, restore	1 फ़र॰ 25	88
Accident how to restore remove from view restore	1 नव॰ 24	2401

This question has been flagged

Enjoying the discussion? Don't just read, join in!