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

[Regina Obe]

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] On Behalf Of zakaria mouqcit
Sent: Monday, March 25, 2019 4:49 AM
To: 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

 

 <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.

 

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