This question has been flagged
2 Replies
4462 Views
databasebackupdump
Avatar
Sudheendra Walvekar

Dear All,

We have been using OpenERP 7 on Windows for our production and have been successfully taking database dump using backup once in a week. Though there are no changes in the settings, we are now facing problem in getting database dump. 
After entering the correct password and clicking on the Backup button, the status shows as loading....still loading......be patient....don't leave yet it is still loading.......you may not believe it but the application is actually loading.......take a minute to get a coffee because it's loading.......but the database dump is not created.


I get a final message as "May be you should considering reloading the application by pressing F5..." . Still I do not get the database dump.

I would appreciate if any help is available to resolve this issue.

Regards

 

Avatar
Discard
Avatar
Serpent Consulting Services Pvt. Ltd.
Best Answer

Sudheendra,

Its advisable to use ubuntu or other linux flavour for production.

For now talking about solution to resolve your issue, you may run psql commands to get the back up.

Backup: $ pg_dump -U {user-name} {source_db} -f {dumpfilename.sql}

Restore: $ psql -U {user-name} -d {desintation_db}-f {dumpfilename.sql}

Thanks.

Avatar
Discard
Avatar
Sudheendra Walvekar
Author Best Answer

Thank you so much. I shall try the solution and update.

Regards,

Sudheendra.

Avatar
Discard