# Metricbeat postgresql shows timeout error

**URL:** <https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [September 18, 2018, 7:26pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017 "2018-09-18T19:26:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhimanyu\_Kaushal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhimanyu_kaushal/32/35645_2.png) [@Abhimanyu\_Kaushal](https://discuss.elastic.co/u/Abhimanyu_Kaushal)\
**Post date:** [September 18, 2018, 7:26pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017/1 "2018-09-18T19:26:03Z")

</div>

Hi, I'm using metricbeat to monitor my postgres server. I've tried telnet and also able to successfully ping my postgres server. But metricbeat is showing this error message: "QueryStats: dial tcp \<my\_pg\_IP\>:5432: i/o timeout"

---

<div class="post-metadata">

**Author:** ![jsoriano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsoriano/32/27920_2.png) [@jsoriano](https://discuss.elastic.co/u/jsoriano)\
**Post date:** [September 19, 2018, 10:17am UTC](https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017/2 "2018-09-19T10:17:23Z")

</div>

Hi @Abhimanyu_Kaushal and welcome 🙂

This is strange because actually the postgresql module doesn't do anything fancy with the connection, an I/O timeout uses to indicate a connectivity problem.  
How are you deploying metricbeat? Are you checking the connection from the exact same host as the one showing this error? Could you also check with a postresql cli client?

---

<div class="post-metadata">

**Author:** ![Abhimanyu\_Kaushal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhimanyu_kaushal/32/35645_2.png) [@Abhimanyu\_Kaushal](https://discuss.elastic.co/u/Abhimanyu_Kaushal)\
**Post date:** [September 19, 2018, 10:32am UTC](https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017/3 "2018-09-19T10:32:48Z")

</div>

I think the problem was with my server security group. It was not configured to receive TCP connections. I've changed my security group settings and will need to reboot my machine. Currently it's in production environment so I cannot reboot. So, I'll have to wait till midnight. But still, thanks for the quick response.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 17, 2018, 10:32am UTC](https://discuss.elastic.co/t/metricbeat-postgresql-shows-timeout-error/149017/4 "2018-10-17T10:32:50Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.