Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?

uninstall postgresql 12 from mac
uninstall postgresql 8.4 mac
how to use postgresql on mac
how to check postgres is running in mac
removing postgres
how to see if postgres is running on mac
how to check whether postgresql is installed on mac
how to check postgres running or not in mac

This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major differences. I'm running Lion and I'm trying to uninstall PostgreSQL 9.0.4. I've looked at the last question and the link that it referenced, but I did not find a file called "uninstall-postgresql" when I run this command:

sudo find / -name "*uninstall-*"  

So, I assume this means that the uninstall process for 9.0.4 is different than that of 8.x.

I've seen a couple of posts in different places describing a method for manual uninstallation but, similarly, some of the directories/files referenced are not present on my machine.

Any assistance or direction you can provide would be greatly appreciated.

Just for reference, this is the link the other poster used to uninstall postgres from snow leopard. As I tried to step through these commands, most of them choked with some variant of "command not found".


UPDATE:

In addition to brew uninstall postgres, should I remove any of the following files/directories manually? Keep in mind I want to completely wipe the slate clean, no data files/database tables or anything.

> sudo find / -name "*postgres*"             
find: /dev/fd/3: Not a directory
find: /dev/fd/4: Not a directory
/Library/Ruby/Gems/1.8/doc/activerecord-3.1.1/rdoc/lib/active_record/connection_adapters/postgresql_adapter_rb.html
/Library/Ruby/Gems/1.8/doc/activerecord-3.1.1/ri/ActiveRecord/ConnectionAdapters/PostgreSQLAdapter/postgresql_version-i.ri
/Library/Ruby/Gems/1.8/doc/arel-2.2.1/rdoc/lib/arel/visitors/postgresql_rb.html
/Library/Ruby/Gems/1.8/gems/activerecord-3.1.1/lib/active_record/connection_adapters/postgresql_adapter.rb
/Library/Ruby/Gems/1.8/gems/arel-2.2.1/lib/arel/visitors/postgresql.rb
/Library/Ruby/Gems/1.8/gems/arel-2.2.1/test/visitors/test_postgres.rb
/Library/Ruby/Gems/1.8/gems/railties-3.1.1/lib/rails/generators/rails/app/templates/config/databases/jdbcpostgresql.yml
/Library/Ruby/Gems/1.8/gems/railties-3.1.1/lib/rails/generators/rails/app/templates/config/databases/postgresql.yml
/Library/WebServer/Documents/postgresql
/Library/WebServer/Documents/postgresql/html/app-postgres.html
/Library/WebServer/Documents/postgresql/html/postgres-user.html
/private/etc/apache2/users/postgres.conf
/private/var/db/dslocal/nodes/Default/groups/_postgres.plist
/private/var/db/dslocal/nodes/Default/sharepoints/postgres's Public Folder.plist
/private/var/db/dslocal/nodes/Default/users/_postgres.plist
/private/var/db/dslocal/nodes/Default/users/postgres.plist
/System/Library/DirectoryServices/DefaultLocalDB/Default/groups/_postgres.plist
/System/Library/DirectoryServices/DefaultLocalDB/Default/users/_postgres.plist
/Users/postgres
/Users/remcat/dev/working/startwire/vendor/plugins/foreign_keys/lib/foreign_keys/postgresql_adapter.rb
/Users/remcat/Library/Application Support/CrashReporter/postgres_DCCEF98F-4602-5FF7-964F-5E717AC007B4.plist
/Users/remcat/Library/Caches/Homebrew/postgresql-9.0.4.tar.bz2
/Users/remcat/Library/Caches/Metadata/Safari/History/http:%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fstatic%2Findex.html.webhistory
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash.plist
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash
/Users/remcat/Library/Saved Application State/org.postgresql.pgadmin.savedState
/usr/bin/postgres_real
/usr/include/postgres_ext.h
/usr/include/postgresql
/usr/include/postgresql/internal/postgres_fe.h
/usr/include/postgresql/server/postgres.h
/usr/include/postgresql/server/postgres_ext.h
/usr/include/postgresql/server/postgres_fe.h
/usr/lib/postgresql
/usr/local/Library/Aliases/postgres
/usr/local/Library/Formula/postgresql.rb
/usr/local/var/postgres
/usr/local/var/postgres/postgresql.conf
/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
/usr/share/devicemgr/backend/vendor/rails/railties/configs/databases/postgresql.yml
/usr/share/devicemgr/webserver/gems/gems/eventmachine-0.12.10/lib/em/protocols/postgres3.rb
/usr/share/man/man1/postgres.1.gz
/usr/share/postgresql
/usr/share/postgresql/postgres.bki
/usr/share/postgresql/postgres.description
/usr/share/postgresql/postgres.shdescription
/usr/share/postgresql/postgresql.conf
/usr/share/postgresql/postgresql.conf.sample
homebrew Installer

Assuming you installed PostgreSQL with homebrew as referenced in check status of postgresql server Mac OS X and how to start postgresql server on mac os x: you can use the brew uninstall postgresql command.

EnterpriseDB Installer

If you used the EnterpriseDB installer then see the other answer in this thread.

The EnterpriseDB installer is what you get if you follow "download" links from the main Postgres web site. The Postgres team releases only source code, so the EnterpriseDB.com company builds installers as a courtesy to the community.

Postgres.app

You may have also used Postgres.app.

This double-clickable Mac app contains the Postgres engine.

8.2 Uninstalling PostgreSQL on a Windows System, This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major differences. I'm running  > 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

The following is the un-installation for PostgreSQL 9.1 installed using the EnterpriseDB installer. You most probably have to replace folder /9.1/ with your version number. If /Library/Postgresql/ doesn't exist then you probably installed PostgreSQL with a different method like homebrew or Postgres.app.

To remove the EnterpriseDB One-Click install of PostgreSQL 9.1:

  1. Open a terminal window. Terminal is found in: Applications->Utilities->Terminal
  2. Run the uninstaller:

    sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh
    

    If you installed with the Postgres Installer, you can do:

    open /Library/PostgreSQL/9.2/uninstall-postgresql.app
    

    It will ask for the administrator password and run the uninstaller.

  3. Remove the PostgreSQL and data folders. The Wizard will notify you that these were not removed.

    sudo rm -rf /Library/PostgreSQL
    
  4. Remove the ini file:

    sudo rm /etc/postgres-reg.ini
    
  5. Remove the PostgreSQL user using System Preferences -> Users & Groups.

    1. Unlock the settings panel by clicking on the padlock and entering your password.
    2. Select the PostgreSQL user and click on the minus button.
  6. Restore your shared memory settings:

    sudo rm /etc/sysctl.conf
    

That should be all! The uninstall wizard would have removed all icons and start-up applications files so you don't have to worry about those.

Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?, homebrew installer. Assuming you installed PostgreSQL with homebrew , as indicated in checking the status of the postgresql server on Mac OS X and how to​  Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion? (6) homebrew Installer. Assuming you installed PostgreSQL with homebrew as referenced in check status of postgresql server Mac OS X and how to start postgresql server on mac os x: you can use the brew uninstall postgresql command.

I don't use the same version, but uninstall actions are the same: Looking for file uninstall-postgresql inside directory

/Library/PostgreSQL/9.6

then run it.

(Screenshot in macOS 10.13)

then

sudo rm -rf /Library/PostgreSQL/

to delete all unnecessary directory.

🤽 ‍♀️ Completely uninstall PostgreSQL 9.0.4 from mac osx lion , Subject: Re: complete uninstall of postgres 9.0.4. Date: 2011-11-07 with trying to install postgres on mac osx lion, please >> let me know  I would like to remove my previous version 9.1.2 to keep my Stack Exchange Network Stack Exchange network consists of 175 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

I was not able to uninstall PostgreSQL 9.0.8. But I finally found this. (I installed Postgres using homebrew)

brew list

Look for the correct folder name. Something like.

postgresql9

Once you find the correct name do:

brew uninstall postgresql9

That should uninstall it.

Re: complete uninstall of postgres 9.0.4, Re: complete uninstall of postgres 9.0.4 I'm completely new to both Mac OSX lion (though not linux) and completely new to postgres (though i  I'm trying to remove an old version of Postgres on my local Macbook Pro but cannot figure it out. In PG Admin I see two servers, version 9.2 and 9.4. When I try to run Heroku commands such as pg:pull, its referring to the old server.

This blog post explains very well:

(just replace 9.X by your version. e.g: 9.6)

A. If installed PostgreSQL with homebrew, enter brew uninstall postgresql

B. If you used the EnterpriseDB installer, follow the following step.

Run the uninstaller on terminal window: sudo /Library/PostgreSQL/9.X/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh

C. If installed with Postgres Installer, do:

open /Library/PostgreSQL/9.X/uninstall-postgresql.app

Remove the PostgreSQL and data folders. The Wizard will notify you that these were not removed.

sudo rm -rf /Library/PostgreSQL

Remove the ini file:

sudo rm /etc/postgres-reg.ini

Remove the PostgreSQL user using System Preferences -> Users & Groups.

Unlock the settings panel by clicking on the padlock and entering your password. Select the PostgreSQL user and click on the minus button. Restore your shared memory settings: sudo rm /etc/sysctl.conf

completely uninstall postgresql 9.0.4 from Mac OSX Lion, Re: complete uninstall of postgres 9.0.4 completely new to both Mac OSX lion (​though not linux) and completely new > to postgres (though i  Désinstaller complètement PostgreSQL 9.0.4 de Mac OSX Lion? Cette question peut paraître comme un doublon de: Comment désinstaller postgresql sur mon Mac (fonctionnant sous Snow Leopard) cependant, il y a deux différences majeures.

Delete bookmarks mac lion installer : manual free on ughudy , How to reinstall macOS from macOS Recovery - Apple Support. Completely uninstall PostgreSQL 9.0.4 Lion - How do you remove Safari 6 on Mac OS X  How to brew uninstall postgres on OX Sierra. , I want to uninstall postgres completely with homebrew and uninstall PostgreSQL 9.0.4 from Mac OSX Lion?

Completely remove Postgres on Mac OSX Lion, How can I uninstall NetBeans on a mac? In later versions of Mac OS X, Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion? 433.

How completely uninstall PostgreSQL 9.X on Mac OSX This article is referenced from stackoverflow: If installed PostgreSQL with homebrew , enter brew uninstall postgresql If you used the EnterpriseDB installer , follow the following step.

Comments
  • tanks again @JamesA. do i need to remove anything manually in order to be sure the slate is wiped completely clean? You can check my latest update with the output of "sudo find"
  • also, is it adviseable to try and install using the "one click installer" found at postgres.org? (version 9.0.5)
  • @Ramy The brew uninstall command should clean up everything necessary. You could remove the /usr/local/var/postgres folder if it still exists prior to reinstalling if you want to make sure it's completely cleaned up. I don't work with Ruby so I can't offer any suggestions there.
  • @Ramy I found the EnterpriseDB one click installer to be a pain compared to the Homebrew installation.
  • well, i've installed postgres using the one-click installer. Everything seems to be kosher so far. thanks again for all your help, @JamesA
  • Currently 9.2 is the latest, replace '9.1' with '9.2' and this still works.
  • Awesome! I had to change the version number but other than that, spot on, and a huge SAVORE !
  • After uninstalling postgresql 9.2, Apache stopped working. sudo /usr/sbin/httpd give me dyld: Library not loaded: /usr/lib/libpq.5.dylib. To fix that quickly I created a link sudo ln -s /usr/lib/libpq.5.3.dylib /usr/lib/libpq.5.dylib
  • In that last step I could not find the sysctl.conf file. Perhaps this is no longer relevant with Postgres 9.4 as the shared memory is no longer reconfigured for a large size.
  • why is this such a nightmare
  • Thank you. saved my day!
  • brew list | grep postgres | xargs brew uninstall
  • @Fernando Munoz, I had 3 different versions installed and it would occasionally cause some strange issues. This allowed me to see and remove them all. Thanks!
  • @TimBiden I am glad that you were able to solve your problem.
  • most clean explanation. Thanks