Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2022-12-22 Thread Peter J. Holzer
On 2022-12-22 11:15:57 +0100, Rainer Duffner wrote: > > > Am 22.12.2022 um 10:46 schrieb Peter J. Holzer : > > 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

Re: Implementing foreign data wrappers and avoiding n+1 querying

2022-12-22 Thread David Gilman
I apologize that my post was not super clear, I am thinking about implementing a fdw from scratch, and the target database is one of those NoSQL databases where you have to send JSON over a HTTP connection for each query. I have reviewed the postgres fdw code to see how it works and to see what's

Re: trouble writing plpgsql

2022-12-22 Thread hubert depesz lubaczewski
On Thu, Dec 22, 2022 at 11:37:22AM -, haman...@t-online.de wrote: > I want to make a function to parsetext and return key-value pairs > create or replace function extractinfo (text) returns table (key char[1], val > text) Please don't use char datatype: https://wiki.postgresql.org/wiki/Don't

trouble writing plpgsql

2022-12-22 Thread hamann . w
Hi, I want to make a function to parsetext and return key-value pairs create or replace function extractinfo (text) returns table (key char[1], val text) language plpgsql as $$ I first tried declare xx record; begin xx.key = ; xx.val = ; return next xx: This is not possible bec

Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2022-12-22 Thread Rainer Duffner
> Am 22.12.2022 um 10:46 schrieb Peter J. Holzer : > > 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 cer

Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2022-12-22 Thread Peter J. Holzer
On 2022-12-22 09:17:18 +0100, Rainer Duffner wrote: > Am 22.12.2022 um 00:57 schrieb Benedict Holland < > benedict.m.holl...@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.

Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2022-12-22 Thread Rainer Duffner
> Am 22.12.2022 um 00:57 schrieb Benedict Holland > : > > 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