Hey guys, i am trying to achieve this scenario: I have odoo and postgres running on the same VM. I want to decouple things, and i want to use a separate postgres server.
What am i doing:
1 - dump the db as postgres user from the current server(odoo1)
2 - create a non-superuser sql account on the postgres server(postgres1) and grant access to a new db. I also tested to see if i can access the remote db and everything works just fine.
3 - import the sql dump in the new db.
4 - change the odoo.conf db_user / dbfilter / db_password / db_host - to reflect the new server.
5 - copy the filestore folder+contents to a new folder that has the same name as the new db.
6 - start odoo
The problem is that after starting odoo, i get the database selector page, instead of odoo simply working from the remote db.
https://www.screencast.com/t/IkV4V0N9
I am pretty stuck and i have no idea what to do here.
The log shows it's connecting to the remote db, but i can't get odoo to work
2018-09-26 15:54:46,048 26475 INFO ? odoo: Odoo version 11.0
2018-09-26 15:54:46,053 26475 INFO ? odoo: Using configuration file at /etc/odoo11-machine-server.conf
2018-09-26 15:54:46,054 26475 INFO ? odoo: addons paths: ['/home/work/odoo11/.local/share/Odoo/filestore/addons/11.0', '/home/work/odoo11/odoo11-server/addons', '/home/work/odoo11/odoo11-server/odoo/addons']
2018-09-26 15:54:46,054 26475 INFO ? odoo: database: db_user@10.111.0.12:5432
2018-09-26 15:54:46,073 26475 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2018-09-26 15:54:46,166 26475 INFO ? odoo.addons.base.ir.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf
2018-09-26 16:28:14,953 26475 INFO ? odoo.http: HTTP Configuring static files
2018-09-26 16:28:15,025 26475 INFO ? odoo.http: Generating nondb routing
Thanks in advance,