The key here is that system accounts (what you are logging into with su) and postgresql accounts (what you are logging into with psql) are entirely different sets of accounts. Use Antonius's advice to change the system password for the "postgres" system user.
– DerfKMay 15 '11 at 20:19