# Making postgresql and logstash synchronized

**URL:** <https://discuss.elastic.co/t/making-postgresql-and-logstash-synchronized/137196>\
**Category:** Logstash\
**Created:** [June 25, 2018, 7:00am UTC](https://discuss.elastic.co/t/making-postgresql-and-logstash-synchronized/137196 "2018-06-25T07:00:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Iremsu](https://avatars.discourse-cdn.com/v4/letter/i/ac91a4/32.png) [@Iremsu](https://discuss.elastic.co/u/Iremsu)\
**Post date:** [June 25, 2018, 7:00am UTC](https://discuss.elastic.co/t/making-postgresql-and-logstash-synchronized/137196/1 "2018-06-25T07:00:32Z")

</div>

Hi all,  
I am new on elk stack. I am using postgresql and the thing that i am trying to do it: i have a table called testtable with two columns key and value; whenever i add something in to these columns in my database i want it to be seen from logstash, i have a .conf file and inside of it i put a line:  
statement =\> "select \* from testtable"  
It is working to pick the table but when i just want to insert just one value it will always take again and again all the database table. So is there a way for logstash to take just once the all table and then whenever i insert just the inserted ones?  
Thank you

---

<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:** [July 23, 2018, 7:00am UTC](https://discuss.elastic.co/t/making-postgresql-and-logstash-synchronized/137196/2 "2018-07-23T07:00:44Z")

</div>

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