We will configure a logic replication of a database table of our linux server in a postgresql installation in a windows workstation.
The replication allows us to keep an updated copy of the centralized database in a remote station. This copy will not be used for local updates since it will be read-only. On the other hand, it allows us to work offline and much faster, since the exchanges between the central database and the local replicate contain only the updates of the centralized database. Continue reading “Replicating a postgresql database in a windows workstation”