Re: pg_upgradecluster and synchronous replication

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Christoph Berg <myon(at)debian(dot)org>
Cc: pgsql-pkg-debian(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgradecluster and synchronous replication
Date: 2026-01-15 22:41:40
Message-ID: c43730ee39ecd2128584414c8f130dcb272bd3be.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

On Thu, 2026-01-15 at 05:40 +0100, I wrote:
> > On Wed, 2026-01-14 at 20:39 +0100, Christoph Berg wrote:
> > >
> > > Maybe we should instead change the analyze hook script to do that
> > > internally? Setting PGOPTIONS should be enough:
> > >
> > >     PGOPTIONS="-csynchronous_commit=local"
>
> Yes, I think that is the proper solution!

How about the attached patch?

Yours,
Laurenz Albe

Attachment Content-Type Size
v2-0001-Prevent-ANALYZE-from-waiting-for-synchronous-stan.patch text/x-patch 1.1 KB

In response to

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message apt.postgresql.org Repository Update 2026-01-19 12:37:51 h3-pg updated to version 4.2.3-3.pgdg+1
Previous Message apt.postgresql.org Repository Update 2026-01-15 14:23:45 credcheck updated to version 4.4-1.pgdg+1