Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
odooV8odooV8_database
1 Odgovori
14826 Prikazi
Avatar
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?

 

Avatar
Opusti
Avatar
Rachid
Best Answer

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

Avatar
Opusti
Stijn
Avtor

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
Avtor

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.

Related Posts Odgovori Prikazi Aktivnost
ProgrammingError: column res_partner.lang does not exist Solved
odooV8 odooV8_database
Avatar
Avatar
Avatar
2
avg. 18
20339
Embed JS code Odoo 8
odoo odooV8 odooV8_database
Avatar
0
mar. 15
5621
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ
odooV8
Avatar
0
mar. 25
2017
How to remove model if not in the py files anymore
odooV8
Avatar
0
jan. 25
4293
Start odoo server automatically in Ubuntu 14.04 on reboot Solved
odooV8
Avatar
Avatar
1
avg. 23
15931