ERROR: could not compute MD5 hash: disabled for FIPS

[salimane]

While trying to clone a db from AWS to Azure
I am getting the following error

STEP 9: reset sequences values
2024-09-25 16:53:47.895 47 INFO   sequences.c:290           Set sequences values on the target database
2024-09-25 16:53:54.224 44 ERROR  pgsql.c:2285              [TARGET 457661] ERROR:  could not compute MD5 hash: disabled for FIPS
2024-09-25 16:53:54.228 44 ERROR  pgsql.c:2285              [TARGET 457661] ERROR:  could not compute MD5 hash: disabled for FIPS
2024-09-25 16:53:54.228 44 ERROR  pgsql.c:2296              [TARGET 457661] SQL query: CREATE UNIQUE INDEX ......;
2024-09-25 16:53:54.228 44 ERROR  pgsql.c:2304              [TARGET 457661] SQL params:
2024-09-25 16:53:54.228 44 ERROR  indexes.c:301             Failed to create index with oid 58042, see above for details
2024-09-25 16:53:54.233 44 ERROR  indexes.c:341             CREATE INDEX worker 44 encountered 1 errors, see above for details
2024-09-25 16:53:54.329 32 ERROR  copydb.c:767              Sub-process 44 exited with code 12
2024-09-25 16:53:59.235 32 ERROR  indexes.c:123             Some INDEX worker process(es) have exited with error, see above for details
2024-09-25 16:53:59.235 32 ERROR  indexes.c:59              Failed to create indexes, see above for details
2024-09-25 16:53:59.306 23 ERROR  copydb.c:767              Sub-process 32 exited with code 12
2024-09-25 16:53:59.406 23 ERROR  table-data.c:207          Some sub-processes have exited with error status, see above for details
2024-09-25 16:53:59.406 23 ERROR  table-data.c:214          Errors detected, see above for details
2024-09-25 16:53:59.406 23 FATAL  table-data.c:71           Failed to COPY the data, see above for details
2024-09-25 16:53:59.406 23 ERROR  cli_clone_follow.c:504    Failed to clone source database, see above for details
2024-09-25 16:53:59.431 1 ERROR  cli_clone_follow.c:764    clone process 23 has terminated [6]

@dimitri any help is welcomed

[juanboterotech]

Dealing with the same issue, trying to migrate to a Postgres Flexible server in Azure; looking for information i got that FIPS is a set of Standards for information processing; Azure is FIPS compliant (see: https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-security#at-rest); so md5 functions are disabled by default on Azure flexible servers.
In my case i need to enable MD5 because the ammount of calls of that function, maybe you can get rid off the calls of them,

[sEpt0r]

Got same errors with Azure Postgres Flexible servers.
I updated the SQL template to use SHA256 instead of MD5 and it works for me.

Not sure if opening a PR is a good idea because SHA256 is only available in Postgres >= 11 and will break backwards compatibility, but it can be used as a quick solution to do a migration.

Fix: sEpt0r#1
Docker image: ghcr.io/sept0r/pgcopydb:latest