Re: Hot standby from Debian to Windows

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hot standby from Debian to Windows
Date: 2020-03-30 16:01:24
Message-ID: 4a1d12b7-8bd0-b74f-87a7-a97ae4c177c8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 behind something like pgpool?
>
> Backup server will use single core and minimal RAM. It may be needed 0-2
> times per year.
>
> pgpool should switch to use it for production work only if main server
> does not respond.
> I havent found this feature in pgpool documentation (maybe missed).

Here is one example:

https://www.pgpool.net/docs/latest/en/html/example-watchdog.html

>
> Andrus.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-03-30 16:09:24 Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Previous Message Adrian Klaver 2020-03-30 14:59:04 Re: Uploading existing shapefile from geoserver to postgresql