pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
14+ messages / 9 participants
[nested] [flat]

* Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 04:48  Chetan Kosanam <chetan.kosanam@tcs.com>
  0 siblings, 2 replies; 14+ messages in thread

From: Chetan Kosanam @ 2022-12-21 04:48 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; MUKESH KUMAR <mukesh.kumar14@tcs.com>; MOHINI JOSHI <mohini.ujoshi@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>

TCS Confidential

Hi Support@ PostgreSQL Team,

Greetings !!

 We are operating within one of the AWS business units of TCS. Our team is working on the Database migration from Oracle(on Amazon EC2) to PostgreSQL. The reason for this e-mailer is to seek your earnest required support from you on the Implementation of Wallet configuration ( which is in Oracle) by its equivalent configuration on the PostgreSQL side.

Thanks & Regards,
Chetan Kosanam
TCS,  HYDERABAD
Contact : 9502753544
Mailto : chetan.kosanam@tcs.com



TCS Confidential
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 17:41  Alicja Kucharczyk <zaledwie10minut@gmail.com>
  parent: Chetan Kosanam <chetan.kosanam@tcs.com>
  1 sibling, 1 reply; 14+ messages in thread

From: Alicja Kucharczyk @ 2022-12-21 17:41 UTC (permalink / raw)
  To: Chetan Kosanam <chetan.kosanam@tcs.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; MUKESH KUMAR <mukesh.kumar14@tcs.com>; MOHINI JOSHI <mohini.ujoshi@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>

śr., 21 gru 2022 o 18:33 Chetan Kosanam <chetan.kosanam@tcs.com> napisał(a):

> TCS Confidential
>
> Hi *Support*@ *PostgreSQL* Team,
>
>
>
> *Greetings* *!!*
>
>
>
>  We are operating within one of the *AWS business* units of *TCS*. Our
> team is working on the *Database migration from Oracle(on Amazon EC2) to
> PostgreSQL*. The reason for this e-mailer is to seek your earnest
> required support from you on the *Implementation of Wallet configuration*
> ( which is in Oracle) by its *equivalent* configuration on the
> *PostgreSQL* side.
>
>
>
> Thanks & Regards,
>
> Chetan Kosanam
>
> TCS,  HYDERABAD
>
> Contact : 9502753544
>
> Mailto : chetan.kosanam@tcs.com
>

It seems you are looking for consultant:
https://www.postgresql.org/support/professional_support/

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 19:21  Sandeep Saxena <sandeep.lko@gmail.com>
  parent: Alicja Kucharczyk <zaledwie10minut@gmail.com>
  0 siblings, 0 replies; 14+ messages in thread

From: Sandeep Saxena @ 2022-12-21 19:21 UTC (permalink / raw)
  To: Alicja Kucharczyk <zaledwie10minut@gmail.com>; +Cc: Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; MUKESH KUMAR <mukesh.kumar14@tcs.com>; MOHINI JOSHI <mohini.ujoshi@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>

I could find old post on postgres community ,

https://www.postgresql.org/message-id/20180625142233.GD20745%40momjian.us

On Thu, May 17, 2018 at 07:07:00AM +0000, ROS Didier wrote:
> Hi
>
> Regarding the encryption of data by pgcrypto, I would like to
> know the recommendations for the management of the key.
>
> Is it possible to store it off the PostgreSQL server?
>
> Is there the equivalent of Oracle "wallet" ?

Late reply, but the last presentation on this page shows how to use
cryptographic hardware with Postgres:

https://momjian.us/main/presentations/security.html

You could modify that to use a key management system (KMS).

-- 
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

On Wed, Dec 21, 2022 at 12:42 PM Alicja Kucharczyk <
zaledwie10minut@gmail.com> wrote:

> śr., 21 gru 2022 o 18:33 Chetan Kosanam <chetan.kosanam@tcs.com>
> napisał(a):
>
>> TCS Confidential
>>
>> Hi *Support*@ *PostgreSQL* Team,
>>
>>
>>
>> *Greetings* *!!*
>>
>>
>>
>>  We are operating within one of the *AWS business* units of *TCS*. Our
>> team is working on the *Database migration from Oracle(on Amazon EC2) to
>> PostgreSQL*. The reason for this e-mailer is to seek your earnest
>> required support from you on the *Implementation of Wallet configuration*
>> ( which is in Oracle) by its *equivalent* configuration on the
>> *PostgreSQL* side.
>>
>>
>>
>> Thanks & Regards,
>>
>> Chetan Kosanam
>>
>> TCS,  HYDERABAD
>>
>> Contact : 9502753544
>>
>> Mailto : chetan.kosanam@tcs.com
>>
>
> It seems you are looking for consultant:
> https://www.postgresql.org/support/professional_support/
>
>

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 21:34  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: Chetan Kosanam <chetan.kosanam@tcs.com>
  1 sibling, 1 reply; 14+ messages in thread

From: Laurenz Albe @ 2022-12-21 21:34 UTC (permalink / raw)
  To: Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; MUKESH KUMAR <mukesh.kumar14@tcs.com>; MOHINI JOSHI <mohini.ujoshi@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>

On Wed, 2022-12-21 at 04:48 +0000, Chetan Kosanam wrote:
> We are operating within one of the AWS business units ofTCS. Our team is working on
> the Database migration from Oracle(on Amazon EC2) to PostgreSQL. The reason for this
> e-mailer is to seek your earnest required support from you on theImplementation of
> Wallet configuration ( which is in Oracle) by its equivalent configuration on the
> PostgreSQL side.

There is no exact equivalent, but there is something similar and much better: you can
authenticate the client with SSL client certificates:
https://www.postgresql.org/docs/current/auth-cert.html

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com





^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 21:39  Rainer Duffner <rainer@ultra-secure.de>
  parent: Laurenz Albe <laurenz.albe@cybertec.at>
  0 siblings, 1 reply; 14+ messages in thread

From: Rainer Duffner @ 2022-12-21 21:39 UTC (permalink / raw)
  To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>



> Am 21.12.2022 um 22:34 schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
> 
> There is no exact equivalent, but there is something similar and much better: you can
> authenticate the client with SSL client certificates:
> https://www.postgresql.org/docs/current/auth-cert.html <https://www.postgresql.org/docs/current/auth-cert.html;

Isn’t the wallet the part where the encryption keys are stored?

Indeed, one of the few remaining features that only Oracle (and of course other commercial RDMSs) has seems to be full HSM support for TDE.


Rainer=

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 22:25  Benedict Holland <benedict.m.holland@gmail.com>
  parent: Rainer Duffner <rainer@ultra-secure.de>
  0 siblings, 2 replies; 14+ messages in thread

From: Benedict Holland @ 2022-12-21 22:25 UTC (permalink / raw)
  To: Rainer Duffner <rainer@ultra-secure.de>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general <pgsql-general@lists.postgresql.org>

What would you be missing? You can encrypt databases. You can encrypt the
s3 buckets using kms. You can govern access via ssh Auth. When you do
backups, you can encrypt the tar.gz files or whatever format and store it
on s3. Same with the wal files. The fact that oracle charges for this is a
joke. Of course, you would need to ensure compliance with your opsec teams
and stuck with best security practices but it seems top to bottom
encryption is unrelated or tangentially related to the databases.

Also, if you lose the encryption keys for your backups then bad things
happen. I doubt what I did was production viable but I limited database
access to a handful of users, encrypted the disks, left the Wal files
unencrypted but mounted with read access for a single user, compressed full
backups with encryption and a password, generated sah keys for anyone who
needed service accounts to access the systems, enforced database ownership
permissions, and and gave server access to a tiny team with 2fa. The way 8
figured it, if someone somehow rooted the box we were screwed anyway.

For an internal database, this seemed sufficient. For an external database,
I would highly recommend paid consulting security firms or hire people who
know to build an externally facing platform.

Thanks
Ben

On Wed, Dec 21, 2022, 4:39 PM Rainer Duffner <rainer@ultra-secure.de> wrote:

>
>
> Am 21.12.2022 um 22:34 schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
>
> There is no exact equivalent, but there is something similar and much
> better: you can
> authenticate the client with SSL client certificates:
> https://www.postgresql.org/docs/current/auth-cert.html
>
>
>
> Isn’t the wallet the part where the encryption keys are stored?
>
> Indeed, one of the few remaining features that only Oracle (and of course
> other commercial RDMSs) has seems to be full HSM support for TDE.
>
>
> Rainer
>

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 23:10  Ron <ronljohnsonjr@gmail.com>
  parent: Benedict Holland <benedict.m.holland@gmail.com>
  1 sibling, 0 replies; 14+ messages in thread

From: Ron @ 2022-12-21 23:10 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

If a hacker gets in with root access, they can copy /your/ (and my) 
Postgresql database files (or, more easily, the backup files) off site, 
restore them, and then have access to your database.  Not so much 
TDE-encrypted databases, since the backups are encrypted too and you need 
the key to decrypt them,

As for the Bad Things which happen if you lose the keys... well, *don't lose 
the keys!!*

On 12/21/22 16:25, Benedict Holland wrote:
> What would you be missing? You can encrypt databases. You can encrypt the 
> s3 buckets using kms. You can govern access via ssh Auth. When you do 
> backups, you can encrypt the tar.gz files or whatever format and store it 
> on s3. Same with the wal files. The fact that oracle charges for this is a 
> joke. Of course, you would need to ensure compliance with your opsec teams 
> and stuck with best security practices but it seems top to bottom 
> encryption is unrelated or tangentially related to the databases.
>
> Also, if you lose the encryption keys for your backups then bad things 
> happen. I doubt what I did was production viable but I limited database 
> access to a handful of users, encrypted the disks, left the Wal files 
> unencrypted but mounted with read access for a single user, compressed 
> full backups with encryption and a password, generated sah keys for anyone 
> who needed service accounts to access the systems, enforced database 
> ownership permissions, and and gave server access to a tiny team with 2fa. 
> The way 8 figured it, if someone somehow rooted the box we were screwed 
> anyway.
>
> For an internal database, this seemed sufficient. For an external 
> database, I would highly recommend paid consulting security firms or hire 
> people who know to build an externally facing platform.
>
> Thanks
> Ben
>
> On Wed, Dec 21, 2022, 4:39 PM Rainer Duffner <rainer@ultra-secure.de> wrote:
>
>
>
>>     Am 21.12.2022 um 22:34 schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
>>
>>     There is no exact equivalent, but there is something similar and much
>>     better: you can
>>     authenticate the client with SSL client certificates:
>>     https://www.postgresql.org/docs/current/auth-cert.html
>
>
>     Isn’t the wallet the part where the encryption keys are stored?
>
>     Indeed, one of the few remaining features that only Oracle (and of
>     course other commercial RDMSs) has seems to be full HSM support for TDE.
>
>
>     Rainer
>

-- 
Angular momentum makes the world go 'round.

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 23:13  Ron <ronljohnsonjr@gmail.com>
  parent: Benedict Holland <benedict.m.holland@gmail.com>
  1 sibling, 1 reply; 14+ messages in thread

From: Ron @ 2022-12-21 23:13 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

And encrypting a tar.gz file presumes a pretty small database.  (The --jobs= 
option was added to pg_dump/pg_restore for just that reason.)

On 12/21/22 16:25, Benedict Holland wrote:
> What would you be missing? You can encrypt databases. You can encrypt the 
> s3 buckets using kms. You can govern access via ssh Auth. When you do 
> backups, you can encrypt the tar.gz files or whatever format and store it 
> on s3. Same with the wal files. The fact that oracle charges for this is a 
> joke. Of course, you would need to ensure compliance with your opsec teams 
> and stuck with best security practices but it seems top to bottom 
> encryption is unrelated or tangentially related to the databases.
>
> Also, if you lose the encryption keys for your backups then bad things 
> happen. I doubt what I did was production viable but I limited database 
> access to a handful of users, encrypted the disks, left the Wal files 
> unencrypted but mounted with read access for a single user, compressed 
> full backups with encryption and a password, generated sah keys for anyone 
> who needed service accounts to access the systems, enforced database 
> ownership permissions, and and gave server access to a tiny team with 2fa. 
> The way 8 figured it, if someone somehow rooted the box we were screwed 
> anyway.
>
> For an internal database, this seemed sufficient. For an external 
> database, I would highly recommend paid consulting security firms or hire 
> people who know to build an externally facing platform.
>
> Thanks
> Ben
>
> On Wed, Dec 21, 2022, 4:39 PM Rainer Duffner <rainer@ultra-secure.de> wrote:
>
>
>
>>     Am 21.12.2022 um 22:34 schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
>>
>>     There is no exact equivalent, but there is something similar and much
>>     better: you can
>>     authenticate the client with SSL client certificates:
>>     https://www.postgresql.org/docs/current/auth-cert.html
>
>
>     Isn’t the wallet the part where the encryption keys are stored?
>
>     Indeed, one of the few remaining features that only Oracle (and of
>     course other commercial RDMSs) has seems to be full HSM support for TDE.
>
>
>     Rainer
>

-- 
Angular momentum makes the world go 'round.

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-21 23:57  Benedict Holland <benedict.m.holland@gmail.com>
  parent: Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 14+ messages in thread

From: Benedict Holland @ 2022-12-21 23:57 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>

Yea. I wasn't clear. I tar up the dump files as part of the command. Dont
lose your keys is awesome in theory. AWS comes with managed keys. The Wal
command will let you encrypt your Wal files too but if I were a hacker then
I would also copy ssh folders. It depends on security and business needs.
If I migrated this to a production environment we would have quite a bit
more infrastructure, likely a dedicated s3 location for Wal files, backups,
redundancy, k8's for nodes, a complex file server, and a bunch more stuff
that you pay people to set up, configure, and manage.

Like, does oracle give you something more? Probably. It's also a ton of
money and I mean a geuine ton. At that point, you also need security
audits, security protocols, requirements, backup and retention policies,
and redundancy key locations. If someone has root, I don't know how they
also don't have your encryption keys. Maybe they don't on a USB but then
th3 USB breaks or gets lost. Unencrypted Wal files on an RW partition with
a single user able to read or write along with nightly encrypted pgdump
might meet security needs. Or not. But that is true about anything. I have
never set up a credit card database. I assume those are locked down way
more than I ever will lock down a system.

On Wed, Dec 21, 2022, 6:13 PM Ron <ronljohnsonjr@gmail.com> wrote:

> And encrypting a tar.gz file presumes a pretty small database.  (The
> --jobs= option was added to pg_dump/pg_restore for just that reason.)
>
> On 12/21/22 16:25, Benedict Holland wrote:
>
> What would you be missing? You can encrypt databases. You can encrypt the
> s3 buckets using kms. You can govern access via ssh Auth. When you do
> backups, you can encrypt the tar.gz files or whatever format and store it
> on s3. Same with the wal files. The fact that oracle charges for this is a
> joke. Of course, you would need to ensure compliance with your opsec teams
> and stuck with best security practices but it seems top to bottom
> encryption is unrelated or tangentially related to the databases.
>
> Also, if you lose the encryption keys for your backups then bad things
> happen. I doubt what I did was production viable but I limited database
> access to a handful of users, encrypted the disks, left the Wal files
> unencrypted but mounted with read access for a single user, compressed full
> backups with encryption and a password, generated sah keys for anyone who
> needed service accounts to access the systems, enforced database ownership
> permissions, and and gave server access to a tiny team with 2fa. The way 8
> figured it, if someone somehow rooted the box we were screwed anyway.
>
> For an internal database, this seemed sufficient. For an external
> database, I would highly recommend paid consulting security firms or hire
> people who know to build an externally facing platform.
>
> Thanks
> Ben
>
> On Wed, Dec 21, 2022, 4:39 PM Rainer Duffner <rainer@ultra-secure.de>
> wrote:
>
>>
>>
>> Am 21.12.2022 um 22:34 schrieb Laurenz Albe <laurenz.albe@cybertec.at>:
>>
>> There is no exact equivalent, but there is something similar and much
>> better: you can
>> authenticate the client with SSL client certificates:
>> https://www.postgresql.org/docs/current/auth-cert.html
>>
>>
>>
>> Isn’t the wallet the part where the encryption keys are stored?
>>
>> Indeed, one of the few remaining features that only Oracle (and of course
>> other commercial RDMSs) has seems to be full HSM support for TDE.
>>
>>
>> Rainer
>>
>
> --
> Angular momentum makes the world go 'round.
>

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-22 08:17  Rainer Duffner <rainer@ultra-secure.de>
  parent: Benedict Holland <benedict.m.holland@gmail.com>
  0 siblings, 1 reply; 14+ messages in thread

From: Rainer Duffner @ 2022-12-22 08:17 UTC (permalink / raw)
  To: Benedict Holland <benedict.m.holland@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-general <pgsql-general@lists.postgresql.org>



> Am 22.12.2022 um 00:57 schrieb Benedict Holland <benedict.m.holland@gmail.com>:
> 
> Like, does oracle give you something more? Probably. It's also a ton of money and I mean a geuine ton. At that point, you also need security audits, security protocols, requirements, backup and retention policies, and redundancy key locations. If someone has root, I don't know how they also don't have your encryption keys. 

They are not on the same box. They are in a HSM. A dedicated piece of tamper-proof hardware that stores secrets (keys).
The Oracle-server needs to talk to the HSM to get the keys. 

This is not a low-budget setup (well, it’s Oracle…) - rather, it’s for when the data is really very valuable so that the cost for redundant HSMs, Oracle, Data Guard etc.pp. is still lower than the value of the data. 

OP works for an outfit that typically does outsourcing for these kinds of clients.

It’s all about having more degrees of separation between different functions, so you don’t have to trust the single, Dennis-Nedry-type of admin to not sell the information in the database to the highest bidder.

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-22 09:46  Peter J. Holzer <hjp-pgsql@hjp.at>
  parent: Rainer Duffner <rainer@ultra-secure.de>
  0 siblings, 1 reply; 14+ messages in thread

From: Peter J. Holzer @ 2022-12-22 09:46 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 2022-12-22 09:17:18 +0100, Rainer Duffner wrote:
>     Am 22.12.2022 um 00:57 schrieb Benedict Holland <
>     benedict.m.holland@gmail.com>:
> 
>     If someone has root, I don't know how they also don't have your
>     encryption keys. 
> 
> 
> They are not on the same box. They are in a HSM. A dedicated piece of
> tamper-proof hardware that stores secrets (keys).
> The Oracle-server needs to talk to the HSM to get the keys. 

If the hacker has root access: What prevents them from talking to the
HSM?

        hp

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-22 10:15  Rainer Duffner <rainer@ultra-secure.de>
  parent: Peter J. Holzer <hjp-pgsql@hjp.at>
  0 siblings, 2 replies; 14+ messages in thread

From: Rainer Duffner @ 2022-12-22 10:15 UTC (permalink / raw)
  To: Peter J. Holzer <hjp-pgsql@hjp.at>; +Cc: pgsql-general@lists.postgresql.org



> Am 22.12.2022 um 10:46 schrieb Peter J. Holzer <hjp-pgsql@hjp.at>:
> 
> If the hacker has root access: What prevents them from talking to the
> HSM?


I wasn’t involved in setting it up here, but AFAIK you need to „enroll“ the client to the HSM.

That is a one-time process that requires HSM credentials (via certificates and pass-phrases).

Then, that client can talk to the HSM. 

The HSM-client is (or should be) engineered in such a way that you can’t extract the encryption-secret easily.

I am not sure, but IIRC, you should not even be able to clone the VM without the HSM noticing or the clone not working at all to begin with (for lack of enrollment). Though most production databases are too large to just „clone“.

Maybe someone who knows more about this subject can chime in before I make a fool of myself?
;-)




Rainer=

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2022-12-22 15:58  Peter J. Holzer <hjp-pgsql@hjp.at>
  parent: Rainer Duffner <rainer@ultra-secure.de>
  1 sibling, 0 replies; 14+ messages in thread

From: Peter J. Holzer @ 2022-12-22 15:58 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 2022-12-22 11:15:57 +0100, Rainer Duffner wrote:
> 
> 
>     Am 22.12.2022 um 10:46 schrieb Peter J. Holzer <hjp-pgsql@hjp.at>:
> 
>     If the hacker has root access: What prevents them from talking to the
>     HSM?
> 
> 
> 
> I wasn’t involved in setting it up here, but AFAIK you need to „enroll“ the
> client to the HSM.
> 
> That is a one-time process that requires HSM credentials (via certificates and
> pass-phrases).
> 
> Then, that client can talk to the HSM. 

Which means that some sort of access-token is stored on the client.

So what prevents a hacker from using that access token?

> The HSM-client is (or should be) engineered in such a way that you can’t
> extract the encryption-secret easily.

Security by obscurity? Just hope that nobody figures out how that access
token is stored? That doesn't seem like a good strategy against
high-level threats.

        hp

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 14+ messages in thread

* Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
@ 2023-01-07 03:26  Bruce Momjian <bruce@momjian.us>
  parent: Rainer Duffner <rainer@ultra-secure.de>
  1 sibling, 0 replies; 14+ messages in thread

From: Bruce Momjian @ 2023-01-07 03:26 UTC (permalink / raw)
  To: Rainer Duffner <rainer@ultra-secure.de>; +Cc: Peter J. Holzer <hjp-pgsql@hjp.at>; pgsql-general@lists.postgresql.org

On Thu, Dec 22, 2022 at 11:15:57AM +0100, Rainer Duffner wrote:
> I wasn’t involved in setting it up here, but AFAIK you need to „enroll“ the
> client to the HSM.
> 
> That is a one-time process that requires HSM credentials (via certificates and
> pass-phrases).
> 
> Then, that client can talk to the HSM. 
> 
> The HSM-client is (or should be) engineered in such a way that you can’t
> extract the encryption-secret easily.
> 
> I am not sure, but IIRC, you should not even be able to clone the VM without
> the HSM noticing or the clone not working at all to begin with (for lack of
> enrollment). Though most production databases are too large to just „clone“.
> 
> Maybe someone who knows more about this subject can chime in before I make a
> fool of myself?

This wiki should help:

	https://wiki.postgresql.org/wiki/Transparent_Data_Encryption

Also, the first two patches in this email are doc patches which explain
the benefits:

	https://www.postgresql.org/message-id/20210625212204.GA7256@momjian.us

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

Embrace your flaws.  They make you human, rather than perfect,
which you will never be.





^ permalink  raw  reply  [nested|flat] 14+ messages in thread


end of thread, other threads:[~2023-01-07 03:26 UTC | newest]

Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-21 04:48 Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration Chetan Kosanam <chetan.kosanam@tcs.com>
2022-12-21 17:41 ` Alicja Kucharczyk <zaledwie10minut@gmail.com>
2022-12-21 19:21   ` Sandeep Saxena <sandeep.lko@gmail.com>
2022-12-21 21:34 ` Laurenz Albe <laurenz.albe@cybertec.at>
2022-12-21 21:39   ` Rainer Duffner <rainer@ultra-secure.de>
2022-12-21 22:25     ` Benedict Holland <benedict.m.holland@gmail.com>
2022-12-21 23:10       ` Ron <ronljohnsonjr@gmail.com>
2022-12-21 23:13       ` Ron <ronljohnsonjr@gmail.com>
2022-12-21 23:57         ` Benedict Holland <benedict.m.holland@gmail.com>
2022-12-22 08:17           ` Rainer Duffner <rainer@ultra-secure.de>
2022-12-22 09:46             ` Peter J. Holzer <hjp-pgsql@hjp.at>
2022-12-22 10:15               ` Rainer Duffner <rainer@ultra-secure.de>
2022-12-22 15:58                 ` Peter J. Holzer <hjp-pgsql@hjp.at>
2023-01-07 03:26                 ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox