From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
---|---|
To: | Keith <keith(at)keithf4(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: native solutions for copying data between PG servers? |
Date: | 2020-07-10 19:14:30 |
Message-ID: | CAOC+FBX_K1M3H=JquJm416nqb3RJAcq1if7duSxT2mmyXerkCw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Cool, I should have been more clear: definitely not a replication
situation. Just a few views here and there I'd like copied...
On Fri, Jul 10, 2020 at 12:07 PM Keith <keith(at)keithf4(dot)com> wrote:
>
> On Fri, Jul 10, 2020 at 2:56 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
> wrote:
>
>> Hi all: what are some native solutions (if any?) for copying data between
>> PG servers? v12.3 if it matters.
>>
>> I have some python scripts that select from views on A and dump into
>> tables on B and it works well enough but I'd like to see if other solutions
>> might work... a little faster.
>>
>> Thanks.
>>
>> --
>> Wells Oliver
>> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>>
>
>
> Take a look at the postgres_fdw. Basically makes the remote table(s) look
> like local tables. That's probably the easiest solution.
>
> https://www.postgresql.org/docs/current/postgres-fdw.html
>
> There's also logical replication, but that can be trickier to set up
>
> https://www.postgresql.org/docs/current/logical-replication.html
>
>
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2020-07-10 20:05:24 | Re: OK to delete old .history files from archive? |
Previous Message | Keith | 2020-07-10 19:07:22 | Re: native solutions for copying data between PG servers? |