I'd like to know too - I had a play with psychog but couldn't get it to connect, and couldn't find any documentation for it. I don't have a huge amount of PostgreSQL knowledge (more of a MySQL person myself) so I could have it setup wrong, but I couldn't figure anything out as the error message was useless (something about IDENT user).