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.
