If db_source'ing isn't working then the first thing to do, as mentioned by the latest poster, is to log into the account you're running under and double-check that PSQL is working properly. If not, most frequently the cause will be your PATH not being set correctly ...
