title: import old data from postgres to elasticsearch
body: <p>I have a lot of data in my postgres database( on a remote). This is the data of the past 1 year, and I want to push it to elasticsearch now.</p>
  
  <p>The data has a time field in it in this format <code>2016-09-07 19:26:36.817039+00</code>.</p>
  
  <p>I want this to be the timefield(<code>@timestamp</code>) in elasticsearch. So that I can view it in kibana, and see some visualizations over the last year.</p>
  
  <p>I need help on how do I push all this data efficiently. I cannot get that how do I get all this data from postgres.</p>
  
  <p>I know we can inject data via jdbc plugin, but I think I cannot create my  <code>@timestamp</code> field with that.</p>
  
  <p>I also know about zombodb but not sure if that also gives me feature to give my own timefield.</p>
  
  <p>Also, the data is in bulk, so I am looking for an efficient solution</p>
  
  <p>I need help on how I can do this. So, suggestions are welcome.</p>