Error: P1000: Authentication failed against database server

[ThierryHeinz]

Hi,

I have an issue regarding the use of Heroku postgresql database.
I received an email from Heroku speifying that the database needed maintenance.

It seems the credentials on Heroku are rotating ?

When I update my .env files, it does not work and authentication fails.
Is anyone knowing about this ?
How to set-up this in order to keep it working ?

Thanks in advance

[Pmejna]

Hi Thierry - I have experienced the same issue - I needed to create the two additional instances. The credentials of the old ones didn't work. This happened again later on with the new ones and I needed to switch back again to the other ones. Later on had no issues. So hope this stay that way.

[Skulek]

I've got a similar problem on a dev server with a number of Prisma instances and after some period of time, it crashes.

I've found a solution here: https://www.prisma.io/docs/support/help-articles/nextjs-prisma-client-dev-practices and after that, I don't have any problems.