fix: make fips compliant by replacing md5 with sha256 in postgres and usedforsecurity=False for python md5

fix: make fips compliant by replacing md5 with sha256 in postgres and usedforsecurity=False for python md5 #49127