Project

General

Profile

Actions

Bug #37797

closed

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

Added by Evgeni Golov 17 days ago. Updated 9 days ago.


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 open1 closed)

Related to Installer - Feature #37177: Upgrade to PostgreSQL 13 on EL8ClosedEvgeni GolovActions
Actions #1

Updated by Evgeni Golov 17 days ago

Actions #2

Updated by Evgeni Golov 17 days ago

  • Red Hat JIRA set to SAT-27836
Actions #3

Updated by The Foreman Bot 17 days ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-installer/pull/971 added
Actions #4

Updated by Evgeni Golov 17 days ago

  • Target version set to 3.11.3
  • Found in Releases 3.11.0, 3.11.1, 3.11.2, 3.12.0 added
Actions #5

Updated by The Foreman Bot 16 days ago

  • Fixed in Releases 3.13.0 added
Actions #6

Updated by Evgeni Golov 16 days ago

  • Status changed from Ready For Testing to Closed
Actions #7

Updated by Evgeni Golov 16 days ago

  • Status changed from Closed to Assigned
Actions #8

Updated by The Foreman Bot 16 days ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-installer/pull/974 added
Actions #9

Updated by Evgeni Golov 14 days ago

  • Status changed from Ready For Testing to Closed
Actions #10

Updated by The Foreman Bot 9 days ago

  • Pull request https://github.com/theforeman/foreman-installer/pull/979 added
Actions #11

Updated by The Foreman Bot 9 days ago

  • Fixed in Releases 3.12.0 added
Actions

Also available in: Atom PDF