If the regular /Applications/PostgreSQL 9.0/uninstall-postgresql.app doesn't help then there are manual steps which will remove ALL the elements of the PG
Manual Uninstallation:
1) Stop the server
sudo /sbin/SystemStarter stop postgresql-9.0
2) Remove menu shortcuts:
sudo rm -rf /Applications/PostgreSQL 9.0
3) Remove the ini file
sudo rm -rf /etc/postgres-reg.ini
4) Removing Startup Items
sudo rm -rf /Library/StartupItems/postgresql-9.0
5) Remove the data and installed files
sudo rm -rf /Library/PostgreSQL/9.0
6) Delete the user postgres
sudo dscl . delete /users/postgres
Arvind
From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: pgsql-novice@postgresql.org
Sent: Monday, November 7, 2011 6:02 AM
Subject: [NOVICE] complete uninstall of postgres 9.0.4
Hello,
It seems I've rather botched my installation of postgres onto my Mac OSX lion machine. I would like to "start over from scratch". I've tried "brew uninstall postgresql" but this seems to leave a bunch of configuration nonsense that I dont' need in my new installation still in tact (or something). In any case, instead of trying to figure out what i did wrong, I'd like to completely start over with the installation process. i don't need to retain any database tables or any data or anything like that. I'd like to get my machine back to a point where it knew nothing of postgres.
Please let me know if you can assist me.
And, along the way, if you know of any gotchas that come with trying to install postgres on mac osx lion, please let me know about them. I'm completely new to both Mac OSX lion (though not linux) and completely new to postgres (though i have used MySQL and SQL-Server in the past).
Thanks kindly,
_Ramy