Bug 1302066 - Instructions for Initializing remote PostgreSQL database result in wrong default locale
Summary: Instructions for Initializing remote PostgreSQL database result in wrong defa...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: Documentation
Version: 3.6.0
Hardware: All
OS: Linux
medium
high
Target Milestone: ovirt-3.6.5
: ---
Assignee: Byron Gravenorst
QA Contact: Megan Lewis
URL:
Whiteboard:
Depends On:
Blocks: RHEV_36_HTB
TreeView+ depends on / blocked
 
Reported: 2016-01-26 17:04 UTC by Julio Entrena Perez
Modified: 2019-10-10 11:02 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-04-26 12:07:02 UTC
oVirt Team: Docs
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 2138121 0 None None None 2016-01-26 17:06:40 UTC

Description Julio Entrena Perez 2016-01-26 17:04:04 UTC
Description of problem:
Under Appendix "D. Preparing a Remote PostgreSQL Database for Use with the Red Hat Enterprise Virtualization Manager" the following steps are provided on how to configure a remote PostgreSQL database:

  2. Initialize the PostgreSQL database, start the postgresql service, and ensure that this service starts on boot:
  # service postgresql initdb

Running "service postgresql initdb" on a system that has been configured with a non default locale results in the PostgreSQL cluster being created with that locale in the system.

As a result, RHEV-M installer will fail to use that database, see bug 1176457.
The documentation should suggest the following instead:

# su -l postgres -c "/usr/bin/initdb --locale=en_US.UTF8 --auth='ident' --pgdata=/var/lib/pgsql/data/"

Steps to Reproduce:
1. Boot the target system for the database with a non default locale:

# cat /etc/sysconfig/i18n
LANG="en_GB"

2. Run "service postgresql initdb"
3. Check the default locales in postgresql.conf:

# grep lc_ /var/lib/pgsql/data/postgresql.conf

Actual results:
lc_messages = 'en_GB'			# locale for system error message
lc_monetary = 'en_GB'			# locale for monetary formatting
lc_numeric = 'en_GB'			# locale for number formatting
lc_time = 'en_GB'				# locale for time formatting

And RHEV-M installer fails to use that PostgreSQL instance:

Failed to execute stage 'Environment customization': Engine requires lc_messages to be 'en_US.UTF-8'. Please fix lc_messages before you continue.

Expected results:
lc_messages = 'en_US.UTF8'			# locale for system error message
lc_monetary = 'en_US.UTF8'			# locale for monetary formatting
lc_numeric = 'en_US.UTF8'			# locale for number formatting
lc_time = 'en_US.UTF8'				# locale for time formatting

Additional info:
https://bugzilla.redhat.com/show_bug.cgi?id=1176457

Comment 1 Andrew Dahms 2016-03-28 23:31:58 UTC
Assigning to Byron for review.


Note You need to log in before you can comment on or make changes to this bug.