Обсуждение: How to use public key file to encrypt data

Поиск
Список
Период
Сортировка

How to use public key file to encrypt data

От
ROS Didier
Дата:

Hi

               I Would like to know how to encrypt data with  physical public key files. I can’t find any documentation about this subject.

               Thanks in advance

 

Best Regards

cid:image002.png@01D14E0E.8515EB90


Didier ROS
Expertise SGBD
DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD
Nanterre Picasso - E2 565D (aile nord-est)
32 Avenue Pablo Picasso
92000 Nanterre

 

 


Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y figurent sont strictement confidentielles. Toute utilisation de ce Message non conforme à sa destination, toute diffusion ou toute publication totale ou partielle, est interdite sauf autorisation expresse.

Si vous n'êtes pas le destinataire de ce Message, il vous est interdit de le copier, de le faire suivre, de le divulguer ou d'en utiliser tout ou partie. Si vous avez reçu ce Message par erreur, merci de le supprimer de votre système, ainsi que toutes ses copies, et de n'en garder aucune trace sur quelque support que ce soit. Nous vous remercions également d'en avertir immédiatement l'expéditeur par retour du message.

Il est impossible de garantir que les communications par messagerie électronique arrivent en temps utile, sont sécurisées ou dénuées de toute erreur ou virus.
____________________________________________________

This message and any attachments (the 'Message') are intended solely for the addressees. The information contained in this Message is confidential. Any use of information contained in this Message not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval.

If you are not the addressee, you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return message.

E-mail communication cannot be guaranteed to be timely secure, error or virus-free.

Вложения

Re: How to use public key file to encrypt data

От
Jeff Janes
Дата:
On Tue, Jul 3, 2018 at 6:17 AM, ROS Didier <didier.ros@edf.fr> wrote:

Hi

               I Would like to know how to encrypt data with  physical public key files. I can’t find any documentation about this subject.

               Thanks in advance


This isn't really a suitable question for pgsql-hackers, as you aren't talking about development of the PostgreSQL system itself, but rather usage of that system.  That type of question should probably go to pgsql-general.

I don't know what it means for a key file to be "physical".  Does that mean stored on disk?  

The functions you get from pgcrypto extension do not automatically detect the format of the key file, so you have to de-armor them explicitly if they are stored in base64.  I wish it would detect that.  I just do it on the fly.

Here is a program I have used for testing and benchmarking pgcrypto, perhaps you would find it useful as an example.


Cheers,

Jeff
Вложения