Hi,
Firstly, you always need to deploy the upgrade script and then start up when upgrading from 2.29 or earlier - so always step by step. If you get a two-step error during startup of 2.30, look here:
But from 2.31 onwards, you no longer have to go step by step. Flyway - assuming it is correctly configured - will implement all data model changes and value updates in a step-wise fashion.
You will probably also have to set e.g. some parameters in e.g. postgresql.conf, server.xml etc - see implementer manual for details.
Secondly, @AhmadQais, your system have IMHO too little ram and far too many max_locks_per_connection. I use 96 for the latter, 12G for the initial pool and 16GB for the max pool and 4GB thread stack. That’s on a 32GB laptop.
I’ve had some language issues, so add to your java options:
-Dfile.encoding=UTF8
Otherwise windows might suddenly treat UTF8 as a windows code page (cannot remember the number).
Best regards
Calle