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 patlu...@gmail.com > 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 archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. 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 archesproject+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/6d44cf0c-d112-4ec4-b35f-1077f711cd94n%40googlegroups.com.
