Re: replication

From: Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: replication
Date: 2025-04-25 14:19:58
Message-ID: d6eea96e-f96f-4285-8632-ab7e4092bb48@cloud.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 4/25/25 14:50, Marc Millas wrote:
> Hello,
>
>
> One of my customers tells me he did a replication with the master on a
> debian 10
> and the slave on a debian 12, both with a pg13.20, one on a pgdg110+1,
> the other a pgdg120.1
>
> is this a good idea ??? (I don't think so...)

Sorry I dont quite get the pgdg110 vs pgdg120 distinction I guess they
each support a different release of debian, but using the same
architecture (e.g. amd64), same on disk structure structure , same
PostgreSQL major version is a minimum for physical replication and you
are 100% safe with that.

In order to be more flexible your client might want to try logical
replication which lifts any of the restrictions mentioned above (if
applicable) and even allows near zero-time upgrades.

>
> thanks,
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-04-25 15:13:49 Re: Clarification on RLS policy
Previous Message Achilleas Mantzios - cloud 2025-04-25 14:04:15 Re: Clarification on RLS policy