Question

FATAL: role "doadmin" does not exist when connecting to PostgreSQL Managed DB via Spring Boot JPA

Posted May 5, 2020 1.4k views
PostgreSQLJavaDigitalOcean Managed PostgreSQL Database

No matter the user I try, I keep getting this error from Digital Ocean PostgreSQL managed database. It uses the correct URL and everything. So at this point I’m confused why my database would return this to my Spring Boot JPA application, when it is indeed sending the connection request with the information I defined in my configuration.

Using Spring Boot 2.2.6.RELEASE with spring-boot-starter-data-jpa.

Any help is appreciated. Thank you.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hello,

In this scenario, minimal example that triggers the error, any output or error messages that are emitted would be useful for further troubleshooting.

Hope that this helps.
Regards,
Priyanka