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/bb384a28-120c-4c40-bb6d-8a01c97e8c66n%40googlegroups.com.
