credativ team mailing list archive

[Serpent Consulting Services <question183974@xxxxxxxxxxxxxxxxxxxxx>]

Question #183974 on OpenERP Server changed:
https://answers.launchpad.net/openobject-server/+question/183974

    Status: Open => Answered

Serpent Consulting Services proposed the following answer:
Hello Pravitha,

Typically this error means PostgreSQL is not currently running on the
system you are logged into. You will need to start the daemon, which is
typically done through your distribution's init system. Try to run it if
its not running already.

I suppose your user has enough rights to access psql.

The easiest way to determine if PostgreSQL is running is to look for it
using ps. For example when I run the command on my Fedora system:

ps auxw | grep post

I see the following processes:

postgres  4335  2.4  0.2  27704  2936 ?        S    14:47   0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres  4337  0.0  0.0   9972   548 ?        S    14:47   0:00 postgres: logger process
postgres  4339  0.0  0.0  27704   804 ?        S    14:47   0:00 postgres: writer process
postgres  4340  0.0  0.0  10972   544 ?        S    14:47   0:00 postgres: stats buffer process
postgres  4341  0.0  0.0  10148   668 ?        S    14:47   0:00 postgres: stats collector process


Which as you can see means PostgreSQL is running on my local system. If we had received no results or just the final result line then we would no for certain that it is not running on this system. 

If it still does not solve,
-- Do this:
-- # chown postgres /tmp/.s.PGSQL.5432.lock 

If its still a path issue:
-- just edit /etc/paths and move the /usr/local/bin entry above /usr/bin and restart Terminal.

Hope this helps.

Thanks,
Serpent Consulting Services.
http://www.serpentcs.com

You received this question notification because you are a member of
OpenERP Framework Experts, which is an answer contact for OpenERP
Server.