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 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/CA%2BZLqy8hadcJgE6ehJaygDZiYL2cZuNoo_xbePQNq_G4MHFA0A%40mail.gmail.com.
