RE: Postgresql database encryption

2018-04-25 Thread Ahmed, Nawaz
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 mailto:ronljohnso...@gmail.com>> wrote: Also, Percona (a MySQL fork) 5.7. On 04/20/2018 07:31

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 wrote: > >> Hello Guys, >> >> Could some

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
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 wrote: > > Also, Percona (a MySQL fork) 5.7. > > On 04/20/2018 07:31 PM, Ozz Nixon wrote: > > PS. the following database servers do offer internal encrypt

Re: Postgresql database encryption

2018-04-20 Thread Ron
Also, Percona (a MySQL fork) 5.7. On 04/20/2018 07:31 PM, Ozz Nixon wrote: 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

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 th

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 dat

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 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 >>> For anyone to offer a proper solution, you need to say what purpose your >>>

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 for when the machine is shut down and I'm carry

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 like a lazy managemen

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 solution, you need to say wh

Re: Postgresql database encryption

2018-04-20 Thread Rob Sargent
On 04/20/2018 05:43 PM, Ron wrote: 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 For anyone to offer a proper solution, you need to say what purpose y

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 Someone really needs to explain that to me. My company-issued laptop has WDE, and that's great for when the

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 encrypted at rest? Does it >

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 and been in use i

Re: Postgresql database encryption

2018-04-20 Thread Vick Khera
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 and been in use in > production?. > For anyone to offer a proper solution, you need to say what p

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 been in use in >> pr

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, the

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 production implement