Re: partial data migration

From: Julie Nishimura <juliezain(at)hotmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: partial data migration
Date: 2019-03-08 01:53:31
Message-ID: BYAPR08MB50141F6594A1ECA52D2CEA41AC4D0@BYAPR08MB5014.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-03-08 01:59:46 Re: partial data migration
Previous Message Amit Langote 2019-03-08 00:36:07 Re: Update does not move row across foreign partitions in v11