| Lists: | pgsql-hackers |
|---|
| From: | rajan <vgmonnet(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Need help on pgcrypto |
| Date: | 2016-01-11 13:03:42 |
| Message-ID: | 1452517422694-5881477.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Trying to find a documentation which will make me understand how to secure a
password column. I want the encryption to be one way and it should not be
decrypted.
I am able to find discrete documents but nothing of them gets me there.
Please help.
-----
--
Thanks,
Rajan.
--
View this message in context: http://postgresql.nabble.com/Need-help-on-pgcrypto-tp5881477.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | rajan <vgmonnet(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Need help on pgcrypto |
| Date: | 2016-01-11 13:11:18 |
| Message-ID: | CAB7nPqTYivrmvu0Ry=p1FA6v0Bukv5xdSpnGguRkkxYM2Bo7Kw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, Jan 11, 2016 at 10:03 PM, rajan <vgmonnet(at)gmail(dot)com> wrote:
> Trying to find a documentation which will make me understand how to secure a
> password column. I want the encryption to be one way and it should not be
> decrypted.
>
> I am able to find discrete documents but nothing of them gets me there.
Er, isn't that enough?
http://www.postgresql.org/docs/devel/static/pgcrypto.html
--
Michael
| From: | Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | rajan <vgmonnet(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Need help on pgcrypto |
| Date: | 2016-01-11 13:26:08 |
| Message-ID: | CAKOSWNk-+2M5opqErWj2dmsjknRTEJSPsiw2NxRgwfk_2x1Y5w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On 1/11/16, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
> On Mon, Jan 11, 2016 at 10:03 PM, rajan <vgmonnet(at)gmail(dot)com> wrote:
>> Trying to find a documentation which will make me understand how to secure
>> a
>> password column. I want the encryption to be one way and it should not be
>> decrypted.
>>
>> I am able to find discrete documents but nothing of them gets me there.
>
> Er, isn't that enough?
> http://www.postgresql.org/docs/devel/static/pgcrypto.html
> --
> Michael
I'd give more specific URL with examples of SELECT and UPDATE:
http://www.postgresql.org/docs/devel/static/pgcrypto.html#AEN170716
... but recommend to change just "gen_salt('md5')" to "gen_salt('bf', 8))"
--
Best regards,
Vitaly Burovoy