developer instructions for installing on ubuntu 24.04

[mtholder]

Feature or enhancement

I had to run sudo apt install postgis before bundle exec rake db:schema:load && bundle exec rake db:test:prepare in the instructions for 22.04 on https://docs.taxonworks.org/develop/Install/Development/Native/ubuntu_22_04.html#installation-instructions

Location

NA

Screenshot, napkin sketch of interface, or conceptual description

No response

Your role

No response

[mjy]

Thanks @mtholder . @LocoDelAssembly Does the sudo requirement make sense to you in this context?

[mtholder]

just for reference the error message I had been getting was:

/home/mholder/.rvm/gems/ruby-3.3.6/bin/ruby_executable_hooks:22:in `<main>'

Caused by:
PG::FeatureNotSupported: ERROR:  extension "postgis" is not available (PG::FeatureNotSupported)
DETAIL:  Could not open extension control file "/usr/share/postgresql/17/extension/postgis.control": No such file or 
directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.

It's probably just a case of some extension being default in postgres 15 but not 17 (17 is easier to install on Ubuntu 24.04, so that is what I was running)

[LocoDelAssembly]

apt-cache policy postgresql-17-postgis-3 <= Does it show installed?

[mtholder]

It does now, but I didn't run the command before I ran the apt install command I mentioned above.
But apart from that issue (and my env variable breaking postgres), I was able to get taxonworks running without much trouble.

[LocoDelAssembly]

Ah sorry, misread first post and assumed it was an ongoing problem. Well, certainly 15 does not have postgis by default, that is why postgresql-15-postgis-3 postgresql-15-postgis-3-scripts appears in apt install step.

I can confirm that 16 can be installed on Ubuntu 24.04 without having to use postgres apt source, and with your experience we now also know that 17 is the default version.

Not sure if Ubuntu 24.04 instructions should be default or if we should continue with version locking. In production and CI tests we are currently using 16.

[LocoDelAssembly]

Additional note: 17 was released AFTER Ubuntu 24.04. That would mean it would have auto-upgraded from 16 to 17 if you installed postgres and postgis without specific versions before September 2024?

https://endoflife.date/postgresql