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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

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

odooV8 odooV8_database

1 Odpowiedz

14800 Widoki

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

Autor

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

Autor

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
ProgrammingError: column res_partner.lang does not exist Rozwiązane odooV8 odooV8_database	2 sie 18	20321
Embed JS code Odoo 8 odoo odooV8 odooV8_database	0 mar 15	5614
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ odooV8	0 mar 25	2012
How to remove model if not in the py files anymore odooV8	0 sty 25	4288
Start odoo server automatically in Ubuntu 14.04 on reboot Rozwiązane odooV8	1 sie 23	15925

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!