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(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com