How to connecting to a database in a cluster PostgreSQL?
-
Hello!
We have a postgresql cluster on Amazon Aurora
We set the configuration as: DATABASE_URL = jdbc: postgresql: // postgres_master: 5432, postgres_slave: 5432 / fusionauth
But we get an error at the start of the application:
PM ERROR com.inversoft.maintenance.db.JDBCURL - Could not parse jdbcString
Has anyone had a similar configuration? How to register a connection to a db cluster in fusionauth? -
This looks to be the correct syntax. https://jdbc.postgresql.org/documentation/94/connect.html
It may be that our JDBC string parsing needs to be updated to support this use case.
A more common use case is that FusionAuth is connecting to a managed service that is clustered and the failover capabilities are managed through a single JDBC host connection.
You could open a Github Issue to support this type of JDBC string.
-
@aivanov here's the link to create the issue: https://github.com/fusionauth/fusionauth-issues/issues
If you create this, please reference this forum post so the implementor has more context.
