problem during postgres restore: max_connections = 100 is a lower setting than on the primary server, where its value was 350

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: problem during postgres restore: max_connections = 100 is a lower setting than on the primary server, where its value was 350
Date: 2026-03-02 10:27:52
Message-ID: CAA5-nLCdhiJW=zEBexw=NeDGirNGdKVWb-TEhRALM6+DCDRs6w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Patolla Bernd 2026-03-02 11:05:59 AW: problem during postgres restore: max_connections = 100 is a lower setting than on the primary server, where its value was 350
Previous Message Edward J. Sabol 2026-02-19 13:02:33 Re: Duplicate key value violates unique constraint "pg_type_typname_nsp_index" error