How to integrate Elasticsearch and PgSQL?

Elastic Stack Elasticsearch
1

I have to push data from PgSQL to Elasticsearch? Any other method than CLI for indexing

2

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.

But you can also use Logstash JDBC input.