From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Muhammad Bilal Jamil <mbjamil92(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Database trigger (one server to another) |
Date: | 2022-05-31 19:20:30 |
Message-ID: | 0de4339e-b80e-8c32-8a07-7b8f2295f9b0@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/31/22 11:59 AM, Muhammad Bilal Jamil wrote:
> Hi fellow database engineers,
>
> I am currently on a project where i have read only access to a
> production system (replicated) from where i want to copy data into
> another schema. Ideally what i want to do is that if for an event
> happens in the replicated schema (server#1) like something updates, then
> my database trigger runs and copies data from server#1 to my 2nd schema
> (server#2) for which i have read/write rights.
>
> Is this something possible? I would create the trigger in the 2nd server
> obviously since for first one i cant write anything.
You might try postgres_fdw:
https://www.postgresql.org/docs/current/postgres-fdw.html
Set up a table in the second server that links to the other server. Then
you have access to the data on the second server.
>
> Best
> Bilal
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2022-06-01 01:50:46 | Re: Order of rows in statement triggers NEW/OLD tables |
Previous Message | Muhammad Bilal Jamil | 2022-05-31 18:59:41 | Database trigger (one server to another) |