Re: PGP encrypt/decrypt - Prereqistes - Mailing list pgsql-general

From Vikram A
Subject Re: PGP encrypt/decrypt - Prereqistes
Date
Msg-id 414560.49185.qm@web137404.mail.in.yahoo.com
Whole thread Raw
In response to Re: PGP encrypt/decrypt - Prereqistes  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: PGP encrypt/decrypt - Prereqistes
Re: PGP encrypt/decrypt - Prereqistes
Re: PGP encrypt/decrypt - Prereqistes
List pgsql-general
Dear Mr. Craig Ringer,
Thank you for your response. 
I would like to crypt certain sensitive information in my applications such as Student register number, their marks, results etc. For this reason i done a study for doing encryption. Where I found that this PGP will help the encryption/decryption.  
Any other methods/techniques are there for encryption? I prefer encryption with "key"; key also should not be known to Developers. 
Please suggest any such methods. 
Thank you in advance.

Vikram


From: Craig Ringer <craig@postnewspapers.com.au>
To: Vikram A <vikkiatbipl@yahoo.in>
Cc: PGSQL - Genearal <pgsql-general@postgresql.org>
Sent: Friday, 10 June 2011 6:20 PM
Subject: Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

On 06/10/2011 05:22 PM, Vikram A wrote:

> I am new to postgreSQL. I would like to use encrypt/decrypt using PGP
> keys on windows.

It'd be helpful to know in more detail what you want to encrypt and decrypt, and how. Getting crypto right is about a lot more than using good algorithms and good implementations.

> 2. Any manual to follow the steps ?

You'll want the pgycrypto contrib module. Its documentation is here:

http://www.postgresql.org/docs/current/static/pgcrypto.html#AEN124147

... and I think (but am not certain) that it's available on Windows. Note that according to the documentation pgcrypto does not support signing - or presumably for verifying signatures.

You will also want GnuPG from http://www.gnupg.org/  to use it for key management and key generation.

--
Craig Ringer


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: trouble shooting
Next
From: Sim Zacks
Date:
Subject: Re: determine client os