We are trying to install RStudio Connect in High Availability mode using ansible. One of the steps in HA is to migrate from SQLite to PostgreSQL in one of the server instances. When we run the migrate db command, we get this error:
Error Running Command: The database migration has failed; do not use the target database: Couldn’t determine schema version: missing data in store_metadata
Has anyone done something similar and seen this error? Any help would be highly appreciated.