1

I have a website with a Postgis database. I access to it with phpPgAdmin with postgreSQL 9.6. I want to export my database to keep a local backup.

I exported it like that:

Export from PhpPgAdmin

Then I want to import it in PgAdmin 4 v2.1, with PostgreSQL 10. In my SQL file I changed the owner name from observatoire-vienne to postgres. I created an empty spatial database. empty spatial database

I selected the query tool and ran the query with my sql file.

The error message is:

ERROR: ERREUR: la fonction public._st_dumppoints(public.geometry, integer[]) n'existe pas

Which means:

Error: the function public._st_dumppoints(public.geometry, integer[]) does not exist

I can’t find a similar problem in previous posts.

My question is: Is it due to Postgres versions? Does someone have the solution?

J.Delannoy
  • 345
  • 5
  • 15
  • 3
    PostGIS is not installed in the new database –  Jun 05 '18 at 07:08
  • It is, I added a picture – J.Delannoy Jun 05 '18 at 07:13
  • So what's below the `Extensions` node? –  Jun 05 '18 at 07:16
  • plpgsql and postgis – J.Delannoy Jun 05 '18 at 07:16
  • You are probably restoring a dump from an old PostGIS version into a database with a newer PostGIS version. Current PostGIS does not have a `_st_dumppoints` function. What is the context of the error message? Maybe you should use `postgis_restore.pl` to load the dump. – Laurenz Albe Jun 05 '18 at 07:24
  • I sent a message to my webhost asking for the postgis version. My postgis version in PgAdmin is 2.4.4. To use postgis_restore.pl, I need to use the pgsql shell ? – J.Delannoy Jun 05 '18 at 07:31
  • the version is 2.3. I check on postgis.net, in 2.4 it is written : _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0 when ST_DumpPoints got reimplemented in C. Then how can I get around this problem ? – J.Delannoy Jun 05 '18 at 07:38

0 Answers0