Re: Hot standby from Debian to Windows

On 3/29/20 5:35 AM, Andrus wrote:
> Hi!
>
> Postgres 12 server is running on Debian 10 and has number of databases.
>
> How to mirror changes of those databases to Windows 10 workstation which
> runs also Postgres 12.
>
> Changes in server databases in Debian should sent to Postgres 12
> database in Windows over internet.
>
> If Debian server goes down, users can change server address to Windows
> computer as temporary workaround and continue working.

Since you are moving between different OSes you will need to use some
form of logical replication as binary replication will not work. Given
that you are Postgres 12 you could use the builtin logical replication:

https://www.postgresql.org/docs/12/logical-replication.html

How that needs to managed is going to need more information. As a start:

1) Downtime allowed?

2) All databases to be replicated or just some?

3) Permissible lag between servers?

4) How are you going to deal with the down server and how do you plan on
bringing it up again?

>
> Andrus.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com