Ah, don't pin the version unless absolutely necessary. Just psycopg2-binary will be fine.

It should be ok now.
Added also the requirement of psycopg2 in the spec file

:+1:

That would be a -1 from me... I am guessing that weird psycopg2-binary requirement is not provided by the normal python2-psycopg2 package in Fedora, and thus this is yet another case where pip install'ing dependencies is incompatible with dnf install'ing them.

We should really, really just not do pip install, especially not for compiled stuff like psycopg2. Always just install the distribution package instead.

The comment is kind of irrelevant. The batch_alter_table is still preferable, even on Postgres, because it issues a single ALTER TABLE instead of three separate ones. So it's less work for the database.

Also there is no point in changing existing migrations because we have to assume that some/all deployments have already run them anyway.