Hmm 2.3.3 is not the latest micro and very old. I didn't even think 2.3 got shipped with Debian 10.5 (thought that standardized on 2.5).
Are you sure that's what you are installing? If so can you at least upgrade that to 2.3.8 or 2.3.9 https://postgis.net/2019/03/11/postgis-patches/ From: postgis-users [mailto:[email protected]] On Behalf Of zakaria mouqcit Sent: Monday, March 25, 2019 10:19 AM To: PostGIS Users Discussion <[email protected]> Subject: Re: [postgis-users] Cache lookup failed for function 1 whileactivating PostGIS 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 <[email protected] <mailto:[email protected]> > wrote: <https://www.boxbe.com/overview> <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> This message is eligible for Automatic Cleanup! ( <mailto:[email protected]> [email protected]) <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> Add cleanup rule | <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> More info 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:[email protected]> mailto:[email protected]] On Behalf Of zakaria mouqcit Sent: Monday, March 25, 2019 4:49 AM To: <mailto:[email protected]> [email protected] 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 <http://www.sige.ma/> www.sige.ma Bureau <tel:+%20212%205%2037%2065%2091%2009> + 212 5 37 65 91 09 Mobile Maroc: <tel:+%20212%207%2071%2093%2057%2038> +212 6 32 60 78 55 32 Rue Ouled Ziane, Aviation, Rabat, Maroc <http://osm.org/go/b4oZYrEhv--?layers=N&m=> Plan OSM, <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> Gmaps <http://www.sig-environnement.com/wp-content/uploads/sites/77/2017/03/signature.png> 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 <mailto:[email protected]> [email protected] <https://lists.osgeo.org/mailman/listinfo/postgis-users> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
