Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 870056

Summary:	altering template1 encoding on createdb
Product:	[Retired] oVirt	Reporter:	Eli Mesika <emesika>
Component:	ovirt-engine-core	Assignee:	Ohad Basan <obasan>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	urgent
Version:	3.1 RC	CC:	acathrow, dyasny, eedri, iheim, juan.hernandez, obasan, ykaul
Target Milestone:	---
Target Release:	3.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	infra
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-02-15 06:47:15 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Eli Mesika 2012-10-25 13:42:02 UTC

Description of problem:
backup.sh and database scripts use template1 instead of template0

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1.Run create_db.sh or engine-db-install.sh
2.psql -U postgres -l 
3.look for the locale info
  
Actual results:
Database creation scripts are using template1 database, this may result in a locale conflict when we are using UTF8 and the template 1 is configured with ASCII.

Expected results:
All database creation and handling scripts should use template 0

Additional info:

Comment 1 Eli Mesika 2012-10-25 15:18:20 UTC

http://gerrit.ovirt.org/#/c/8823/

Comment 2 Eli Mesika 2012-10-25 15:19:52 UTC

*** Bug 869275 has been marked as a duplicate of this bug. ***

Comment 4 Eli Mesika 2012-10-28 08:25:30 UTC

fixed in commit: 9538658

Comment 5 Ohad Basan 2012-10-30 22:05:49 UTC

reopening the bug
looks like the problem when using template0 is that it is blocks connections so we won't be able to install postgres extensions.
we have no choice but to use template1 and change the encoding.

Comment 6 Ohad Basan 2012-10-30 22:10:23 UTC

Patch posted upstream

http://gerrit.ovirt.org/8936

Comment 7 Juan Hernández 2012-10-31 09:39:45 UTC

This is an alternative to the patch in comment #6. It makes it possible to use the template0 database as the extensions are created on the engine database once it is created:

http://gerrit.ovirt.org/8926

Please review and let me know what you think.

Comment 8 Ohad Basan 2012-11-01 15:29:53 UTC

An alternative patch to the patch in comment #7 is here:

http://gerrit.ovirt.org/#/c/8955/

Comment 9 Eli Mesika 2012-11-06 22:20:51 UTC

fixed in commit: 6891171

Comment 10 Itamar Heim 2013-01-16 16:08:31 UTC

3.2 beta built, moving to ON_QA status to allow testing