sql-postgres always tries to connect with the same username as the user running emacs. I worked around this by creating a superuser in the database I was working in with my username. Probably not best practice though - I'd love to know how to send a username from Emacs.
