psql -d <databasename> -h <hostnam> -U <username>
You will then be prompted for your password. (That is a capital U)