How to implement offline synchronization of two PostgreSQL databases?

Question

PostgreSQL

Problem: there is a combat base spinning in an isolated network, there is only physical access. It is necessary to periodically somehow clone the data into another database manually, but each time it takes a very long time to do a complete dump of the database, the database is large. How can you organize the synchronization of a copy of the database with the combat one without transferring at each synchronization in its entirety?

Answer 1

Look at incremental backup.
https://wiki.postgresql.org/wiki/Incremental_backup
Options:
https://stackoverflow.com/questions/5529603/best-m...
https://coderwall.com/p/jxebnw/incremental-backups.. .

Answer 2

you need to implement a warehouse project

Answer 3

If your second base is read-only, then the built-in hot standby mechanism will work
https://www.postgresql.org/docs/current/static/hot...