Postgres Pro
Downloads
Home   >   mailing lists

Thread: User and Logical Replication

User and Logical Replication

From
Tobias Stadler
Date:
Hi,

Would it be possible to include the user (who changed the row) in the  logical replication data?

Best Reagrds
Tobias

Re: User and Logical Replication

From
Peter Eisentraut
Date:
On 2020-03-11 17:18, Tobias Stadler wrote:
> Would it be possible to include the user (who changed the row) in the  logical replication data?

Not without major re-engineering.

If you need this information, maybe a BEFORE INSERT OR UPDATE trigger 
could be used to write this information into a table column.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: User and Logical Replication

From
Tobias Stadler
Date:
Tanks for the Info.

> Am 11.03.2020 um 19:01 schrieb Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
>
> On 2020-03-11 17:18, Tobias Stadler wrote:
>> Would it be possible to include the user (who changed the row) in the  logical replication data?
>
> Not without major re-engineering.
>
> If you need this information, maybe a BEFORE INSERT OR UPDATE trigger could be used to write this information into a
tablecolumn. 
>
> --
> Peter Eisentraut              http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services