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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

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

odooV8 odooV8_database

1 Beantwoorden

14801 Weergaven

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

Auteur

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

Auteur

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.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
ProgrammingError: column res_partner.lang does not exist Opgelost odooV8 odooV8_database	2 aug. 18	20321
Embed JS code Odoo 8 odoo odooV8 odooV8_database	0 mrt. 15	5614
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ odooV8	0 mrt. 25	2012
How to remove model if not in the py files anymore odooV8	0 jan. 25	4288
Start odoo server automatically in Ubuntu 14.04 on reboot Opgelost odooV8	1 aug. 23	15925

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!