Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
2703 Weergaven

I made a dump of an odoo database with pgdump, retored that dump file into a new database and wonder now hoe do I tell odoo that is shoud list that new databse in the login window.

sudo su – postgres -s /bin/bash

pg_dump [database name] [dump_name]

createdb [new_database]

pgsl [new_database] > [dump_name]

is what I did. I can see that there is a new databse (psql -l) and the restore procedure was sucessfull I think. I restarted the odoo-server but can't choose my new database in the login window. may I have to restart odoo in any arguments in order to get the connection running?

Avatar
Annuleer

A simple refresh of your webpage should be enough. (A hard refresh)

Auteur

how do I hard refresh my webpage? I have tried F5, deleting the cache. Did not do the trick. I noted another thing though ... psgl -l show my new databse being owned by postgres while another database I made from the odoo interface is being owned by odoo. Maybe that could be the reason ... just how do I change ownership. I guess there must be a postgres command of some sort that does that

Beste antwoord

... You've made the new database under the wrong user [postgres] which is not used for your Odoo. The easiest way is to use sudo su odoo and then create the new database once again from the dump. After you did that and do an F5 you'll see it is in the list. The current DB you made is now under another user and this is the reason it is not showing up in your list.

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
0
jul. 25
1510
2
nov. 24
6514
2
okt. 24
3476
2
aug. 24
2001
3
jul. 24
8399