Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16215: Restore failes if number of workers in postgresql.conf is lower than on source system - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #16215: Restore failes if number of workers in postgresql.conf is lower than on source system
Date
Msg-id 3736031579254336@vla5-dcf36e533bf7.qloud-c.yandex.net
Whole thread Raw
In response to Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system  (Stefan Sonnenberg-Carstens <stefan.sonnenberg.carstens@gmail.com>)
Responses Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system  (Stefan Sonnenberg-Carstens <stefan.sonnenberg.carstens@gmail.com>)
List pgsql-bugs
Tree view 
Hello

> as far as I understand these restrictions apply when hot_standby is set to on AND a recovery.conf is missing.

When hot_standby is set to on AND a recovery.conf is PRESENT
Here is: https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/access/transam/xlog.c#L6185
ArchiveRecoveryRequested is set if we found recovery.conf (see readRecoveryCommandFile)

> I can confirm that hot_standby is commented out - is this setting on by default?

Yes, in postgresql 10 and newer.

regards, Sergei

pgsql-bugs by date:

Previous
From: Stefan Sonnenberg-Carstens
Date:
Subject: Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system
Next
From: Stefan Sonnenberg-Carstens
Date:
Subject: Re: BUG #16215: Restore failes if number of workers inpostgresql.conf is lower than on source system