[BACKEND] Add graceful shutdown and DB pool cleanup

[Trovic1]

Summary

Handle SIGINT/SIGTERM to close the HTTP server and the Postgres pool cleanly.

Scope

• backend only

Likely files

• src/app.js (or server entry)
• src/lib/db.js (close)

Acceptance criteria

• On signal, in-flight requests finish, then the pool closes
• Process exits without hanging connections
• No errors logged on normal shutdown

Verification

• Start the server, send SIGTERM, confirm clean exit

Labels: backend, enhancement, good first issue

---

[shehwarm]

Hi @Trovic1! I would love to tackle this Good First Issue. I can implement the graceful shutdown logic by attaching event listeners for SIGTERM and SIGINT in the main server entry point. I'll ensure server.close() is called to let in-flight requests finish, followed by properly closing the Postgres pool via lib/db.js before calling process.exit(0). Could you assign this to me?