Re: [GENERAL] Encrypt with BouncyCastle and decrypt with pg_pub_decrypt - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] Encrypt with BouncyCastle and decrypt with pg_pub_decrypt
Date
Msg-id CAMkU=1xBZdr5EJ8Bt9RVaG6go2-7UL2v=N2=DrhODJ-84KLx9A@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Encrypt with BouncyCastle and decrypt with pg_pub_decrypt  ("Kang, Kamal" <k_kang@conversantmedia.com>)
List pgsql-general
On Thu, May 18, 2017 at 4:57 PM, Kang, Kamal <k_kang@conversantmedia.com> wrote:

Hi all,

 

I am trying to encrypt a string using Bouncy Castle PGP Java apis, Base64 encode the encrypted string and then decrypt using pg_pub_decrypt but it is failing with error “Wrong Key”. Just wanted to know if this is doable or pg_pub_decrypt only works with encrypted strings from pg_pub_encrypt?



pg_pub_decrypt is compatible with gpg, so if Bouncy Castle is also compatible with gpg I don't see why it wouldn't also work.  Without more information, it is hard to provide more advice.  encrypt a dummy payload with a dummy password and show us what you get and what you do with it.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] Serializable isolation -- are predicate locks stillheld across all databases?
Next
From: Ed Behn
Date:
Subject: [GENERAL] Partitioned Data and Locking