docs(dev): update setup guide for PostgreSQL-based local stack
- Updated `.env.example` to default to PostgreSQL, Redis, MinIO, and OpenSearch for local development.
- Enhanced local development guide with updated commands and dependency configurations.
- Detailed fallback to SQLite and lightweight configurations for simpler setups.
- Clarified Docker Compose usage for fully containerized local stacks.
