Issue

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

  connection_factory=connection_factory, async=async)

psycopg2.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"?

Solution:

sudo /etc/init.d/postgresql restart