Question: Possible to configure a separate DB for db-scheduler that is different from an app's primary DB?

[miguno]

Background: In our situation, we prefer having separate databases for an application vs. job scheduler. (And, similarly, we also prefer to run jobs on instances separate from app instances, which is suggested in #684.)

My question: Is this possible?

I haven't found any specific note in the db-scheduler docs that explain how to give it its own database.

I was thinking along the lines of something like this:

# Main app database
spring.datasource.url=jdbc:postgresql://localhost:5432/app_db
spring.datasource.username=app_user
spring.datasource.password=app_secret

# Separate scheduler database
scheduler.datasource.url=jdbc:postgresql://localhost:5432/scheduler_db
scheduler.datasource.username=scheduler_user
scheduler.datasource.password=scheduler_secret

[dpiat]

This configuration works for me:

@Bean
@Primary
@ConditionalOnProperty(name = ["db-scheduler.enabled"], havingValue = "true")
fun schedulerDataSourceCustomizer(
    @Qualifier("schedulerDs") schedulerDataSource: DataSource,
): DbSchedulerCustomizer = object : DbSchedulerCustomizer {
        override fun dataSource(): Optional<DataSource> = Optional.of(schedulerDataSource)
    }