Almost certainly MySQL, which is overwhelmingly the competitor in the psql space. A big reason why mysql took off is the same reason that PHP took off -- it is very quick and easy to take the first steps.
I think most people struggle with setting up postgres auth. Personally, I find postgres' auth well designed.