[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Database trigger (one server to another)
From:       Adrian Klaver <adrian.klaver () aklaver ! com>
Date:       2022-05-31 19:20:30
Message-ID: 0de4339e-b80e-8c32-8a07-7b8f2295f9b0 () aklaver ! com
[Download RAW message or body]

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.klaver@aklaver.com


[prev in list] [next in list] [prev in thread] [next in thread]