RE: Postgresql database encryption

2018-04-25 Thread Ahmed, Nawaz
Cc: pgsql-general@lists.postgresql.org Subject: Re: Postgresql database encryption Thanks Ron, I was trying to find that -- memory had it down as "Persona" and I could not find that, haha. On Fri, Apr 20, 2018 at 8:39 PM Ron <ronljohnso...@gmail.com<mailto:ronljohnso...@gmail.com>> wrote:

Re: Postgresql database encryption

2018-04-22 Thread Vikas Sharma
Thanks a lot for the valuable information and apologies I didn't provide specify that the requirement is to encrypt data at rest and in transit. Regards Vikas On Fri, Apr 20, 2018, 21:56 Vick Khera wrote: > On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
PS. the following database servers do offer internal encryption on a page/block oriented read/write (for encrypted data at rest security requirements) PremierSQL TDE MariaDB 10.1.3+ *MySQL* 5.7.11+ Microsoft uses TDE Oracle AdvSec uses TDE DB2 v7.2 UDB MangoDB uses AES-256 PostgreSQL does - but

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
Well, actually since 2003, this has been a standard requirement from the Credit Card industry. And it does make sense in the field of "while at rest" the data still cannot be accessed. Requirement 1. No NPI data should be displayed without controls - e.g. reports, PDF, etc. Requirement 2. Same

Re: Postgresql database encryption

2018-04-20 Thread Ron
On 04/20/2018 10:24 AM, Vikas Sharma wrote: Hello Guys, Could someone throw light on the postgresql instance wide or database wide encryption please? Is this possible in postgresql and been in use in production?. What about encrypted backups? -- Angular momentum makes the world go 'round.

Re: Postgresql database encryption

2018-04-20 Thread Tim Cross
Ron writes: > On 04/20/2018 03:55 PM, Vick Khera wrote: >> On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma > > wrote: >> > > Someone really needs to explain that to me. My company-issued laptop has > WDE, and that's great

Re: Postgresql database encryption

2018-04-20 Thread Tim Cross
Vikas Sharma writes: > Hello Guys, > > Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. > > This is a requirement in our production implementation. > This sounds

Re: Postgresql database encryption

2018-04-20 Thread Stephen Frost
Greetings, * Ron (ronljohnso...@gmail.com) wrote: > On 04/20/2018 06:11 PM, Stephen Frost wrote: > >* Ron (ronljohnso...@gmail.com) wrote: > >>On 04/20/2018 03:55 PM, Vick Khera wrote: > >>>On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma >>>For anyone to offer a proper

Re: Postgresql database encryption

2018-04-20 Thread Ron
On 04/20/2018 06:11 PM, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: On 04/20/2018 03:55 PM, Vick Khera wrote: On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma

Re: Postgresql database encryption

2018-04-20 Thread Stephen Frost
Greetings, * Ron (ronljohnso...@gmail.com) wrote: > On 04/20/2018 03:55 PM, Vick Khera wrote: > >On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma >For anyone to offer a proper solution, you need to say what purpose your > >encryption will serve. Does the data need to be

Re: Postgresql database encryption

2018-04-20 Thread Ron
On 04/20/2018 03:55 PM, Vick Khera wrote: On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma > wrote: Hello Guys, Could someone throw light on the postgresql instance wide or database wide encryption please? Is this possible in postgresql

Re: Postgresql database encryption

2018-04-20 Thread James Keener
What requirements do you have? Would enabling full disk encryption suite your needs? On April 20, 2018 11:14:30 AM CDT, Tatsuo Ishii wrote: >> Could someone throw light on the postgresql instance wide or database >wide >> encryption please? Is this possible in postgresql and

Re: Postgresql database encryption

2018-04-20 Thread Tatsuo Ishii
> Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. As far as I know there's no open source solution for instance or database wide encryption. If commercial solutions are ok for you,

Re: Postgresql database encryption

2018-04-20 Thread Igor Korot
Hi, Vikas, On Fri, Apr 20, 2018 at 10:24 AM, Vikas Sharma wrote: > Hello Guys, > > Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. > > This is a requirement in our