Postgres alpine image introduces unique constraint index errors

[hubertdeng123]

Between self-hosted releases 24.4.2 and 24.5.1, we've noticed that users have been experiencing issues with duplicate environments/releases. This is likely due to a mistake on our side to introduce the alpine version of postgres here. This has since been reverted back to the debian image, but there is likely quite a few of you experiencing issues.

We are creating this issue to document user issues and potential solutions. From here on out, we will only be using the debian image of postgres. We have since deleted self-hosted versions 24.4.2, 24.5.0, and 24.5.1

https://github.com/getsentry/self-hosted/issues/3161 https://github.com/getsentry/self-hosted/issues/3166