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.

PostGIS is a spatial extension used in GIS to allow a DataBase Management System manipulate geographical data.

If you have an idea about how to solve this issue, I would be pleased to learn from you.

  • How did you install PostgreSQL and postgis? What command did you execute to get this error? Was it just the CREATE EXTENSION, or something else? – jjanes Mar 25 at 23:46
  • Yes I did just execute CREATE EXTENSION postgis – zakaria mouqcit Mar 26 at 7:42
  • It works for me on a fresh ubuntu 18.04, installing postgis (and postgresql 10, which is a dependency of postgis) using "apt". I think you may have mixed and matched versions installed. – jjanes Mar 26 at 12:29
  • It reinstalled postgresql and postgis and it worked fine – zakaria mouqcit Mar 27 at 8:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.