Support RDS running Postgres 15

[robotdan]

Support RDS running Postgres 15

Description

While FusionAuth does support Postgres version 15, it does not seem to work with AWS RDS.

When connecting to RDS running Postgres v15, a maintenance mode failed panel will be displayed, and the scheme is not created. This is likely caused some change to version 15 and how we create the schema in maintenance mode.

I tested with RDS engine version 15.2 and 15.3, but failed in the same way. Using version 14.8 works as expected.

Related

• https://github.com/FusionAuth/fusionauth-issues/issues/1944
• https://github.com/FusionAuth/fusionauth-issues/issues/2015
• https://github.com/FusionAuth/fusionauth-issues/issues/2264

Community guidelines

All issues filed in this repository must abide by the FusionAuth community guidelines.

[hoopty]

I'm seeing the same thing on Azure PG 15 servers. It has worked fine up through PG 14. We are using Kubernetes & the helm chart.

The log I see is:

2024-01-31 02:14:10.851 PM ERROR com.inversoft.maintenance.db.DatabaseSilentModeWorkflowTask - Unable to grant access to the configured user [fusionauth] perhaps the user already exists with other credentials or other database issues exist.

And the fix is to manually apply:

psql -a -d fusionauth -c "GRANT ALL ON SCHEMA public TO fusionauth;"

Worth mentioning that we are letting it create/apply the schema as we are setting these helm chart values:

  existingSecret: "fusionauth"
  user: "username"
  root:
    user: "rootusername"