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]] On Behalf Of zakaria mouqcit Sent: Monday, March 25, 2019 4:49 AM To: [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 + 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 <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 [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
