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]> wrote: > > <https://www.boxbe.com/overview> This message is eligible for Automatic > Cleanup! ([email protected] <mailto:[email protected]>) 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:[email protected] > <mailto:[email protected]>] On Behalf Of zakaria mouqcit > Sent: Monday, March 25, 2019 4:49 AM > To: [email protected] <mailto:[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 > > 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 > [email protected] <mailto:[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
