What database did you run the "SELECT PostGIS_full_version()" command from?
You should have a template_postgis_20 database and you should be able to successfully run the "SELECT PostGIS_full_version()" command from that. If that throws an error, then you need to run "CREATE EXTENSION postgis;" from the "template_postgis_20" database. Hope that helps Director of Web Development - Farallon Geographics, Inc. - 971.227.3173 On Thu, Oct 22, 2015 at 12:58 AM, Soumaia Al Ayyat <[email protected]> wrote: > We have checked the versions > > psycopg2-2.6.1 > psql (8.4.20, server 9.3.9) > > PostGIS is v. 2.1.8 but when we run SELECT PostGIS_full_version(); the > following error appears > ERROR: function postgis_full_version() does not exist > I checked its version using SELECT * from pg_available_extensions; > > Does that indicate something? > > -- > -- To post, send email to [email protected]. To unsubscribe, > send email to [email protected]. For more > information, visit https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
