Re: Is PG CE is FIPS Aware?

[pramod kg <pramod11287@xxxxxxxxx>]

Thanks Tom for your quick response.

I executed query. Got output.

postgres=# SELECT md5('foo');
               md5
----------------------------------
 acbd18db4cc2f85cedef654fccc4a4d8
(1 row)

Do we have official documentation or any blogs which guides us to make PG installation FIPS Compliant? Also, is it achievable via RPM based installation? Or do we need to compile libraries? 

On Thu, Jan 27, 2022 at 11:02 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

pramod kg <pramod11287@xxxxxxxxx> writes:
> How to determine whether PG installed in a server is FIPS aware or not(FIPS
> 140-2 compliant)? We are doing RPM based installation.

If "SELECT md5('foo')" fails, then FIPS restrictions are active.

                        regards, tom lane