Project

General

Profile

Bug #28928

checkpoint_segments in PostgreSQL config breaks upgrades

Added by Ewoud Kohl van Wijngaarden 12 months ago. Updated about 2 months ago.

Status:
Closed
Priority:
Normal
Category:
foreman-installer script
Target version:

Description

When running the upgrade the following shows up:

Feb  5 10:11:06 centos7-foreman-nightly sh: 2020-02-05 10:11:06.935 GMT [19621] LOG:  unrecognized configuration parameter "checkpoint_segments" in file "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf" line 760
Feb  5 10:11:06 centos7-foreman-nightly sh: 2020-02-05 10:11:06.935 GMT [19621] FATAL:  configuration file "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf" contains errors


Related issues

Related to Installer - Feature #28697: Upgrade to Postgresql 12Closed

Associated revisions

Revision e077f41b (diff)
Added by Ewoud Kohl van Wijngaarden 12 months ago

Refs #28928 - Remove checkpoint_segments from tuning

The checkpoint_segments setting no longer exists since PostgreSQL 10 and
the server fails to start up if it's present.

This is not a complete fix since it doesn't clean it up on existing
installations which can break upgrades.

Revision 33069447 (diff)
Added by Eric Helms 5 months ago

Fixes #28928: Error if checkpoint_segments detected

History

#1 Updated by The Foreman Bot 12 months ago

  • Assignee set to Ewoud Kohl van Wijngaarden
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-installer/pull/462 added

#2 Updated by Ewoud Kohl van Wijngaarden 12 months ago

#3 Updated by Eric Helms 5 months ago

  • Bugzilla link set to 1867311

#4 Updated by The Foreman Bot 5 months ago

  • Pull request https://github.com/theforeman/foreman-installer/pull/564 added

#5 Updated by The Foreman Bot 5 months ago

  • Fixed in Releases 2.3.0 added

#6 Updated by Eric Helms 5 months ago

  • Status changed from Ready For Testing to Closed

#7 Updated by Ewoud Kohl van Wijngaarden about 2 months ago

  • Triaged changed from No to Yes
  • Target version set to 2.3.0
  • Category set to foreman-installer script

#8 Updated by The Foreman Bot about 2 months ago

  • Pull request https://github.com/theforeman/foreman-installer/pull/621 added

Also available in: Atom PDF