Logic replication appeared in Postgresql 10, is it possible in the normal way (without add. Tables, etc.) to replicate tables only at a certain time? I think that this method will be more efficient in terms of traffic and productivity than loading - uploading to a file.

Example:
10 insert s were made in the table and then 9 of these records were deleted, I want the record to go to another server at the end of day 1.

  • Hardly logical replication can do that. Any replication is an exact repetition of all operations. To understand that out of 10 new entries, 9 deleted, a separate logic is needed, which is looking for exactly such situations and this is not incorporated into the replication mechanisms. I'm afraid this is only possible with my own scripts. The truth is still not clear what these scripts will do with changes to existing records. It is clear that we need the latest version of the record, but first we need to understand that the record has changed, then we have to do logging triggers - Mike

0