pgcrypto - real life examples to encrypt / decrypt

Dear Experts, Could you please share some real life examples of using pgcrypto in production? I am planning to use it in our environment and wondering what could be the best practice for its use. Thank you. Regards Vikas S

Re: pgcrypto - real life examples to encrypt / decrypt

On 8/2/21 2:14 PM, Vikas Sharma wrote: Dear Experts, Could you please share some real life examples of using pgcrypto in production? I am planning to use it in our environment and wondering what could be the best practice for its use. I would start by doing a search on 'using pgcrypto', th

Re: pgcrypto - real life examples to encrypt / decrypt

Thanks Adrian, I will check them out. Regards Vikas S On Mon, 2 Aug 2021 at 22:22, Adrian Klaver wrote: > On 8/2/21 2:14 PM, Vikas Sharma wrote: > > Dear Experts, > > > > Could you please share some real life examples of using pgcrypto in > > production? > > > > I am planning to use it in our

Re: pgcrypto - real life examples to encrypt / decrypt

On Mon, Aug 2, 2021 at 11:14 PM Vikas Sharma wrote: > > Dear Experts, > > Could you please share some real life examples of using pgcrypto in > production? > > I am planning to use it in our environment and wondering what could be the > best practice for its use. It is not clear what you are go

Re: pgcrypto - real life examples to encrypt / decrypt

Thank you Luca, For now I have seen the below: pgp_pub_encrypt -- using public gpg key pgp_pub_decrypt -- using secret gpg key Select crypt('test', gen_salt('md5')); Select PGP_SYM_DECRYPT(PGP_SYM_ENCRYPT('Some data','Secret password','compress-algo=1, cipher-algo=aes256'),'Secret password');

Re: pgcrypto - real life examples to encrypt / decrypt

On Tue, Aug 3, 2021 at 1:03 PM Vikas Sharma wrote: > My question is, can I use the gpg public/secret key instead of the 'Secret > password' in above PGP_Sym_encrypt/decrypt? I can create a wrapper function > to read the public/secret keys to hide it from appearing as clear text. I think you ar

Re: pgcrypto - real life examples to encrypt / decrypt

On 8/3/21 8:43 AM, Luca Ferrari wrote: On Tue, Aug 3, 2021 at 1:03 PM Vikas Sharma wrote: My question is, can I use the gpg public/secret key instead of the 'Secret password' in above PGP_Sym_encrypt/decrypt? I can create a wrapper function to read the public/secret keys to hide it from appe

Re: pgcrypto - real life examples to encrypt / decrypt

Thanks you Guys, These are very helpful pointers. I will go away and see how much depth I do need. Regards Vikas S. On Tue, 3 Aug 2021 at 14:36, Joe Conway wrote: > On 8/3/21 8:43 AM, Luca Ferrari wrote: > > On Tue, Aug 3, 2021 at 1:03 PM Vikas Sharma wrote: > >> My question is, can I use the

Re: pgcrypto - real life examples to encrypt / decrypt

someone mentioned an alternative earlier that they couldn't remember -- i think it may have been pgsodium that they were thinking of https://github.com/michelp/pgsodium

Re: pgcrypto - real life examples to encrypt / decrypt

How do those of us who compile PostgreSQL from source get libsodium into the mix? On Fri, Aug 6, 2021 at 2:27 PM Reid Thompson wrote: > someone mentioned an alternative earlier that they couldn't remember -- i > think it may have been pgsodium that they were thinking of > https://github.com/mich

Re: pgcrypto - real life examples to encrypt / decrypt

On 8/6/21 12:23 PM, Theodore M Rolle, Jr. wrote: How do those of us who compile PostgreSQL from source get libsodium into the mix? Have your package manager install it. OR https://doc.libsodium.org/ On Fri, Aug 6, 2021 at 2:27 PM Reid Thompson > wrote:

Re: pgcrypto - real life examples to encrypt / decrypt

On Fri, Aug 6, 2021 at 8:27 PM Reid Thompson wrote: > > someone mentioned an alternative earlier that they couldn't remember -- i > think it may have been pgsodium that they were thinking of > https://github.com/michelp/pgsodium > Yes, thanks. For some reason I was remembering "selenium" someth