Odoo Help


Postgresql stopped working [Closed]

on 1/28/14, 10:00 AM 2,064 views

The Question has been closed

Ray Carnes
on 01/28/2014 21:12:04


OpenERP Server Error

Client Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 764, in get_list
    monodb = db_monodb(req)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 129, in db_monodb
    return db_redirect(req, True)[0]
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 109, in db_redirect
    dbs = db_list(req, True)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 90, in db_list
    dbs = proxy.list(force)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 359, in exp_list
    cr = db.cursor()
  File "/opt/openerp/server/openerp/sql_db.py", line 484, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/opt/openerp/server/openerp/sql_db.py", line 182, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File "/opt/openerp/server/openerp/sql_db.py", line 377, in _locked
    return fun(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/sql_db.py", line 440, 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: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Please help me its live database

Try with sudo service postgresql restart

GH Mediacloud, Grover Menacho
on 1/28/14, 11:11 AM

Can you connect using pgAdmin?

Rafael Reuber
on 1/28/14, 11:36 AM

I tried using both the above things not able to connect both ways.

on 1/28/14, 12:32 PM

I have resolved this issue by removing postgresql and again installed it. It's working fine.

on 1/28/14, 1:15 PM

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: 1/28/14, 10:00 AM
Seen: 2064 times
Last updated: 3/16/15, 8:10 AM