Currently the recovery mode does not set the database, owner or secret keys documented in https://cloudnative-pg.io/documentation/1.24/recovery/#configure-the-application-database

This results in the operator defaulting to app:app. Which works fine if the source database name was app, but if you're using anything else the recovery does not do anything to grant access to the db that has been restored.

For now I've had to create a secret with the credentials from the source and have my application use those to work around this.