Convert psycopg2 errors to TransientRemoteException instead of RemoteException
On the wire, this is done by making the server return a 503 error instead of 500, which the RPC client generated by swh-core interprets to change the exception class.
Depends on swh-core!289 (closed).
Migrated from D8223 (view on Phabricator)