<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>You said other extensions did not work.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Can you give an example of one that didn't work?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Could be a mix of old stuff from the 9.x install. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>zakaria mouqcit<br><b>Sent:</b> Monday, March 25, 2019 11:09 AM<br><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: [postgis-users] Cache lookup failed for function 1 whileactivating PostGIS<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Actually, I’ve just started working on this server and I was told that they used to work with the 9.x version of postgresql then they decided to upgrade it to 10.5. <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>I don’t know how the upgrade was executed but I suspect it to be done in the wrong way so that postgis is not working anymore. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Most of databases on this server are not using Postgis extension except one and it’s working fine so you can manipulate geometric data as you like, but when you try to create a new db and activate postgis, it renders you the previous error. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>To overcome this, I made a duplicate to this database and work with it for my special needs. I believe that this issue must be solved so at this level I have no clue. Do I have to backup all the databases and uninstall completely Postgres and postgis as well and redo the installation or is there any quick and safe way to solve this issue? <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I’m pretty lost with this.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks for your assistance<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'><br>MOUQCIT Zakaria</span></b><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'> - Ingénieur géomaticien</span><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#222222'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><b><span style='font-size:9.0pt;font-family:"Arial",sans-serif;color:#0B5394'>Sig</span></b><b><span style='font-size:9.0pt;font-family:"Arial",sans-serif;color:#6AA84F'>e</span></b><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'> | </span><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#999999'>Mapping and Virtual reality</span><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'><a href="http://www.sige.ma/" target="_blank"><span style='color:#1155CC'>www.sige.ma</span></a><br>Bureau<b> </b><a href="tel:+%20212%205%2037%2065%2091%2009" target="_blank">+ 212 5 37 65 91 09</a><br>Mobile Maroc:<b> </b><a href="tel:+%20212%207%2071%2093%2057%2038" target="_blank">+212 6 32 60 78 55</a><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'>32 Rue Ouled Ziane, Aviation, Rabat, Maroc </span><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'><a href="http://osm.org/go/b4oZYrEhv--?layers=N&m=" target="_blank"><span style='color:black'>Plan OSM</span></a></span><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'>, </span><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'><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"><span style='color:black'>Gmaps</span></a><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.5pt;font-family:"Helvetica",sans-serif;color:black'><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"><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:black;background:white'>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;color:black;background:white'>contacter par téléphone.</span><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div></div><div><p class=MsoNormal><br><br><o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Mar 25, 2019, at 3:33 PM, zakaria mouqcit <<a href="mailto:zakaria.mouqcit@gmail.com">zakaria.mouqcit@gmail.com</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt;font-variant-caps: normal;orphans: auto;text-align:start;widows: auto;-webkit-text-size-adjust: auto;-webkit-text-stroke-width: 0px;word-spacing:0px'><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>CREATE EXTENSION file_fdw;</span><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></p></div></blockquote></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></body></html>