Skip to Content
This question has been flagged
odooV8odooV8_database
1 Odpoveď
14811 Zobrazenia
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
Zrušiť
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
Zrušiť
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.

Related Posts Replies Zobrazenia Aktivita
ProgrammingError: column res_partner.lang does not exist Solved
odooV8 odooV8_database
Avatar
Avatar
Avatar
2
aug 18
20328
Embed JS code Odoo 8
odoo odooV8 odooV8_database
Avatar
0
mar 15
5618
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
4290
Start odoo server automatically in Ubuntu 14.04 on reboot Solved
odooV8
Avatar
Avatar
1
aug 23
15927