From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Moving large table between servers: logical replication or postgres_fdw |
Date: | 2018-12-05 06:13:50 |
Message-ID: | 9ffcfc88-8bf0-8f76-6126-4fdbdbdc4993@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/05/2018 12:05 AM, Rob Sargent wrote:
>> On Dec 4, 2018, at 8:14 PM, Rhys A.D. Stewart <rhys(dot)stewart(at)gmail(dot)com> wrote:
>>
>> Greetings Folks,
>>
>> I have a relatively large table (100m rows) that I want to move to a
>> new box with more resources. The table isn't doing anything...i.e its
>> not being updated or read from. Which approach would be faster to move
>> the data over:
>>
>> a). Use pg_fdw and do "create local_table as select * from foreign_table".
>> b). setup logical replication between the two servers.
> Can’t help but think an unread unwritten table goes to quietly to /dev/null :)
Sigh, no.
The legal and audit teams, and the customer, would be most upset if the data
you're legally obligated to keep for 7 years suddenly disappears.
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Romero Benavides | 2018-12-05 06:13:57 | Re: Moving large table between servers: logical replication or postgres_fdw |
Previous Message | Rob Sargent | 2018-12-05 06:05:38 | Re: Moving large table between servers: logical replication or postgres_fdw |