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

[Regina Obe]

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:postgis-users-bounces at lists.osgeo.org] On Behalf Of zakaria mouqcit
Sent: Monday, March 25, 2019 10:19 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
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 <lr at pcorp.us <mailto:lr at pcorp.us> > 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:lr at pcorp.us> lr at pcorp.us)  <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: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:  <mailto:postgis-users at lists.osgeo.org> 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  <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:postgis-users at lists.osgeo.org> 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/e8bb77f4/attachment.html>