For what it's worth, I had trouble with the ubuntu_trusty_setup.sh script.
The first one I downloaded created a template called "template_postgis_21"
I had a hard time getting everything to work with this (even putting this
new template into the settings.py file). I was able to finally get
everything installed by re-running the ubuntu_trusty_setup script and
changing the template file back to template_postgis_20. When I resintalled
recently on a production server, I re-downloaded the setup script and this
time it was already correct with the _20 template. Not as familiar with
Postgres and Postgis as I need to be so not 100% sure where the issue was.
On Monday, October 26, 2015 at 12:12:15 PM UTC-5, Alexei Peters wrote:
>
> 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]
> <javascript:>> 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]
> <javascript:>> 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]
>> <javascript:>> 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] <javascript:>. To
>>> unsubscribe, send email to [email protected]
>>> <javascript:>. 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] <javascript:>.
>>> 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.
