PostgreSQL Database Setup and Configuration

[Mkalbani]

Configure PostgreSQL database with TypeORM integration and establish connection management.

Tasks:
Set up PostgreSQL Docker container with initialization scripts
Configure TypeORM with PostgreSQL driver and connection pooling
Create database configuration service with environment-based settings
Set up migration system with TypeORM CLI integration
Configure database logging and query optimization settings
Implement connection health checks and retry mechanisms
Set up separate test database configuration
Create database backup and restore scripts
Configure database indexes strategy
Set up database monitoring and performance tracking

Acceptance Criteria:
Database connects successfully with proper error handling
Migrations can be run and rolled back
Connection pooling is configured and working
Test database is isolated from development database
Health checks return proper status

[OlufunbiIK]

Hi Maintainers, please can I take on this issue??

[Mkalbani]

@OlufunbiIK This is dependent on #1 . Apply for 1 too so that i'll assign both or wait for someone to.