Re: Hot standby from Debian to Windows

2020-03-30 Thread Adrian Klaver
On 3/30/20 11:36 AM, Adrian Klaver wrote: On 3/30/20 11:06 AM, Andrus wrote: Hi! Got it. Just thought it would be easier not to have to deal with cross OS issues. Here is one example: https://www.pgpool.net/docs/latest/en/html/example-watchdog.html Hopefully Windows Hyper-V virtual network

Re: Hot standby from Debian to Windows

2020-03-30 Thread Adrian Klaver
On 3/30/20 11:06 AM, Andrus wrote: Hi! Got it. Just thought it would be easier not to have to deal with cross OS issues. Here is one example: https://www.pgpool.net/docs/latest/en/html/example-watchdog.html Hopefully Windows Hyper-V virtual network adapter will not check windows 20 connecti

Re: Hot standby from Debian to Windows

2020-03-30 Thread Andrus
Hi! Got it. Just thought it would be easier not to have to deal with cross OS issues. Here is one example: https://www.pgpool.net/docs/latest/en/html/example-watchdog.html Hopefully Windows Hyper-V virtual network adapter will not check windows 20 connection limit. In this case using Debian+

Re: Hot standby from Debian to Windows

2020-03-30 Thread Adrian Klaver
On 3/29/20 11:35 PM, Andrus wrote: Hi! Would it not be easier to just set up another Debian server, run binary replication Breaks occurs rarely, 0-2 times per year. I want try it first. Got it. Just thought it would be easier not to have to deal with cross OS issues. and put them behi

Re: Hot standby from Debian to Windows

2020-03-29 Thread Andrus
Hi! Would it not be easier to just set up another Debian server, run binary replication Breaks occurs rarely, 0-2 times per year. I want try it first. and put them behind something like pgpool? Backup server will use single core and minimal RAM. It may be needed 0-2 times per year. pgpo

Re: Hot standby from Debian to Windows

2020-03-29 Thread Adrian Klaver
On 3/29/20 12:52 PM, Andrus wrote: Hi! Since you are moving between different OSes you will need to use some form of logical replication as binary replication will not work. I can use Hyper-V or something other to run Debian with Windows. This hopefully will also allow to bypass Windows 20 c

Re: Hot standby from Debian to Windows

2020-03-29 Thread Andrus
Hi! Since you are moving between different OSes you will need to use some form of logical replication as binary replication will not work. I can use Hyper-V or something other to run Debian with Windows. This hopefully will also allow to bypass Windows 20 connection limit so that more than 2

Re: Hot standby from Debian to Windows

2020-03-29 Thread Adrian Klaver
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