> Source: [sk105346](https://support.checkpoint.com/results/sk/sk105346)

# sk105346 - "psql: could not connect to server: No such file or directory" when connecting to SmartReporter Database

| Property | Value |
|----------|-------|
| Solution ID | sk105346 |
| Date Created | 2015-03-25 |
| Last Modified | 2017-05-11 |
| Technical Level | Advanced |
| Products | Security Management Server |
| Versions | R82.10, R82, R81.20, R82.20 |
| OS | Gaia |

## Symptoms

- * The following is observed / experienced on SmartReporter Server:

  * SmartReporter Consolidation session fails to start.

  * The following error appears when connecting to SmartReporter Database:

    ```
    
    [Expert@HostName]# $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database
    psql: could not connect to server: No such file or directory
            Is the server running locally and accepting
            connections on Unix domain socket '/tmp/.s.PGSQL.18272'?
    ```

* The following is observed / experienced on SmartEvent Server:

  * "`Authentication Failure`" error when trying to connect with SmartEvent GUI to SmartEvent Server.

  * After enabling generation of core dump files per [sk92764](http://supportcontent.checkpoint.com/solutions?id=sk92764) / [sk53363](http://supportcontent.checkpoint.com/solutions?id=sk53363), core dump files for '*cpsemd* ' process were generated in the */var/log/dump/usermode/* directory.

  * Debug of CPSEMD process (per [sk95153](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk95153)) shows:  

    `SetToSql fail to init sql engine`

  * Output of *netstat -anp \| grep 18272* command shows that *postgres* service does not listen on TCP port 18272.

## Cause

* On SmartReporter Server: The Postgres database is down / corrupted.
* On SmartEvent Server: Postgres process is not registered correctly.

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content