How to Restore Database from ancient server

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

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

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to Restore Database from ancient server

import database v7

1 Odpowiedz

7351 Widoki

sunwukong69

I try to figure out how to restore a database from a local installation to a newly configured openerp on another local server.

The origin db is a server on my laptop and the destination is a server on a Raspberry Pi with 512m of memory. Openerp is installed on the Raspberry Pi but anything I try result on 'Impossible to restore database'.

For the restoring process I do the following (v7, Postgresql 9.1.9):

1-I save the database in the administration of the old openerp server--> which give me a ".dump" file.

2-I move the .dump file on the new server and, through the same database administration menu, I restore it with the same name of the blank database.

Help is welcome.

Ian Beardslee

An interesting project. Not sure I'd be impressed with the speed though! Do you have further details about how you are doing the dump from the original database and how you are attempting to do the restore. Looking through the openerp and postgres logs would be a good place to start to further expand on what the actual error is.

sunwukong69

Autor

The speed with the Pi is actually a lot faster than I thought, response is around 2-3 seconds when charging new menus and almost inmediate when in the same menu. There is still no datas though...

Davide Corio

You are probably missing the pgpass file on the target server.

Inside the home of the system user that run the openerp process, create an hidden file called .pgpass.

Inside this file you have to write something like:

localhost:5432:*:myuser:mypassword

replace myuser and mypassword with the correct postgresql credentials (the ones you can see inside the openerp's server config file).

Set the correct file permission: chmod 600 .pgpass

Restart OpenERP then try to restore the dump file.

If this doesn't work, try to run OpenERP in foreground (by typing openerp-server --all-the-switch-you-need in the shell). You should notice that OpenERP is asking for the password in the server's shell. If this happens, you need to check pg credentials or auth mechanism in the pg_hba.conf file.

sunwukong69

Autor

Thanks for the answer. To be sure...: localhost:5432[local IP adress:port]:*[?]:myuser:mypassword? We are speaking of the "openerp/server/openerp-server.conf"? "--all-the-switch-you-need in the shell", what are the switches, ports? I tried option 1 with no results.

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
Go Live with OpenERP7 import database v7 live	1 mar 15	4231
How to select a different database on login screen Rozwiązane database v7	4 lip 24	33918
How to import multiple lines text fields with CSV ? Rozwiązane import v7	5 paź 23	23391
Database import and odoo start import database	2 sie 18	10301
How to import an existing chart of accounts? import v7	2 lip 16	12913

To pytanie dostało ostrzeżenie

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