FATAL: password authentication failed for user “postgres”
This problem occurs when a there has been an old installation of GECAMed on this MAC which has not been completely removed. To remove GECAMed on a MAC you need to do the following things:
Method 1 (old versions of OS X) :
Method 2 (newer versions) :
Determining the PostgreSQL Version Already Installed To verify which version of PostgreSQL you will be replacing, at the Terminal command line prompt type:
The Terminal will respond with a list of all the directories shown in the folder found at /Library/PostgreSQL, each version number will be installed in it's own directory. In the example shown below we can confirm that PostgreSQL 9.0 is installed.
The examples used in this Guide assumes that PostgreSQL version 8.4 is installed, in the event you have a different version of PostgreSQL installed then replace the version number accordingly. For example, if you need to uninstall PostgreSQL 9.0 then replace /Library/PostgreSQL/8.4/ with /Library/PostgreSQL/9.0/
Uninstalling PostgreSQL Tip: You may need to enter your password after entering any command line that starts with Sudo to comply with OS X security procedures.
1. Execute (double click) /Library/PostgreSQL/8.4/uninstall-postgresql which will uninstall the PostgreSQL installation.
2. Stop the server.
sudo /sbin/SystemStarter stop postgresql-8.4
3. Remove menu shortcuts:
sudo rm -Rf /Applications/PostgreSQL 8.4
4. Remove the ini file
sudo rm /etc/postgres-reg.ini
5. Removing Startup Items
sudo rm /Library/StartupItems/postgresql-8.4
6. Remove the data and installed files (all databases will be lost at this point)
sudo rm -Rf /Library/PostgreSQL/8.4
7. Delete the user postgres
sudo dscl . delete /users/postgres
8. Reboot your computer
9. Reinstall GECAMED