MIME-Version: 1.0
From: Fabrice Chapuis <fabrice636861@gmail.com>
Date: Mon, 2 Mar 2026 11:27:52 +0100
Message-ID: 
 <CAA5-nLCdhiJW=zEBexw=NeDGirNGdKVWb-TEhRALM6+DCDRs6w@mail.gmail.com>
Subject: problem during postgres restore: max_connections = 100 is a lower
 setting than on the primary server, where its value was 350
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c5cbd3064c080a89"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA5-nLCdhiJW%3DzEBexw%3DNeDGirNGdKVWb-TEhRALM6%2BDCDRs6w%40mail.gmail.com>
Precedence: bulk

--000000000000c5cbd3064c080a89
Content-Type: text/plain; charset="UTF-8"

Hi,
I got this error from restoring a backup on a recovery machine.
I got error about the max_connections that I changed from 350 to 100.
in the control file the value is 350
/usr/pgsql-17/bin/pg_controldata -D /pgdata/pgsql/17/main/ | grep max_conn
max_connections setting:              350
That is the value registered from the primary. But the primary is not
intended to be connected during this restore.
primary_conninfo is desactivated.

Is there a trick to change decrease this value and start the instance.

Thanks for your help

Fabrice

2026-03-02 11:14:30.353 CET [1620147]: [3-1] user=,db=,client=,application=
LOG:  starting PostgreSQL 17.7 on x86_64-pc-linux-gnu, compiled by gcc
(GCC) 11.5.0 20240719 (Red Hat 11.5.0-11), 64-bit
2026-03-02 11:14:30.354 CET [1620147]: [4-1] user=,db=,client=,application=
LOG:  listening on IPv4 address "0.0.0.0", port 5432

2026-03-02 11:14:30.354 CET [1620147]: [5-1] user=,db=,client=,application=
LOG:  listening on IPv6 address "::", port 5432

2026-03-02 11:14:30.355 CET [1620147]: [6-1] user=,db=,client=,application=
LOG:  listening on Unix socket "/run/postgresql/.s.PGSQL.5432"

2026-03-02 11:14:30.357 CET [1620147]: [7-1] user=,db=,client=,application=
LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"

2026-03-02 11:14:30.362 CET [1620154]: [1-1] user=,db=,client=,application=
LOG:  database system was interrupted; last known up at 2026-02-25 18:00:01
CET
2026-03-02 11:14:30.362 CET [1620154]: [2-1] user=,db=,client=,application=
LOG:  creating missing WAL directory "pg_wal/summaries"

ERROR: The required file is not available: 0000000A.history
2026-03-02 11:14:31.415 CET [1620154]: [3-1] user=,db=,client=,application=
LOG:  starting backup recovery with redo LSN 3FB0/D9000028, checkpoint LSN
3FB0/D9010058, on timeline ID 9
2026-03-02 11:14:32.013 CET [1620154]: [4-1] user=,db=,client=,application=
LOG:  restored log file "00000009.history" from archive

2026-03-02 11:14:32.748 CET [1620154]: [5-1] user=,db=,client=,application=
LOG:  restored log file "0000000900003FB0000000D9" from archive

2026-03-02 11:14:32.749 CET [1620154]: [6-1] user=,db=,client=,application=
LOG:  starting point-in-time recovery to 2026-03-02 09:00:00+01

2026-03-02 11:14:32.760 CET [1620154]: [7-1] user=,db=,client=,application=
LOG:  recovered replication state of node 1 to 3FB0/D8D74100

2026-03-02 11:14:32.761 CET [1620154]: [8-1] user=,db=,client=,application=
LOG:  recovered replication state of node 2 to 3FB0/BB7C1518

2026-03-02 11:14:32.761 CET [1620154]: [9-1] user=,db=,client=,application=
LOG:  recovered replication state of node 3 to 3CBD/DDE26700

2026-03-02 11:14:32.761 CET [1620154]: [10-1]
user=,db=,client=,application= FATAL:  recovery aborted because of
insufficient parameter settings

2026-03-02 11:14:32.761 CET [1620154]: [11-1]
user=,db=,client=,application= DETAIL:  max_connections = 100 is a lower
setting than on the primary server, where its value was 350.

2026-03-02 11:14:32.761 CET [1620154]: [12-1]
user=,db=,client=,application= HINT:  You can restart the server after
making the necessary configuration changes.

2026-03-02 11:14:32.762 CET [1620147]: [8-1] user=,db=,client=,application=
LOG:  startup process (PID 1620154) exited with exit code 1

2026-03-02 11:14:32.763 CET [1620147]: [9-1] user=,db=,client=,application=
LOG:  aborting startup due to startup process failure

2026-03-02 11:14:32.763 CET [1620147]: [10-1]
user=,db=,client=,application= LOG:  database system is shut down

--000000000000c5cbd3064c080a89
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+SGksPGRpdj5JIGdvdCB0aGlzIGVycm9yIGZyb20gcmVzdG9yaW5nIGEg
YmFja3VwIG9uIGEgcmVjb3ZlcnkgbWFjaGluZS48YnI+SSBnb3QgZXJyb3IgYWJvdXQgdGhlIG1h
eF9jb25uZWN0aW9ucyB0aGF0IEkgY2hhbmdlZCBmcm9tIDM1MCB0byAxMDAuPGJyPmluIHRoZSBj
b250cm9sIGZpbGUgdGhlIHZhbHVlIGlzIDM1MDxicj4vdXNyL3Bnc3FsLTE3L2Jpbi9wZ19jb250
cm9sZGF0YSAtRCAvcGdkYXRhL3Bnc3FsLzE3L21haW4vIHwgZ3JlcCBtYXhfY29ubjxicj5tYXhf
Y29ubmVjdGlvbnMgc2V0dGluZzogwqAgwqAgwqAgwqAgwqAgwqAgwqAzNTA8L2Rpdj48ZGl2PlRo
YXQgaXMgdGhlIHZhbHVlIHJlZ2lzdGVyZWQgZnJvbSB0aGUgcHJpbWFyeS4gQnV0IHRoZSBwcmlt
YXJ5IGlzIG5vdCBpbnRlbmRlZCB0byBiZSBjb25uZWN0ZWQgZHVyaW5nIHRoaXMgcmVzdG9yZS48
YnI+cHJpbWFyeV9jb25uaW5mbyBpcyBkZXNhY3RpdmF0ZWQuPGJyPjxicj5JcyB0aGVyZSBhIHRy
aWNrIHRvIGNoYW5nZSBkZWNyZWFzZSB0aGlzIHZhbHVlIGFuZCBzdGFydCB0aGUgaW5zdGFuY2Uu
PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5UaGFua3MgZm9yIHlvdXIgaGVscDwvZGl2PjxkaXY+
PGJyPjwvZGl2PjxkaXY+RmFicmljZTxicj48YnI+MjAyNi0wMy0wMiAxMToxNDozMC4zNTMgQ0VU
IFsxNjIwMTQ3XTogWzMtMV0gdXNlcj0sZGI9LGNsaWVudD0sYXBwbGljYXRpb249IExPRzogwqBz
dGFydGluZyBQb3N0Z3JlU1FMIDE3Ljcgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQg
YnkgZ2NjIChHQ0MpIDExLjUuMCAyMDI0MDcxOSAoUmVkIEhhdCAxMS41LjAtMTEpLCA2NC1iaXQg
wqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+MjAyNi0wMy0wMiAxMToxNDozMC4zNTQgQ0VUIFsxNjIw
MTQ3XTogWzQtMV0gdXNlcj0sZGI9LGNsaWVudD0sYXBwbGljYXRpb249IExPRzogwqBsaXN0ZW5p
bmcgb24gSVB2NCBhZGRyZXNzICZxdW90OzAuMC4wLjAmcXVvdDssIHBvcnQgNTQzMiDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oDxicj4yMDI2LTAzLTAyIDExOjE0OjMwLjM1NCBDRVQgWzE2MjAxNDddOiBbNS0xXSB1c2VyPSxk
Yj0sY2xpZW50PSxhcHBsaWNhdGlvbj0gTE9HOiDCoGxpc3RlbmluZyBvbiBJUHY2IGFkZHJlc3Mg
JnF1b3Q7OjomcXVvdDssIHBvcnQgNTQzMiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCA8YnI+MjAyNi0wMy0wMiAx
MToxNDozMC4zNTUgQ0VUIFsxNjIwMTQ3XTogWzYtMV0gdXNlcj0sZGI9LGNsaWVudD0sYXBwbGlj
YXRpb249IExPRzogwqBsaXN0ZW5pbmcgb24gVW5peCBzb2NrZXQgJnF1b3Q7L3J1bi9wb3N0Z3Jl
c3FsLy5zLlBHU1FMLjU0MzImcXVvdDsgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqA8YnI+MjAyNi0wMy0wMiAxMToxNDozMC4zNTcgQ0VUIFsxNjIwMTQ3
XTogWzctMV0gdXNlcj0sZGI9LGNsaWVudD0sYXBwbGljYXRpb249IExPRzogwqBsaXN0ZW5pbmcg
b24gVW5peCBzb2NrZXQgJnF1b3Q7L3RtcC8ucy5QR1NRTC41NDMyJnF1b3Q7IMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDxi
cj4yMDI2LTAzLTAyIDExOjE0OjMwLjM2MiBDRVQgWzE2MjAxNTRdOiBbMS0xXSB1c2VyPSxkYj0s
Y2xpZW50PSxhcHBsaWNhdGlvbj0gTE9HOiDCoGRhdGFiYXNlIHN5c3RlbSB3YXMgaW50ZXJydXB0
ZWQ7IGxhc3Qga25vd24gdXAgYXQgMjAyNi0wMi0yNSAxODowMDowMSBDRVQgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgPGJyPjIwMjYtMDMtMDIgMTE6MTQ6MzAuMzYyIENFVCBbMTYyMDE1NF06IFsy
LTFdIHVzZXI9LGRiPSxjbGllbnQ9LGFwcGxpY2F0aW9uPSBMT0c6IMKgY3JlYXRpbmcgbWlzc2lu
ZyBXQUwgZGlyZWN0b3J5ICZxdW90O3BnX3dhbC9zdW1tYXJpZXMmcXVvdDsgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgPGJyPkVSUk9S
OiBUaGUgcmVxdWlyZWQgZmlsZSBpcyBub3QgYXZhaWxhYmxlOiAwMDAwMDAwQS5oaXN0b3J5PGJy
PjIwMjYtMDMtMDIgMTE6MTQ6MzEuNDE1IENFVCBbMTYyMDE1NF06IFszLTFdIHVzZXI9LGRiPSxj
bGllbnQ9LGFwcGxpY2F0aW9uPSBMT0c6IMKgc3RhcnRpbmcgYmFja3VwIHJlY292ZXJ5IHdpdGgg
cmVkbyBMU04gM0ZCMC9EOTAwMDAyOCwgY2hlY2twb2ludCBMU04gM0ZCMC9EOTAxMDA1OCwgb24g
dGltZWxpbmUgSUQgOSDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxi
cj4yMDI2LTAzLTAyIDExOjE0OjMyLjAxMyBDRVQgWzE2MjAxNTRdOiBbNC0xXSB1c2VyPSxkYj0s
Y2xpZW50PSxhcHBsaWNhdGlvbj0gTE9HOiDCoHJlc3RvcmVkIGxvZyBmaWxlICZxdW90OzAwMDAw
MDA5Lmhpc3RvcnkmcXVvdDsgZnJvbSBhcmNoaXZlIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDxicj4yMDI2LTAzLTAyIDExOjE0OjMy
Ljc0OCBDRVQgWzE2MjAxNTRdOiBbNS0xXSB1c2VyPSxkYj0sY2xpZW50PSxhcHBsaWNhdGlvbj0g
TE9HOiDCoHJlc3RvcmVkIGxvZyBmaWxlICZxdW90OzAwMDAwMDA5MDAwMDNGQjAwMDAwMDBEOSZx
dW90OyBmcm9tIGFyY2hpdmUgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgPGJyPjIwMjYtMDMtMDIgMTE6MTQ6MzIuNzQ5IENFVCBbMTYyMDE1NF06IFs2LTFd
IHVzZXI9LGRiPSxjbGllbnQ9LGFwcGxpY2F0aW9uPSBMT0c6IMKgc3RhcnRpbmcgcG9pbnQtaW4t
dGltZSByZWNvdmVyeSB0byAyMDI2LTAzLTAyIDA5OjAwOjAwKzAxIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDxicj4yMDI2LTAzLTAyIDExOjE0OjMyLjc2
MCBDRVQgWzE2MjAxNTRdOiBbNy0xXSB1c2VyPSxkYj0sY2xpZW50PSxhcHBsaWNhdGlvbj0gTE9H
OiDCoHJlY292ZXJlZCByZXBsaWNhdGlvbiBzdGF0ZSBvZiBub2RlIDEgdG8gM0ZCMC9EOEQ3NDEw
MCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxi
cj4yMDI2LTAzLTAyIDExOjE0OjMyLjc2MSBDRVQgWzE2MjAxNTRdOiBbOC0xXSB1c2VyPSxkYj0s
Y2xpZW50PSxhcHBsaWNhdGlvbj0gTE9HOiDCoHJlY292ZXJlZCByZXBsaWNhdGlvbiBzdGF0ZSBv
ZiBub2RlIDIgdG8gM0ZCMC9CQjdDMTUxOCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4yMDI2LTAzLTAyIDExOjE0OjMyLjc2MSBDRVQgWzE2
MjAxNTRdOiBbOS0xXSB1c2VyPSxkYj0sY2xpZW50PSxhcHBsaWNhdGlvbj0gTE9HOiDCoHJlY292
ZXJlZCByZXBsaWNhdGlvbiBzdGF0ZSBvZiBub2RlIDMgdG8gM0NCRC9EREUyNjcwMCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDxicj4yMDI2LTAz
LTAyIDExOjE0OjMyLjc2MSBDRVQgWzE2MjAxNTRdOiBbMTAtMV0gdXNlcj0sZGI9LGNsaWVudD0s
YXBwbGljYXRpb249IEZBVEFMOiDCoHJlY292ZXJ5IGFib3J0ZWQgYmVjYXVzZSBvZiBpbnN1ZmZp
Y2llbnQgcGFyYW1ldGVyIHNldHRpbmdzIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgPGJyPjIwMjYtMDMtMDIgMTE6MTQ6MzIuNzYxIENFVCBbMTYyMDE1NF06IFsxMS0x
XSB1c2VyPSxkYj0sY2xpZW50PSxhcHBsaWNhdGlvbj0gREVUQUlMOiDCoG1heF9jb25uZWN0aW9u
cyA9IDEwMCBpcyBhIGxvd2VyIHNldHRpbmcgdGhhbiBvbiB0aGUgcHJpbWFyeSBzZXJ2ZXIsIHdo
ZXJlIGl0cyB2YWx1ZSB3YXMgMzUwLiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCA8YnI+MjAyNi0wMy0wMiAxMToxNDozMi43NjEgQ0VUIFsxNjIwMTU0XTogWzEy
LTFdIHVzZXI9LGRiPSxjbGllbnQ9LGFwcGxpY2F0aW9uPSBISU5UOiDCoFlvdSBjYW4gcmVzdGFy
dCB0aGUgc2VydmVyIGFmdGVyIG1ha2luZyB0aGUgbmVjZXNzYXJ5IGNvbmZpZ3VyYXRpb24gY2hh
bmdlcy4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8YnI+MjAyNi0wMy0wMiAxMToxNDozMi43NjIgQ0VUIFsx
NjIwMTQ3XTogWzgtMV0gdXNlcj0sZGI9LGNsaWVudD0sYXBwbGljYXRpb249IExPRzogwqBzdGFy
dHVwIHByb2Nlc3MgKFBJRCAxNjIwMTU0KSBleGl0ZWQgd2l0aCBleGl0IGNvZGUgMSDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCA8YnI+MjAyNi0w
My0wMiAxMToxNDozMi43NjMgQ0VUIFsxNjIwMTQ3XTogWzktMV0gdXNlcj0sZGI9LGNsaWVudD0s
YXBwbGljYXRpb249IExPRzogwqBhYm9ydGluZyBzdGFydHVwIGR1ZSB0byBzdGFydHVwIHByb2Nl
c3MgZmFpbHVyZSDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCA8YnI+MjAyNi0wMy0wMiAxMToxNDozMi43NjMgQ0VUIFsxNjIwMTQ3
XTogWzEwLTFdIHVzZXI9LGRiPSxjbGllbnQ9LGFwcGxpY2F0aW9uPSBMT0c6IMKgZGF0YWJhc2Ug
c3lzdGVtIGlzIHNodXQgZG93bsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPC9kaXY+PC9kaXY+DQo=
--000000000000c5cbd3064c080a89--