[HACKERS] Need help on pgcrypto

2016-01-11 Thread rajan 
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.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Need help on pgcrypto

2016-01-11 Thread Vitaly Burovoy 
On 1/11/16, Michael Paquier  wrote:
> On Mon, Jan 11, 2016 at 10:03 PM, rajan  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Need help on pgcrypto

2016-01-11 Thread Michael Paquier 
On Mon, Jan 11, 2016 at 10:03 PM, rajan  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers