Thank you for the guidance, found and ran only the applicable schema update parts successfully, and now I can use and see my DB with latest BQ. Tons of gratitude and thanks!
What I did is I opened update_schema sql file of latest BQ from the SQL folder, but schema updates refer to version numbers (eg. 3.4, etc.) in the file, while BQ is versioned by dates, so do not know which version number equals to BQ version 20190315 in the file, to be able to know which sections I shall run for the existing DB... When I ran all queries, some of them returned with error, and eventually some data was lost in between (eg. photos of covers got missed). When I connected to existing DB...
Hi, thank you for quick reply, and apologies for me being silly... The instance runs on the built in PostgreSQL server (9.3.25, cannot be changed) of my Synology NAS, for such scenario I have not seen schema upgrade option in BQ Options menu. Any cure for such scenario?
Matching schema upgrade version numbers to version dates