| 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
| 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 |