[postgis-users] Cache lookup failed for function 1 whileactivating PostGIS

[zakaria mouqcit]

Hello,

I created the extension you gave me previously to test with create extension file_fdw; on a new database but no result. Via Pgadmin you can add manually extension by clicking right on the database then choose extension and create the one you want from a list. Each one I tried rendered me the same issue. 

> On Mar 25, 2019, at 4:08 PM, zakaria mouqcit <zakaria.mouqcit at gmail.com> wrote:
> 
> 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. 
> 
> 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. 
> 
> 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. 
> 
> 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? 
> 
> I’m pretty lost with this.
> 
> Thanks for your assistance
> 
> 
> MOUQCIT Zakaria - Ingénieur géomaticien
> Sige | Mapping and Virtual reality
> 
> www.sige.ma <http://www.sige.ma/>
> Bureau + 212 5 37 65 91 09 <tel:+%20212%205%2037%2065%2091%2009>
> Mobile Maroc: +212 6 32 60 78 55 <tel:+%20212%207%2071%2093%2057%2038>
> 32 Rue Ouled Ziane, Aviation, Rabat, Maroc Plan OSM <http://osm.org/go/b4oZYrEhv--?layers=N&m=>, Gmaps <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>
> Pour plus d'efficacité, nous consultons généralement nos e-mails à 11H et 16H. Pour les sujets urgents, merci de nous contacter par téléphone.
> 
>> On Mar 25, 2019, at 3:33 PM, zakaria mouqcit <zakaria.mouqcit at gmail.com <mailto:zakaria.mouqcit at gmail.com>> wrote:
>> 
>>> CREATE EXTENSION file_fdw;
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190325/4d7cfe45/attachment.html>