<div dir="ltr"><div>"2) run the following command from psql prompt while logging in with a DB admin (postgres) user "</div><div><br></div><div>Note on step 2: make sure you run</div><div>$ psql engine</div><div>and not just</div><div>$ psql</div><div><br></div><div>where engine = your engine db name, so that you connect to your engine db and not the server. The commands will run and look like they worked if you don't specify the database :)</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 16, 2018 at 8:52 AM, Eli Mesika <span dir="ltr"><<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-size:large">Hi Guys <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Please note that this patch was merged .</div><div class="gmail_default" style="font-size:large">You should follow all steps described in the original email <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">If you have any questions or problems, please contact me <br></div><span class="HOEnZb"><font color="#888888"><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Eli<br></div></font></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 12, 2017 at 12:11 PM, Eli Mesika <span dir="ltr"><<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-size:large">Hi</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">We had decided to drop our UUID generation function from DB in 4.2.1 and use the one provided by PG (using an extension)<br></div><div class="gmail_default" style="font-size:large">Please note that once this patch [1] is merged , you will have to do the following steps in your env in order that it will continue working.</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">1) make sure that the postgresql-contrib is installed on your machine (yum/dnf install postgresql-contrib -y)<br></div><div class="gmail_default" style="font-size:large">2) run the following command from psql prompt while logging in with a DB admin (postgres) user <br></div><div class="gmail_default" style="font-size:large"> a) DROP FUNCTION IF EXISTS uuid_generate_v1();</div><div class="gmail_default" style="font-size:large"> b) CREATE EXTENSION "uuid-ossp";'</div><div class="gmail_default" style="font-size:large">3) validate from psql prompt by :</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"># select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">You should get the following result <br></div><div class="gmail_default" style="font-size:large"><br>-[ RECORD 1 ]-----+-----------------------<wbr>-------------------------<br>name | uuid-ossp<br>default_version | 1.0<br>installed_version | 1.0<br>comment | generate universally unique identifiers (UUIDs)<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Please contact me for any questions or problems you encounter after this patch is merged to master.<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">[1] <a href="https://gerrit.ovirt.org/#/c/84832/" target="_blank">https://gerrit.ovirt.org/#/c/8<wbr>4832/</a></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Thanks <br></div><span class="m_6326053495263341640HOEnZb"><font color="#888888"><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Eli Mesika <br></div></font></span></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-weight:bold;margin:0px;padding:0px;font-size:14px;text-transform:uppercase"><span>GREG</span> <span>SHEREMETA</span></p><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:10px;margin:0px 0px 4px;text-transform:uppercase"><span>SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX</span><span style="color:rgb(170,170,170);margin:0px"></span></p><p style="font-family:overpass,sans-serif;margin:0px;font-size:10px;color:rgb(153,153,153)"><a href="https://www.redhat.com/" style="color:rgb(0,136,206);margin:0px" target="_blank">Red Hat NA<span><br><br></span></a></p><p style="font-family:overpass,sans-serif;margin:0px 0px 6px;font-size:10px;color:rgb(153,153,153)"><span style="margin:0px;padding:0px"><a href="mailto:gshereme@redhat.com" style="color:rgb(0,136,206);margin:0px" target="_blank">gshereme@redhat.com</a> </span> <span>IRC: <span>gshereme</span></span></p><table border="0" style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:medium"><tbody><tr><td width="100px"><a href="https://red.ht/sig" target="_blank"><img src="https://www.redhat.com/files/brand/email/sig-redhat.png" width="90" height="auto"></a></td></tr></tbody></table></div></div></div></div></div></div></div></div></div>
</div>