"Sally Sally" <dedeb17@hotmail.com> wrote: > > I wanted to use md5 authentication method for my pg db. I was initially > using a trust method and I noticed when I switched to md5 I had to assign a > password to the user postgres as it was created without one. Here do I pass > an md5 encrypted string? No. md5 just refers to the way it's stored in pgsql. > Also everytime I connect via perl's DBI do I have > to pass it the encrypted string (if so which perl module for md5 encryption > is the best to use?) See above. > I was confused as to whether I should create the password encrypted or > whether postgres saves it encrypted. The latter. Jim ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)