Feature: bump psycopg to version 3

## Is your feature request related to a problem?

Now psycopg2 is not developed anymore and psycopg3 is the new standard. Bump psycopg to latest version.

## Additional context

[Django guide](https://docs.djangoproject.com/en/5.2/releases/4.2/#psycopg-3-support).
