Odoo Help


Problem with postgres

on 5/24/16, 8:22 AM 883 views

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi


File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute

application_iter = app(environ, start_response)

File "/opt/odoo/src/openerp/service/server.py", line 281, in app

return self.app(e, s)

File "/opt/odoo/src/openerp/service/wsgi_server.py", line 216, in application

return application_unproxied(environ, start_response)

File "/opt/odoo/src/openerp/service/wsgi_server.py", line 202, in application_unproxied

result = handler(environ, start_response)

File "/opt/odoo/src/openerp/http.py", line 1224, in __call__

return self.dispatch(environ, start_response)

File "/opt/odoo/src/openerp/http.py", line 1198, in __call__

return self.app(environ, start_wrapped)

File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__

return self.app(environ, start_response)

File "/opt/odoo/src/openerp/http.py", line 1336, in dispatch


File "/opt/odoo/src/openerp/http.py", line 1282, in setup_db

httprequest.session.db = db_monodb(httprequest)

File "/opt/odoo/src/openerp/http.py", line 1408, in db_monodb

dbs = db_list(True, httprequest)

File "/opt/odoo/src/openerp/http.py", line 1382, in db_list

dbs = dispatch_rpc("db", "list", [force])

File "/opt/odoo/src/openerp/http.py", line 100, in dispatch_rpc

result = dispatch(method, params)

File "/opt/odoo/src/openerp/service/db.py", line 70, in dispatch

return fn(*params)

File "/opt/odoo/src/openerp/service/db.py", line 313, in exp_list

with closing(db.cursor()) as cr:

File "/opt/odoo/src/openerp/sql_db.py", line 569, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "/opt/odoo/src/openerp/sql_db.py", line 181, in __init__

self._cnx = pool.borrow(dsn)

File "/opt/odoo/src/openerp/sql_db.py", line 460, in _locked

return fun(self, *args, **kwargs)

File "/opt/odoo/src/openerp/sql_db.py", line 520, in borrow

result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)

File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect

connection_factory=connection_factory, async=async)

OperationalError: FATAL: could not open relation mapping file "global/pg_filenode.map": Permission denied

How can I fix this ? 

I think it has to do with the user rights, that one directory has the wrong userrights or something?

on 5/24/16, 8:40 AM
Ruchir Shukla
On 5/24/16, 8:47 AM

Hello !

Check the permission and the Owner of the `/var/lib/postgresql/9.3/main/global/pg_filenode.map` file

you can check it with the postgres user only. It should be somewhat like below. 

 ls -al /var/lib/postgresql/9.3/main/global/pg_filenode.map

-rw------- 1 postgres postgres 512 Jun 25 2015 /var/lib/postgresql/9.3/main/global/pg_filenode.map

these in the /var/lib/postgresql are all on user odoo, shouldn't they be postgres?

on 5/24/16, 8:49 AM

Yes it has to belongs to the user postgres

Ruchir Shukla
on 5/24/16, 8:50 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/24/16, 8:22 AM
Seen: 883 times
Last updated: 5/24/16, 11:45 AM