Thank you Ron! What if dev environment is on 9.6, but prod is on version 8.3? Will posgtres_fdw still be the right option?
Sent from my iPhone On Mar 6, 2019, at 11:57 PM, Ron <ronljohnso...@gmail.com<mailto:ronljohnso...@gmail.com>> wrote: On 3/7/19 1:54 AM, Julie Nishimura wrote: Hello psql friends, We need to migrate only 6 months worth of data from one instance to another. What would be the easiest way to do it? In Oracle, I would set up dblink. What about postgresql? postgres_fdw -- Angular momentum makes the world go 'round.