Skip to content Skip to sidebar Skip to footer

Set Up Seperate Odoo Server With Other Database in Linux

Hey, how are you?
I hope you are doing fine. Because i know you are kinda stressed out figuring out how to connect odoo to other database. Don't worry, i've been there and i am gonna make sure that i am the only one who having a headache haha.
Setting up odoo with seperate database is actually quite simple, but its kinda confusing for the first time. It happened to me. But after figuring out, it's not that hard. Odoo Team make it simple. Thanks to them.

So here is how to point your odoo server to other postgresql database :
  1. First, login as root;
  2. Type nano /etc/odoo-server.conf. if you are curious, its a .conf file where they set the main configuration stored;
  3. To connect your server, you need to edit these parameters. Please match it with your settings :

    db_host = assign this with your database IP
    db_password = type your database password here
    db_port = 5432 (this is defaul postgresql port)
    db_user = odoo (change this unless you use other account as database manager)
    db_filter = false
    http_interface = type your odoo server IP
    http_port = 8069

  • To save your configuration, press ctrl + x and then press y
  • Restart your computer or just simply restart odoo service by typing service odoo-server restart

  • Thank You Vionblog for kind of troubleshot step