HostProblems

Common Host Problems

Host installation problems

Postgres is not properly installed

How to detect:

• /var/log/tomato/server.log ends with

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

• $> /etc/init.d/postgresql status prints nothing at all

• /etc/postgresql does not exist

Reason for this error:

• An error happend during installation of the postgresql package that prevented creation of the cluster configuration.
• This can happen when installation is done in an ssh session from a computer using a locale that is not installed on the host.

How to solve:

• Run the follwing commands (assuming postgresql version is 9.1):

    $> dpkg --force-depends --purge postgresql-9.1
    $> apt-get install postgresql-9.1
  

• Answer all questions by pressing return (accepting the defaults)