#Postgres app mac how to#
#Postgres app mac install#

Install PostgreSQL back via brew is very simple, it has two steps: # 1. Long story short, it is true at least in my case, it solved the problem. And we suspect that there’s a difference between PostgreSQL installed via installer and PostgreSQL installed via brew. The reason I need to uninstall PostgreSQL is that I couldn’t use the same code my coworker was using when I need to create a test database.

#Postgres app mac how to#

How to reinstall PostgreSQL back via brew 🍺 🎉🎉🎉 Hooray! We successfully uninstalled PostgreSQL 13.3!!Ģ. You can try if you'd like $ sudo rm /etc/nf rm: /etc/nf: No such file or directory Step 3: remove Postgres related files # change to home directory $ cd ~ $ sudo rm -rf /Library/PostgreSQL $ sudo rm /etc/postgres-reg.ini # some people also suggested to remove nf # but I don't seem to have this file in my environment # so I ignored it. Important note: after you followed the above guide, all the way until Fig 8, we are not done yet! In order to remove all the Postgres related files, you need step 3. The uninstallation window prompted! If this works for you too, you can follow this guide on section until Fig 8. It’s such a small change but it worked! 🤩 # change directory $ cd /Library/PostgreSQL/13 $ open uninstall-postgresql.app Out of desperation, I accidentally discovered solution 2B. I received an error message: $ open uninstall-postgres.app The file /Library/PostgreSQL/13/uninstall-postgres.app does not exist.Īfter trying many other methods online, though none seemed to lead to fruition, I noticed an interesting pattern, that is → for the same function, some people would use postgres, and other people would use postgresql. However, this solution didn’t work for me. If the Uninstallation window prompt, you can follow this guide on section. # change directory $ cd /Library/PostgreSQL/13 $ open uninstall-postgres.app

Step 2: Depending on whether the uninstall-postgres.app is installed, we have two solutions.Ĭhange the directory to run uninstall-postgres.app This app is located upper directory of the bin folder, which in my case it is /Library/PostgreSQL/13. In my case, it is installed under /Library/PostgreSQL/13/bin/psql # check version $ postgres -version postgres (PostgreSQL) 13.3 # locate where it is installed $ which psql /Library/PostgreSQL/13/bin/psql Check installed version as well as location. Test to see if it’s working: create database, user, and grant privileges.How to reinstall PostgreSQL back via brew.For anyone who needs to completely uninstall PostgresSQL 13.3, which was installed via the installer.