Hi Soumaia,
I notice that you have postgis 2.1.
If you haven't updated the db settings then that is probably the issue. By
default arches assumes postgis 2.0.
Update your db settings to reference the proper postgis version.
DATABASES = {
'default': {
.......
'POSTGIS_TEMPLATE': 'template_postgis2.1',
}
}
Hope that helps,
Alexei
Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
On Sun, Oct 25, 2015 at 5:21 AM, Soumaia Al Ayyat <[email protected]>
wrote:
> the list of databases available on the server are:
> arches_my_hip_app
> postgres
> template0
> template1
> template_postgis
> template_postgis2.1
>
> We don't have the database template_postgis_20. Shall I check inside the
> template_postgis2.1
> database instead?
> Thanks for your help
> Soumaia Ahmed Al Ayyat, MSc
> PhD Candidate, Applied Sciences
> Senior Applications Development Manager
> University Academic Computing Technology
> The American University in Cairo
> Tel: (+2) 2615-3744
> Save a tree. Don't print this e-mail unless it's really necessary
>
> *Great minds discuss ideas; Average minds discuss events; Small minds
> discuss people. Eleanor Roosevelt*
On Thu, Oct 22, 2015 at 9:45 AM, Alexei Peters <[email protected]> wrote:
> 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.
