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