Uninstall Postgres

I can't get the uninstall-postgres.app on my mac to show up in the installation directory. Even if I search my mac, it isn't there. I tried downloading the most recent version and upgrading, but it still is not there. Can I download this and put it in the directory manually or something?

This message was edited 1 time. Last update was at 26 Jul 2010 01:33:32

Hello,

The uninstaller will not be created when you run the installer in upgrade mode. You can use these steps to uninstall postgresql from your mac.

i) Stop the server.
sudo launchctl unload /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

ii) Remove the plist file
sudo rm -f /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

iii) Remove the Applications Menu.
sudo rm -f "/Applications/PostgreSQL 8.4"

iv) Remove the installation directory
sudo rm -rf /Library/PostgreSQL/8.4
(Note: You can backup your data directory in case you need it.)

v) Remove the 'postgres' user
sudo dscl . delete /Users/postgres
(Note: This step is optional)

vi) Remove the ini file
sudo rm -f /etc/postgres-reg.ini

After these steps, PostgreSQL is completely removed from your system.

You can run the latest installer again to install PostgreSQL (You can also point the installation to use your backed up data directory also). This time it will create the uninstaller.

Hope it helps.

Hi ,
I am Using CentOS, Whether anyone have any idea how to uninstall POSGRESQL in Centos?

Thanks

I just installed PostgreSQL on my OSX Leopard, and the uninstaller does not seem to exist. There is a bug in your installer. I hope my system won't get screwed up.

Hi,

Can you please copy paste the first and last 10 lines of the installation logs (/tmp/postgresql.log)?

Did you try to upgrade or install a new instance?

Hi All,

By mistake i uninstalled db_server, edbmtk and edbpgagent from database server.
Is there anyway to restore the database to the previous point?
Please help me in this issue

Re-run the installer, and select the ones you uninstalled, this will put back the binaries that you uninstalled. In case of dbserver, you can choose your existing data directory..

thank you sachin for your help.....