After you install PostgreSQL 8.4 on Lion, a PostgreSQL user pops up in the login window. To hide system users (including the PostgreSQL user), type the following in your terminal:

sudo defaults write /Library/Preferences/com.apple.loginwindow Hide500Users -bool TRUE