1.0.1

[sassanix]

🩹 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.

---

This discussion was created from the release 1.0.1.