Hello, since I upgraded PostgreSQL it now stores passwords in MD5 format. When I try connecting using password authentication, i get:
Jan 9 12:22:24 prometheus postgres[28540]: [2] LOG: Password is stored MD5 encrypted. 'password' and 'crypt' auth methods cannot be used. Now, if password and crypt are no longer available, how am I supposed to connect through TCP at all? Assuming I don't want to set up kerberos or something just to get PostgreSQL working :) The the more important question is, how do I change this back? In the current situation I couldn't care less about this type of security because everything is done on the loopback interface so plain text is fine. I just need to be able to connect using password authentication (I'm using JDBC). Any pointers are greatly appreciated. Thanks! -- / Peter Schuller, InfiDyne Technologies HB PGP userID: 0xE9758B7D or 'Peter Schuller <[EMAIL PROTECTED]>' Key retrival: Send an E-Mail to [EMAIL PROTECTED] E-Mail: [EMAIL PROTECTED] Web: http://www.scode.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
