Running migration from liquibase CLI fails due to search path not set correctly

[sl33k]

Hi!

I was trying to import the library manually with liquibase cli, since there is no docker available in my environment.
However it kept failing since the tables were not created under the altium schema by default, and instead in the default public schema.

It seems that the migrations/initial-db-scripts/Schema-for-components.sql migrations does not set the default search_path variable correctly. This can be also seen by querying the search_path from psql, which default still to public even after an initial migration run.

I've managed to resolve the issue by specificing altium as the search_path during pg_admin database creation,like so

Which makes the migration run succesfully, and the database is populated. Maybe this could be fixed in the migrations sql script?

For reference, I'm using Postgres 16.4, and Liquibase 4.29.1 on Windows.
The command used for liquibase is

.\liquibase.bat update --changelog-file=altium-library\migrations\db.changelog-master.xml

and my liquibase.properties file looks like this

url: jdbc:postgresql://localhost:5412/altium-components
username: postgres
password: postgres

Let me know if you need more info.

Cheers!

[ximtech]

Hi. Thank you for such detailed issue description. And yes, there is a such problem indeed, so to solve this you can use altium-migrator. Just fixed this and now before data migration provided schema (or altium by default) will be created (if not exist) and set. So I recommed to use this tool, take a look it takes minimum effort to run it using docker.

[sl33k]

Thanks and understood!

I think you should consider fixing it here, since as mentioned many people that might use your tool work in corporate networks which often don’t have access to virtualization tools like docker.

The altium-migrator is quite hard to run without it, while just installing liquibase and a local postgresql installation is possible without even admin rights (which are often also not available in corporate environments)

In any case, thank you for your work in the first place :) this is just some food for thought and maybe a good reference for anyone that has to work in a similarly restricted environment to me.

[ximtech]

In such situation the Liquibase CLI can be used instead. Install from here: https://docs.liquibase.com/pro/get-started-4-33/get-started-4-33-install
Then prepare DB and run update command from this example:

liquibase \
--search-path=path/to/changelog/files \
update \
--changelog-file=migrations/db.changelog-master.xml \
--url="jdbc:postgresql://localhost:5432:altium" \
--username=scott \
--password=tiger 

Set changelog and DB connection and all should work same as using migration tool