Re: partial data migration

On 3/7/19 5:53 PM, Julie Nishimura wrote:
> 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?

Thanks to the documentation writers:

https://www.postgresql.org/docs/11/postgres-fdw.html#id-1.11.7.42.15

> 
> Sent from my iPhone
> 
> On Mar 6, 2019, at 11:57 PM, Ron <ronljohnsonjr@gmail.com 
> <mailto:ronljohnsonjr@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.


-- 
Adrian Klaver
adrian.klaver@aklaver.com