add precommit and fix postgres job

[klinch0]

Summary by CodeRabbit

Release Notes

• New Features

  • Introduced a pre-commit workflow to automate checks before code merges.
  • Added a section in the README for testing packages locally.

• Improvements

  • Enhanced PostgreSQL initialization script for better user and role management.
  • Updated documentation for Managed PostgreSQL Service with improved formatting and additional backup parameters.
  • Integrated pre-commit hooks for maintaining code quality in YAML and Markdown files.

• Bug Fixes

  • Adjusted formatting in various README files to ensure consistent presentation.

• Chores

  • Updated image reference to use the latest version in configuration files.
  • Updated versioning for various packages in the versions map.