Re: partial data migration - Mailing list pgsql-general

From Adrian Klaver
Subject Re: partial data migration
Date
Msg-id 94531729-4c27-4f3e-39c0-aa7915425e7a@aklaver.com
Whole thread Raw
In response to Re: partial data migration  (Julie Nishimura <juliezain@hotmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Tools to migrate data from Json files to PostgreSQL DB.
Next
From: Tony Shelver
Date:
Subject: Re: Tools to migrate data from Json files to PostgreSQL DB.