complete logging port

[emrgnt-cmplxty]

[!IMPORTANT] Refactor logging system by renaming modules, introducing PostgresLoggingHandler, and updating references across the codebase.

• Logging Refactor:
  • Rename py/core/base/logging to py/core/base/logger and py/core/providers/logging to py/core/providers/logger.
  • Introduce PostgresLoggingHandler in database/logging.py for handling logging with PostgreSQL.
  • Update imports and references across multiple files to use the new logger module.
• New Features:
  • Add LoggingHandler abstract class and implement PostgresLoggingHandler.
  • Implement conversation and message management in PostgresLoggingHandler.
• Code Cleanup:
  • Remove deprecated RunType from logging/base.py.
  • Update conftest.py and test files to align with new logging structure.
• Miscellaneous:
  • Fix minor issues and improve code consistency across the codebase.

^{This description was created by for 4255dc69aa0e68f62d3dfae9a044bd783c5fcfaf. It will automatically update as commits are pushed.}