Postgres Pro
Downloads
Home   >   mailing lists

Re: Is PG CE is FIPS Aware? - Mailing list pgsql-admin

From pramod kg
Subject Re: Is PG CE is FIPS Aware?
Date
Msg-id CAHkcXnzEuJ_UMZxAtdeVR2fVKZ=YgNwQecUX2bvVq9aMP5bK7g@mail.gmail.com
Whole thread Raw
In response to Re: Is PG CE is FIPS Aware?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Is PG CE is FIPS Aware?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Is PG CE is FIPS Aware?  (Imran Haider <ihaiderk@gmail.com>)
List pgsql-admin
Tree view
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@sss.pgh.pa.us> wrote:
pramod kg <pramod11287@gmail.com> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is PG CE is FIPS Aware?
Next
From: Imran Haider
Date:
Subject: Re: Is PG CE is FIPS Aware?