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]
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?
... 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.
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
|Asked: 11/6/14, 5:38 AM|
|Seen: 652 times|
|Last updated: 3/16/15, 8:10 AM|