Warracker Files

🩹 Hotfix 1.0.1 – PostgreSQL Privilege Handling & Startup Stability

Version 1.0.1 delivers a targeted hotfix addressing a container startup issue affecting environments with restricted PostgreSQL privileges. This patch ensures the service can start reliably even without elevated database permissions , no feature or schema changes introduced.

⚠️ Note: This hotfix is only required for users deploying in restricted or limited-privilege PostgreSQL setups. Standard installations and environments with full DB privileges are unaffected.

🐘 PostgreSQL Startup Loop Fix

✅ Stable Startup in Restricted Environments

• Fixed a container startup loop caused by missing privileges in the PostgreSQL startup script.

• Wrapped the ALTER ROLE ... CREATEROLE command in a safe DO block with exception handling.

• If insufficient privileges are detected, a NOTICE is logged and startup continues normally.

• No functional or schema changes — only improved robustness during initialization.
• Modified file: backend/fix_permissions.sql

✅ Result: Reliable container startup even in environments without elevated database roles.

🧭 Upgrade Notes

• No migrations or configuration changes are needed.
• Only applies if your deployment runs with restricted PostgreSQL roles.
• If you previously experienced a container restart loop during startup, upgrading to this version will resolve the issue.

This 1.0.1 Hotfix improves startup reliability for deployments with restricted database permissions — ensuring smooth operation without requiring elevated PostgreSQL privileges.