postgresql - How does liquibase handle execution from multiple users? -
we have postgresql database has consistently been updated using liquibase single user (a db owner role). ran update command user (a system owner) , registered if new db/schema, meaning liquibase tried execute changesets since beginning, not expected last few not in databasechangelog table. failed since changesets had been applied other user. however, raised question of how handle this. know why it's doing this? db-specific issue or issue @ liquibase level? or issue @ , should accept part of our business processes updates particular db need executed same user?
liquibase determines changesets have ran selecting databasechangelog table. guess happening new user has different default schema , looking in different place table.
depending on how run liquibase, there changelogschemaname or similar attribute control liquibase looks table.
Comments
Post a Comment