4 ms·
Logical replication, in Postgres, contains all of the information about the change statement (insert/update/delete) in order to logically recreate the same stat
by agentultra 3y ago
Logical replication, in Postgres, contains all of the information about the change statement (insert/update/delete) in order to logically recreate the same state in another database.
You won't get client-level providence data with each change...
However you could hack around that. The logical replication stream can also include informational messages from the "pg_logical_emit_message" function to insert your own metadata from clients. It might be possible to configure your clients to emit their identifier at the beginning of each transaction.