Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to get my database_manager list back?

By
dfor mer
on 9/25/13, 6:49 AM 1,226 views

After doing a restore from pgadmin3 on my db I have lost the db list in the db manager. Is there anyway to get that back?

1

Andreas Brueckl

--Andreas Brueckl--
5056
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 9/25/13, 7:25 AM

I assume, that you have not restored the database with the User, which is used by OpenERP. See option db_user in openerp-server.conf.

You have to use this user when you create/restore a DB.

In pgAdmin you can Right-Click the database, then Properties and then you can change the owner!

UFFF... I did. Will this have any negetive effects or can I just run with it

dfor mer
on 9/25/13, 12:23 PM

I tried that but still doesn't help. I am getting this error when trying to create a new DB in the DB Manager: ProgrammingError: relation "ir_config_parameter" does not exist LINE 1: SELECT "ir_config_parameter".id FROM "ir_config_parameter" W... Is there anyway to correct this?

dfor mer
on 9/26/13, 4:29 AM

Looks like you have not correctly restored the backup. The ir_config_parameter table should exist in your database.

Andreas Brueckl
on 9/26/13, 4:47 AM

I apologize for beforehand for adding an answer when it isn't an answer but I had no way to add and image otherwise......Tried, but I don't have enough karma to up load images. Anyway, I do have the talbe in the DB and all seems correct. What else could it be?

dfor mer
on 9/26/13, 5:15 AM

Looks like the owner of the tables is also wrong and therefore the PostgreSQL user which is used by OpenERP does not have permissions to read it. I suggest to restore the whole Database with the correct user.

Andreas Brueckl
on 9/26/13, 5:21 AM
0
dfor mer
On 9/26/13, 6:09 AM

Ok, figured it out.

While I could access and login to the DB that didn't appear in the DB manager it wasn't showing up in the dropdown.

So I deleted all dbs except for my main one in postgre and then recreated a demo one through the db manager. That gave me the dropdown again without my main DB but with the demo one only.

I simply typed in the name of my main db in the dropdown and hit enter and low and behold it now appears in the dropdown.

If you help or further details just let me know.

Hope it helps someone

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 9/25/13, 6:49 AM
Seen: 1226 times
Last updated: 3/16/15, 8:10 AM