Dear Alexei, I will do. I am investigating and learning and hope to unearth some more things to improve. I will get as far as I can over this week or so, and then read up about submitting tickets and do as you request.
Best wishes, Pat On Monday, September 21, 2020 at 6:21:25 PM UTC+1 Alexei Peters wrote: > Hi Pat, > Could you submit a ticket about this and in the ticket add the > suggested fixes and maybe also add a link to this thread. > Thanks, > Alexei > > Director of Web Development - Farallon Geographics, Inc. - 971.227.3173 > <(971)%20227-3173> > > > On Sat, Sep 19, 2020 at 4:23 AM [email protected] <[email protected]> > wrote: > >> Hello Alina, >> >> Thanks for the reply. That link did not help with my problem, but thanks >> for taking the time to post it. >> >> I believe that, despite those messages, which are, after all, just >> warnings, the postgis extension got installed so have carried on with the >> installation. >> >> Installing postgres gave me a rude message that was cured by moving the >> line >> wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc >> | sudo apt-key add - >> up one line to be before the line >> sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ >> $(lsb_release -sc)-pgdg main" >> >> I had a similar problem when the script tried to install couchdb, which >> was cured by moving the line >> wget --quiet -O - https://couchdb.apache.org/repo/bintray-pubkey.asc >> | sudo apt-key add - >> to before the line >> sudo add-apt-repository "deb https://apache.bintray.com/couchdb-deb >> $(lsb_release -sc) main" >> >> The dependencies now all seem to be in place, ready to install Arches >> itself. >> >> If those changes are legitimate (I am new to linux so am floundering in >> the dark a bit) perhaps somebody would be kind enough to update the >> ubuntu_unstall.sh script on github. >> >> Best wishes, >> Pat >> >> On Thursday, September 17, 2020 at 11:58:03 PM UTC+1 Alina Myklebust >> wrote: >> >>> Hi Pat, >>> >>> I don't have first hand experience with Arches v5 install, so I hope >>> someone else here on the forum can pop in and help with your question. I >>> do recall a similar install issue related to Postgres dependencies, so I >>> wanted to share the link to that post because it may help steer you in the >>> right direction: >>> https://groups.google.com/g/archesproject/c/eJNu_ROr5zk/m/S7jS7WcSAwAJ >>> >>> Please let us know if you've been able to get further along with your >>> install! >>> >>> Best, >>> >>> Alina >>> >>> On Tuesday, September 15, 2020 at 4:38:54 AM UTC-7 [email protected] >>> wrote: >>> >>>> Hi folks, >>>> >>>> I am setting up an Arches v5 installation in a Vbox Virtual Machine on >>>> my laptop using the install script for Ubuntu 18.04 using the install >>>> script install_ubuntu.sh fetched from github. >>>> >>>> I got as far as the line: >>>> sudo -u postgres psql -d template_postgis -c "CREATE EXTENSION postgis;" >>>> and got the following: >>>> >>>> ***STARTS*** >>>> WARNING: nonstandard use of escape in a string literal >>>> LINE 5: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO p... >>>> ^ >>>> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. >>>> QUERY: >>>> DECLARE >>>> pgver text; >>>> BEGIN >>>> SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO pgver; >>>> >>>> IF 120::text != ( SELECT CASE >>>> WHEN split_part(s,'.',1)::integer > 9 >>>> THEN split_part(s,'.',1) || '0' >>>> ELSE >>>> split_part(s,'.', 1) || split_part(s,'.', 2) >>>> END >>>> FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s ) >>>> THEN >>>> RAISE EXCEPTION 'PostGIS built for PostgreSQL % cannot be >>>> loaded in PostgreSQL %', >>>> 12.0, pgver; >>>> END IF; >>>> END; >>>> >>>> WARNING: nonstandard use of escape in a string literal >>>> LINE 13: FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s ) >>>> ^ >>>> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. >>>> QUERY: >>>> DECLARE >>>> pgver text; >>>> BEGIN >>>> SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') INTO pgver; >>>> >>>> IF 120::text != ( SELECT CASE >>>> WHEN split_part(s,'.',1)::integer > 9 >>>> THEN split_part(s,'.',1) || '0' >>>> ELSE >>>> split_part(s,'.', 1) || split_part(s,'.', 2) >>>> END >>>> FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s ) >>>> THEN >>>> RAISE EXCEPTION 'PostGIS built for PostgreSQL % cannot be >>>> loaded in PostgreSQL %', >>>> 12.0, pgver; >>>> END IF; >>>> END; >>>> >>>> WARNING: nonstandard use of escape in a string literal >>>> LINE 1: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') >>>> ^ >>>> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. >>>> QUERY: SELECT substring(version(), 'PostgreSQL ([0-9\.]+)') >>>> WARNING: nonstandard use of escape in a string literal >>>> LINE 7: FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s ) >>>> ^ >>>> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. >>>> QUERY: SELECT 120::text != ( SELECT CASE >>>> WHEN split_part(s,'.',1)::integer > 9 >>>> THEN split_part(s,'.',1) || '0' >>>> ELSE >>>> split_part(s,'.', 1) || split_part(s,'.', 2) >>>> END >>>> FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s ) >>>> CREATE EXTENSION >>>> >>>> ***ENDS*** >>>> >>>> Can anyone help with what is going on here? >>>> >>>> Ta, >>>> Pat >>>> >>>> -- >> -- 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/archesproject/6d44cf0c-d112-4ec4-b35f-1077f711cd94n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/archesproject/6d44cf0c-d112-4ec4-b35f-1077f711cd94n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/1a55a1aa-8d58-45d4-92c6-305c40427b86n%40googlegroups.com.
