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

[zakaria mouqcit]

Hello,
Thanks for your response.
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. 
The version of postgis that I’m using is 2.3.3

> On Mar 25, 2019, at 3:00 PM, Regina Obe <lr at pcorp.us> wrote:
> 
>  <https://www.boxbe.com/overview>  This message is eligible for Automatic Cleanup! (lr at pcorp.us <mailto:lr at pcorp.us>) Add cleanup rule <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> | More info <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> 
> Some questions to troubleshoot:
>  
> 1)      I assume you did 
>  
> CREATE EXTENSION postgis; 
>  
> To enable it?
>  
> 2)      Can you create another extension and it works or you get same error.  E.g. does
> CREATE EXTENSION file_fdw;
>  
> Work?  If so it's not a PostGIS issue and something wrong with your system or install.
> That error often occurs if you had a server crash or something similar the corrupted system tables or indexes.
> You could try to reindex the pg_proc table.
>  
> 3)      What version of PostGIS did you install?
>  
> Hope that helps,
> Regina
>  
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org>] On Behalf Of zakaria mouqcit
> Sent: Monday, March 25, 2019 4:49 AM
> To: postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
> Subject: [postgis-users] Cache lookup failed for function 1 while activating PostGIS
>  
> 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.
> 
> I had this error : cache lookup failed for function 1
> 
> 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.
>  
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users <https://lists.osgeo.org/mailman/listinfo/postgis-users>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190325/db041352/attachment.html>