Thread: 2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failedto initialize database `abc`

Hello Community,

Anyone has configured odoo with postgres? Please guide me with the below
error.

We have been experiencing an error while configuring the odoo(odoo 11.0) 
application to the postgres(postgres 10.5) database. We have done the
configuration in two approaches.

First Approach:

All the objects in the database 'abc' are defined in the "public" schema. In
this approach, the application is configured successfully without errors.

Second Approach:

The objects in the database "abc" are moved to custom schema named "xyz". 
Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
odoo.service.server: Failed to initialize database `abc`" . In detail it is
throwing the error "relation ir_%%  exists".

Please help us to cope up with this error. 

Looking forward to hear from you. Thanks in Advance!.



Regards,

Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

On 11/28/18 7:16 AM, pavan95 wrote:
> Hello Community,
> 
> Anyone has configured odoo with postgres? Please guide me with the below
> error.
> 
> We have been experiencing an error while configuring the odoo(odoo 11.0)
> application to the postgres(postgres 10.5) database. We have done the
> configuration in two approaches.
> 
> First Approach:
> 
> All the objects in the database 'abc' are defined in the "public" schema. In
> this approach, the application is configured successfully without errors.
> 
> Second Approach:
> 
> The objects in the database "abc" are moved to custom schema named "xyz".
> Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
> odoo.service.server: Failed to initialize database `abc`" . In detail it is
> throwing the error "relation ir_%%  exists".
> 
> Please help us to cope up with this error.

At a guess the ORM is configured to look in public.*

To find out if there is a way to change this I would suggest the Odoo forum:

https://www.odoo.com/forum/help-1

> 
> Looking forward to hear from you. Thanks in Advance!.
> 
> 
> 
> Regards,
> 
> Pavan
> 
> 
> 
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Am 28.11.2018 um 16:16 schrieb pavan95:
> The objects in the database "abc" are moved to custom schema named "xyz".
> Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
> odoo.service.server: Failed to initialize database `abc`" . In detail it is
> throwing the error "relation ir_%%  exists".

have you checked if this relation exists? Have you set search_path to 
xyz instead of the default public?


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com