Reference access token no longer works after migrate IdentityServer from SQL server to postgreSQL server

[hubaozhang2017]

We moved our Duende IdentityServer data from SQL server to PostgreSQL server. All following tables are migrated:

1. api tables
2. client tables
3. Identity tables
4. persistedGrants table
5. Keys table

We have long lifetime reference tokens for third-party to access our api. It worked before data migration, but they stopped working after the data was migrated to PostgreSQL. All other functions work.

Please help.

[RolandGuijt]

Was the application itself moved to another physical location? It sounds like this is related to ASP.NET Core data protection. The data in the PersistedGrants table is protected using that. When no application name is configured the default is used where the key depends on the location of the application. Please see this doc for more information.

[hubaozhang2017]

@RolandGuijt
Our application didn't move location. I did find a table, DataProtectionKeys, in IdentityServer database that we didn't migrate to PostgreSQL database. I will try that.