<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">Hello,</div><div class="">Thanks for your response.</div>Actually yes I did enable postgis with the same script but it didn’t work. After that I tried to enable another extension yet the same error is displaying. I assume that it is not a postgis issue but something related to postgresql itself. <div class="">The version of postgis that I’m using is 2.3.3<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Mar 25, 2019, at 3:00 PM, Regina Obe <<a href="mailto:lr@pcorp.us" class="">lr@pcorp.us</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; color: rgb(119, 119, 119); font-family: "Lucida Grande", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255); padding: 4px;" class=""><a href="https://www.boxbe.com/overview" style="color: rgb(94, 150, 234); text-decoration: none;" class=""><img alt="Boxbe" src="http://www.boxbe.com/images/logo_dark_small.png" width="64px" style="margin-left: 0px; margin-bottom: -1px; border: none;" class=""></a><span class="Apple-converted-space"> </span><img src="http://www.boxbe.com/stfopen?tc_serial=49043408994&tc_rand=1373571809&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001" class=""><span class="Apple-converted-space"> </span>This message is eligible for Automatic Cleanup! (<a href="mailto:lr@pcorp.us" style="color: purple; text-decoration: underline;" class="">lr@pcorp.us</a>)<span class="Apple-converted-space"> </span><a href="https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Fkey%3DOLKDlbl6UjlaHpKUufQ20ilA%252FK9kk8P%252Bfc5UjAs0vio%253D%26token%3Dr4gbVS3ur%252BRr3aPYD2KTvOZ8hAj1Gxi7Bmc%252FXmq%252B7eX0X26EWp3NSSum%252F%252FLfUg9%252BupsHsjaiokg42VWBWf7OjGaUdEv%252B7pO2C%252FsovHwhPbZEfuASaftMGXX94akVBzd%252F&tc_serial=49043408994&tc_rand=1373571809&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001" target="_blank" title="Add a new automatic cleanup rule" style="color: rgb(94, 150, 234); text-decoration: none;" class="">Add cleanup rule</a><span class="Apple-converted-space"> </span>|<span class="Apple-converted-space"> </span><a href="http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=49043408994&tc_rand=1373571809&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001" target="_blank" title="Get info on automatic cleanup" style="color: rgb(94, 150, 234); text-decoration: none;" class="">More info</a><span class="Apple-converted-space"> </span><br class=""></div><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Some questions to troubleshoot:<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif; text-indent: -0.25in;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><span class="">1)<span style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";" class=""> <span class="Apple-converted-space"> </span></span></span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">I assume you did<span class="Apple-converted-space"> </span><o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">CREATE EXTENSION postgis;<span class="Apple-converted-space"> </span><o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">To enable it?<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif; text-indent: -0.25in;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><span class="">2)<span style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";" class=""> <span class="Apple-converted-space"> </span></span></span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Can you create another extension and it works or you get same error. E.g. does<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">CREATE EXTENSION file_fdw;<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Work? If so it's not a PostGIS issue and something wrong with your system or install.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">That error often occurs if you had a server crash or something similar the corrupted system tables or indexes.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">You could try to reindex the pg_proc table.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman", serif; text-indent: -0.25in;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><span class="">3)<span style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";" class=""> <span class="Apple-converted-space"> </span></span></span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">What version of PostGIS did you install?<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Hope that helps,<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Regina<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="border-style: none none none solid; border-left-width: 1.5pt; border-left-color: blue; padding: 0in 0in 0in 4pt;" class=""><div class=""><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(225, 225, 225); padding: 3pt 0in 0in;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><b class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">From:</span></b><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span class="Apple-converted-space"> </span>postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" style="color: purple; text-decoration: underline;" class="">mailto:postgis-users-bounces@lists.osgeo.org</a>]<span class="Apple-converted-space"> </span><b class="">On Behalf Of<span class="Apple-converted-space"> </span></b>zakaria mouqcit<br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Monday, March 25, 2019 4:49 AM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span><a href="mailto:postgis-users@lists.osgeo.org" style="color: purple; text-decoration: underline;" class="">postgis-users@lists.osgeo.org</a><br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>[postgis-users] Cache lookup failed for function 1 while activating PostGIS<o:p class=""></o:p></span></div></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div><p class="MsoNormal" style="margin: 0in 0in 12pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: rgb(249, 248, 246); vertical-align: baseline; background-position: initial initial; background-repeat: initial initial;"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">I'm using PostgreSQL 10.5 on a remote server (Debian). I created a database inside then I attempted to enable PostGIS but it wasn't successful.<o:p class=""></o:p></span></p><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: rgb(249, 248, 246); vertical-align: baseline; font-variant-ligatures: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; box-sizing: inherit; orphans: 2; widows: 2;" class=""><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">I had this error : </span><code style="font-family: "Courier New";" class=""><span style="font-size: 10pt; font-family: Consolas; color: rgb(36, 39, 41); border: 1pt none windowtext; padding: 0in; background-color: rgb(239, 240, 241); background-position: initial initial; background-repeat: initial initial;" class="">cache lookup failed for function 1</span></code><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class=""><o:p class=""></o:p></span></div><div class=""><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><b class=""><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><br class="">MOUQCIT Zakaria</span></b><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""> - Ingénieur géomaticien</span><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif; color: rgb(34, 34, 34);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><b class=""><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(11, 83, 148);" class="">Sig</span></b><b class=""><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(106, 168, 79);" class="">e</span></b><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class=""> | </span><span style="font-size: 9pt; font-family: Helvetica, sans-serif; color: rgb(153, 153, 153);" class="">Mapping and Virtual reality</span><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class=""><o:p class=""> </o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><a href="http://www.sige.ma/" target="_blank" style="color: purple; text-decoration: underline;" class=""><span style="color: rgb(17, 85, 204);" class="">www.sige.ma</span></a><br class="">Bureau<b class=""> </b><a href="tel:+%20212%205%2037%2065%2091%2009" target="_blank" style="color: purple; text-decoration: underline;" class="">+ 212 5 37 65 91 09</a><br class="">Mobile Maroc:<b class=""> </b><a href="tel:+%20212%207%2071%2093%2057%2038" target="_blank" style="color: purple; text-decoration: underline;" class="">+212 6 32 60 78 55</a><o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class="">32 Rue Ouled Ziane, Aviation, Rabat, Maroc </span><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><a href="http://osm.org/go/b4oZYrEhv--?layers=N&m=" target="_blank" style="color: purple; text-decoration: underline;" class=""><span style="" class="">Plan OSM</span></a></span><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class="">, </span><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><a href="https://www.google.fr/maps/place/Sige,+Soci%C3%A9t%C3%A9+d'ing%C3%A9nierie+g%C3%A9omatique+et+environnementale/@33.992439,-6.8260357,17z/data=!3m1!4b1!4m5!3m4!1s0xda76b6f50462d31:0xbf5c0d2cc4e237bc!8m2!3d33.992439!4d-6.823847" target="_blank" style="color: purple; text-decoration: underline;" class=""><span style="" class="">Gmaps</span></a><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif; background-color: white;" class=""><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><img border="0" id="_x0000_i1025" src="http://www.sig-environnement.com/wp-content/uploads/sites/77/2017/03/signature.png" alt="http://www.sig-environnement.com/wp-content/uploads/sites/77/2017/03/signature.png" class=""><o:p class=""></o:p></span></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 8.5pt; font-family: Helvetica, sans-serif; background-color: white;" class="">Pour plus d'efficacité, nous consultons généralement nos e-mails à 11H et 16H. Pour les sujets urgents, merci de nous </span><span style="font-size: 7.5pt; font-family: Helvetica, sans-serif; background-color: white;" class="">contacter par téléphone.</span><span style="font-size: 9pt; font-family: Helvetica, sans-serif;" class=""><o:p class=""></o:p></span></div></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">postgis-users mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:postgis-users@lists.osgeo.org" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">postgis-users@lists.osgeo.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div></blockquote></div><br class=""></div></body></html>