<div dir="ltr">Interesting - LC_ALL *was* originally blank - here's what I got from running that export command a few times (notice how the error messages change)<br><br>[root@spacewalk ~]# export LC_ALL=en-us.UTF8<br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8): No such file or directory<br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)<br>[root@spacewalk ~]# <br>[root@spacewalk ~]# export LC_ALL=en-us.UTF8<br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)<br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)<br>[root@spacewalk ~]# locale<br>locale: Cannot set LC_CTYPE to default locale: No such file or directory<br>locale: Cannot set LC_MESSAGES to default locale: No such file or directory<br>locale: Cannot set LC_ALL to default locale: No such file or directory <br>LANG=en_US.UTF-8 <br>LC_CTYPE="en-us.UTF8" <br>LC_NUMERIC="en-us.UTF8" <br>LC_TIME="en-us.UTF8" <br>LC_COLLATE="en-us.UTF8" <br>LC_MONETARY="en-us.UTF8" <br>LC_MESSAGES="en-us.UTF8" <br>LC_PAPER="en-us.UTF8" <br>LC_NAME="en-us.UTF8" <br>LC_ADDRESS="en-us.UTF8" <br>LC_TELEPHONE="en-us.UTF8" <br>LC_MEASUREMENT="en-us.UTF8" <br>LC_IDENTIFICATION="en-us.UTF8" <br>LC_ALL=en-us.UTF8 <br>[root@spacewalk ~]# export LC_ALL="en-us.UTF8" <br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8) <br>-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8) <br>[root@spacewalk ~]# locale<br>locale: Cannot set LC_CTYPE to default locale: No such file or directory <br>locale: Cannot set LC_MESSAGES to default locale: No such file or directory <br>locale: Cannot set LC_ALL to default locale: No such file or directory <br>LANG=en_US.UTF-8 <br>LC_CTYPE="en-us.UTF8"<br>LC_NUMERIC="en-us.UTF8"<br>LC_TIME="en-us.UTF8"<br>LC_COLLATE="en-us.UTF8"<br>LC_MONETARY="en-us.UTF8"<br>LC_MESSAGES="en-us.UTF8"<br>LC_PAPER="en-us.UTF8"<br>LC_NAME="en-us.UTF8"<br>LC_ADDRESS="en-us.UTF8"<br>LC_TELEPHONE="en-us.UTF8"<br>LC_MEASUREMENT="en-us.UTF8"<br>LC_IDENTIFICATION="en-us.UTF8"<br>LC_ALL=en-us.UTF8<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 2, 2018 at 6:12 AM, DiOrio, Max <span dir="ltr"><<a href="mailto:Max.DiOrio@ieeeglobalspec.com" target="_blank">Max.DiOrio@ieeeglobalspec.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12.0pt;line-height:1.3;color:#1f497d">
<div>Oh, you will need to uninstall and reinstall postgres for it to use the new locale
<br>
</div>
<div><br>
</div>
<div id="m_2624626311643339781signature-x" class="m_2624626311643339781signature_editor" style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12.0pt;color:#1f497d">
Sent from <a href="http://www.9folders.com/" style="text-decoration:none;color:#009bdf" target="_blank">
Nine</a><br>
</div>
</div><span class="">
<div id="m_2624626311643339781quoted_header" style="clear:both">
<hr style="border:none;height:1px;color:#e1e1e1;background-color:#e1e1e1">
<div style="border:none;padding:3.0pt 0cm 0cm 0cm"><span style="font-size:11.0pt;font-family:'Calibri','sans-serif'"><b>From:</b> Felipe Westfields <<a href="mailto:felipe.westfields@gmail.com" target="_blank">felipe.westfields@gmail.com</a>><br>
<b>Sent:</b> Thursday, February 1, 2018 10:55 PM<br>
<b>To:</b> <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a><br>
<b>Subject:</b> [Spacewalk-list] Database error when installing Space-Walk 2.7<br>
</span></div>
</div>
<br type="attribution">
</span><div><div class="h5"><div>
<div dir="ltr">
<div>I'm installing Spacewalk on CentOS 7, Spacewalk 2.7, following the instructions on this page:<br>
<br>
<a href="https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall" target="_blank">https://github.com/<wbr>spacewalkproject/spacewalk/<wbr>wiki/HowToInstall</a><br>
<br>
</div>
I install the the necessary repos, all seems well. I run this line:<br>
<br>
pacewalk-setup-postgresql create --db spacewalk --user dbadmin --password password --address *<br>
<div>
<div><br>
</div>
<div>And this is the error that comes up. I ran through the install instructions twice and gotten the same error both times.<br>
</div>
<div><br>
Redirecting to /bin/systemctl start postgresql.service<br>
createdb: database creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)<br>
HINT: Use the same encoding as in the template database, or use template0 as template.<br>
</div>
<div><br>
</div>
<div>What do I need to do to get past this error?</div>
<div><br>
</div>
<div>FW<br>
</div>
</div>
</div>
</div>
</div></div></div>
<br>______________________________<wbr>_________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" rel="noreferrer" target="_blank">https://www.redhat.com/<wbr>mailman/listinfo/spacewalk-<wbr>list</a><br></blockquote></div><br></div>