Re: Incremental backup from a streaming replication standby fails - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Incremental backup from a streaming replication standby fails
Date
Msg-id 985825083da240ef8f3e32e2f49fc93fe1aeac7e.camel@cybertec.at
Whole thread Raw
In response to Re: Incremental backup from a streaming replication standby fails  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Incremental backup from a streaming replication standby fails
List pgsql-hackers
On Fri, 2024-07-19 at 12:59 -0400, Robert Haas wrote:
Thanks for looking at this.

> On Fri, Jul 19, 2024 at 11:32 AM David Steele <david@pgmasters.net> wrote:
> > I think it would be enough just to add a hint such as:
> >
> > HINT: this is possible when making a standby backup with little or no
> > activity.
>
> That could work (with "this" capitalized).
>
> > My guess is in production environments this will be uncommon.
>
> I think so too, but when it does happen, confusion may be common.

I guess this will most likely happen during tests like the one I made.

I'd be alright with the hint, but I'd say "during making an *incremental*
standby backup", because that's the only case where it can happen.

I think it would also be sufficient if we document that possibility.
When I got the error, I looked at the documentation of incremental
backup for any limitations with standby servers, but didn't find any.
A remark in the documentation would have satisfied me.

Yours,
Laurenz



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows
Next
From: Robert Haas
Date:
Subject: Re: Wrong results with grouping sets