Bug #37797: PostgreSQL 13 upgrade aborts when user locale doesn't match cluster locale - Installer - Foreman

Actions

Copy link

Bug #37797

closed

PostgreSQL 13 upgrade aborts when user locale doesn't match cluster locale

Added by Evgeni Golov 3 months ago. Updated 2 months ago.

Status:

Closed

Priority:

Normal

Assignee:

Evgeni Golov

Category:

Target version:

Foreman - 3.11.4

Difficulty:

Triaged:

Yes

Bugzilla link:

Pull request:

https://github.com/theforeman/foreman-installer/pull/971, https://github.com/theforeman/foreman-installer/pull/974, https://github.com/theforeman/foreman-installer/pull/979, https://github.com/theforeman/foreman-installer/pull/981

Fixed in Releases:

Foreman - 3.11.4, Foreman - 3.12.0, Foreman - 3.13.0

Found in Releases:

Foreman - 3.11.0, Foreman - 3.11.1, Foreman - 3.11.2, Foreman - 3.12.0

Red Hat JIRA:

SAT-27836

Description

# runuser -l postgres -c 'postgresql-setup --upgrade'
 * Upgrading database.
ERROR: pg_upgrade tool failed
ERROR: Upgrade failed.
 * See /var/lib/pgsql/upgrade_postgresql.log for details.

# cat /var/lib/pgsql/upgrade_postgresql.log | tail -100
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Checking database user is the install user                  ok
Checking database connection settings                       ok
Checking for prepared transactions                          ok
Checking for system-defined composite types in user tables  ok
Checking for reg* data types in user tables                 ok
Checking for contrib/isn with bigint-passing mismatch       ok
Creating dump of global objects                             ok
Creating dump of database schemas
  candlepin
  foreman
  postgres
  pulpcore
  template1
                                                            ok

lc_collate values for database "postgres" do not match:  old "en_US.UTF-8", new "en_IN.UTF-8" 
Failure, exiting

Related issues 1 (0 open — 1 closed)