Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Odoo v8 Backing up and restoring a database from commandline. How to achieve this?

odooV8 odooV8_database

1 الرد

14813 أدوات العرض

Stijn

Hello,

I'm trying to automate the backup of the database. I created a backup with the following command:

pg_dump --format=c --no-owner --username=postgres <dbname> > backup.dump

This seems to work as advertised. A dump is created.

To test this backup, I dropped the database from the database manager webpage. Then in commandline I use:

createdb -T template0 <name>

pg_restore --no-owner --dbname=<name> backup.dump

A database is created and the restore happened. But when I go to the database manager webpage, no database is found.

If I try restoring with the restore webpage, I get an error saying "Could not restore the database"

Any ideas on how to fix this?

Rachid

backup

pg_dump --host "hostsIP" --port 5432 --username "userName" --no-password --format custom --blobs --verbose --file "PATH/TO/FILE.dump" "dbName"

Restore

pg_restore --host "hostIP" --port 5432 --username "userName" --dbname "dbName" --no-password --verbose backup.dump

Stijn

الكاتب

I created a dump the way you said. Restoring with the webpage still gives me an error. If I refresh the page afterwards I see the new database. I can choose it to login with, but the data hasn't been restored. (users don't exist, password of admin user is the default one,...). Restoring by commandline (pg_restore you provided) restores the db, but I cannot see it in the database manager. Any idea what I am doing wrong?

Rachid

reboot your postgresql server that error came when the database is in use from another pid

Stijn

الكاتب

I found it, The owner of the database I created with the commandline was wrong. I altered the database to set the correct user and now it works. Thank you.

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
ProgrammingError: column res_partner.lang does not exist تم الحل odooV8 odooV8_database	2 أغسطس 18	20328
Embed JS code Odoo 8 odoo odooV8 odooV8_database	0 مارس 15	5618
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ odooV8	0 مارس 25	2017
How to remove model if not in the py files anymore odooV8	0 يناير 25	4291
Start odoo server automatically in Ubuntu 14.04 on reboot تم الحل odooV8	1 أغسطس 23	15929

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!