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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

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

odooV8 odooV8_database

1 Vastaa

14834 Näkymät

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

Tekijä

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

Tekijä

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.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
ProgrammingError: column res_partner.lang does not exist Ratkaistu odooV8 odooV8_database	2 elok. 18	20351
Embed JS code Odoo 8 odoo odooV8 odooV8_database	0 maalisk. 15	5631
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ odooV8	0 maalisk. 25	2034
How to remove model if not in the py files anymore odooV8	0 tammik. 25	4323
Start odoo server automatically in Ubuntu 14.04 on reboot Ratkaistu odooV8	1 elok. 23	15938

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!