Making a correct Postgres user
August 26, 2009 3:46 pm MiscellaneousYeah, the reason it won’t connect is that create user foo with password ‘bar’ explicitly means “they can’t connect unless their password is sent plaintext”, which awesomely the manual doesn’t mention.
You wanted create user with encrypted password ‘bar’ instead.
