Postgresql mac os uninstall

How to uninstall PostgreSQL

PostgreSQL is a powerful open source database system that leverages and extends the SQL language, combined with a host of features to securely store and scale the most complex data workloads. PostgreSQL has tons of various features designed to help developers build applications, administrators protect data integrity and create resilient environments, and help manage data regardless of dataset size.

PostgreSQL is not typically problematic, but if you are experiencing some issues with it, it is recommended to reinstall the application instead of trying to fix the problem. Thus, here we are going to explain how to uninstall PostgreSQL from a Mac computer easily and quickly.

This is a special uninstaller that will help you to completely uninstall any application from Mac along with their caches, logs, login items, preferences and browsers extensions.

How to remove PostgreSQL using Terminal

Deleting PostgreSQL just by dragging-and-dropping it into the Trash is not the correct way to uninstall apps. In this case, all the Postgre system service files will remain on your computer and keep cluttering up your disk space. Meaning, they will not let you correctly reinstall the app in the future.

To manage the complete Postgre uninstallation first of all, you should stop the Postgres server on your Mac. For this, click on the Elephant icon in the toolbar and select Shutdown server

If you installed Postgres with its Installer, then you can use the Terminal command line to remove Postgres. For this, go to the Applications folder, open Utilities subfolder, and launch Terminal. After that run the uninstaller using the following command:

Or try this one

If you get the message that this file does not exist, then skip to the second PostgreSQL removal way. If the command runs the uninstaller, proceed to the next steps.

Enter the administrator password to launch the uninstaller. Then follow the provided steps to remove the PostgreSQL and data folders.

Unfortunately, the root uninstaller doesn’t delete all service files of the program, so you will need to remove them manually. For this, use the commands below:

1. Remove the ini file:
   sudo rm /etc/postgres-reg.ini
2. Remove the PostgreSQL folder from the system Library:
   sudo rm -rf /Library/PostgreSQL
3. Remove the PostgreSQL user. Go to System Preferences → Users & Groups → click the Lock icon and enter the administrator password to unlock settings → select the PostgreSQL and click the “-” icon.
4. Restore your shared memory settings using this command: sudo rm /etc/sysctl.conf

That’s all with the first method of removal. If for some reason this method does not work for you or you simply do not want to waste your time we recommend to uninstall PostgreSQL with the App Cleaner & Uninstaller tool, which will automatically find all support files of PostgreSQL and remove the application entirely. Keep reading this article to find out more about this tool.

The easiest way to remove PostgreSQL from Mac

Uninstalling PostgreSQL with Terminal may be a really time-consuming process. Moreover, you might have missed some service files and left them on your Mac’s hard drive. That’s why we recommend that you uninstall PostgreSQL automatically.

For the automatic uninstallation method, you need to use a special free cleanup application – App Cleaner & Uninstaller. This software automatically gathers all the service files of each app and allows you to uninstall them with one click. With this uninstaller, you can uninstall PostgreSQL without any extra steps and it will not take much of your time. Here are a few steps to do that:

1. Download App Cleaner & Uninstaller and launch it.
2. Confirm access to your Applications folder and it will start scanning it to find the installed apps on your Mac. Then you will see a list of apps in the left section of the application window. Find and select the PostgreSQL folder. In the right section, you can preview all executable files, support files, cache and all types of file related to PostgreSQL.
3. Click the Remove button and confirm the removal of the selected files.

Note that App Cleaner & Uninstaller automatically detects all the support files of the apps, so you don’t need to waste your time searching and removing them manually. That is why if you have already deleted PostgreSQL in a regular way, just by dragging-and-dropping it into the Trash, we recommend you to switch to the Remaining Files tab. That section will display all the leftovers of previously incorrectly deleted applications. So that is the perfect option to quickly get some free space.

Conclusion

In this article, we provided you with two ways of uninstalling PostgreSQL from Mac. You can uninstall it manually using the Terminal, which is a time-consuming task or you can follow the instruction of automatic uninstallation. Nektony recommends using a professional App Cleaner & Uninstaller tool. This application was developed specially for fast, safe, and complete uninstallation of any no longer needed application.

App Cleaner & Uninstaller

Uninstall any Mac application in 2 minutes.

Источник

How to Uninstall/Reinstall PostgreSQL (Mac)

Other Guides

Table of Contents

This guide is for the rare situations when using Apple’s OS X when you need to completely reinstall the PostgreSQL Server when advised by PokerTracker technical support. Following these instructions will delete all databases from your computer, we advise that you backup your databases prior to performing a total reinstall. These instructions require you to type command line instructions within the OS X Terminal, you will usually find the Terminal inside the /Applications/Utilities.

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/

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 PokerTracker 4 and PostgreSQL using the PokerTracker 4 installer, or manually install the latest version of PostgreSQL found at http://postgresql.org

If you have any issues, please contact PokerTracker support for assistance.

Источник

How to Uninstall PostgreSQL with Homebrew (macOS)

Learn how to completely uninstall (and reinstall) PostgreSQL with Homebrew on Mac.

If you’re having problems starting up your PostgreSQL databases running on Homebrew, such as the classic:

You can try restarting PostgreSQL services:

But that often doesn’t work.

Sometimes the fastest way to solve the problem by uninstalling PostgreSQL entirely, and reinstalling a fresh version.

Uninstall PostgreSQL with Homebrew

This will show you how to completely remove PostgreSQL with Homebrew.

Warning: If you have any important projects on your machine that run on PostgreSQL databases, now is the time to back them up, because the following will wipe out PostgreSQL completely!

First Open your Terminal, and run the following command to make sure that PostgreSQL is actually installed with Homebrew:

If it doesn’t show up, you’re in the wrong tutorial!

Before you move on, run the following two commands to make sure that your Homebrew installation is healthy, and up to date:

brew doctor is Homebrew’s self-diagnosis tool.

Now uninstall PostgreSQL with Homebrew with this command:

When the uninstaller is finished, remove all your local PostgreSQL files with these two commands:

PostgreSQL is now completely gone from your machine.

Install PostgreSQL with Homebrew

If you want to reinstall PostgreSQL with Homebrew again, run another update on Homebrew (for good measure):

I know you just updated Homebrew, but sometimes I have to do it twice to make it work (I don’t know why).

And then install PostgreSQL:

Now you can start PostgreSQL services with this command:

To test that it works, we can create the default database:

Connect to PostgreSQL by running this command:

If everything went well your terminal will output the following (or similar):

Has this been helpful to you?

You can support my work by sharing this article with others, or perhaps buy me a cup of coffee 😊

Источник

Как я могу полностью удалить Postgres со своего Mac?

После использования программы установки Mac для Postgres у меня возникало жуткое поведение с Postgres. Похоже, что существует уже наполовину запеченная установка Postgres, которая уже была там и остается там после того, как я удалил версию установщика Mac GUI из /Applications и /Library. Часть пугающего поведения заключалась в том, что после неоднократного тычка и подталкивания невозможно было заставить конкретного пользователя проходить аутентификацию в соответствии с его поведением — но это имеет смысл, если у меня было две параллельные базы данных Postgres, одна для которых я (успешно) настраивал пользователя с помощью конкретный пароль, и тот, который не был установлен этой базы данных. Теперь, когда эта версия удалена, у меня есть несколько двоичных файлов Postgres, которые вылетают или выдают ошибки, если я пытаюсь их использовать:

Я не использовал MacPorts, Fink или другие инсталляторы Unix, кроме Homebrew, в жизни этого Mac. Homebrew отказывается от права собственности на установку Postgres:

Поэтому, несмотря на то, что я установлен, у меня сломана установка Postgres, которую я хотел бы полностью стереть

Как я могу полностью стереть Postgres из моей системы, чтобы я мог установить его с помощью установщика и получить одну установку Postgres вместо жутких полутора установок?

2 ответа 2

Похоже, вы только что удалили несколько файлов в Finder.

Предполагая, что вы использовали установщик отсюда, вы должны следовать инструкциям в руководстве по удалению:

Пробные

Если вам нужно удалить PostgreSQL, вы можете в любое время запустить деинсталлятор, созданный в процессе установки. Обратите внимание, что деинсталлятор никогда не удалит ваш каталог данных или учетную запись пользователя службы. Вы можете найти деинсталлятор в установочном каталоге и запустить его так же, как вы запустили инсталлятор. Обычно параметры командной строки не требуются. В Windows вы также можете запустить деинсталлятор из панели управления «Установка и удаление программ».

Другими словами, просто запустите деинсталлятор, установленный вместе с остальной частью программы.

После запуска любых деинсталляторов, следующее должно помочь вам найти любые оставшиеся файлы конфигурации или конфигурации SQL в вашем каталоге Library (общий источник странного поведения переустановки)

/Library | grep sql

Если там есть что-то, что выглядит как часть установки PostgreSQL, удаление их перед переустановкой может помочь. Иногда там скрытые папки скрыты глубже.

Кроме того, ls -l /usr/bin/psql должен предоставлять любые символические ссылки, если они есть, в случае, если приложение psql размещено в другом каталоге.

Источник

How To Uninstall Postgres (PostgreSQL) on Mac

By Tasnia Salinas, on January 01, 2021, in Mac Uninstaller

Summary: In this article, we help you to learn How To Completely Uninstall PostgreSQL Database System on Mac by using our best PostgreSQL Uninstaller software — Omni Remover. Make sure you have downloaded the latest version here before continuing.

What Is PostgreSQL Music Making Software? PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS). PostgreSQL is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users (How To Uninstall Python 3.7 on Mac). It is the default database for macOS Server, and is also available for Linux, FreeBSD, OpenBSD, and Windows.

Why uninstalling PostgreSQL on Mac? PostgreSQL is not typically problematic but it’s worth mentioning that Postgres.app can’t start when another server is already running on the same port (default: 5432). We recommend to uninstall other PostgreSQL installations before using Postgres.app. In this article, we’ll show how to completely PostgreSQL/Postgre on macOS Mojave (Easy Method To Uninstall Audiomack on Mac).

Table of Content:

Part 1: How To Uninstall PostgreSQL on Mac Manually

PostgreSQL is available for closely most of main stream operating systems, including Linux, Windows, macOS, etc. For OS X, you can easily remove PostgreSQL by dragging it to trash folder. However, this basic method will leave tons of PostgreSQL leftover junk on your Mac. Follow steps below to learn how to completely uninstall PostgreSQL on Mac (How To Manually Uninstall MySQL on Mac OS X).

Step 1: First up, shutdown PostgreSQL server and terminate all PostgreSQL processing threads in Activity Monitor. Open Finder app on Mac > Applications > PostgreSQL > Move PostgreSQL to Trash:

Part 2: How To Clean Uninstall PostgreSQL on Mac [Time-Saving Method]

In addition to remove PostgreSQL manually, it’s suggested to rely on a reliable PostgreSQL Removal app to ensure the clean uninstall. Omni Remover is an expert PostgreSQL Uninstaller software that can help uninstall PostgreSQL and other stubborn applications on your Mac. Here are the detailed steps about how to uninstall PostgreSQL with Omni Remover. Free Download

Step 1:

Click here to download Omni Remover > Install and Open Omni Remover on your Mac.

Step 2:

In Omni Remover > App Uninstall > Choose PostgreSQL Client icon > Clean Uninstall.

Step 3:

Then Omni Remover will start scanning all PostgreSQL Client data/files > After it finished scanning, click Clean Uninstall to start removing PostgreSQL Client from your Mac.

The Bottom Line

Have uninstalled PostgreSQL/Postgre on your Mac with our suggestions above? Feel free to drop a line to us if you have any questions. Apart from uninstall PostgreSQL and other stubborn applications on Mac, Omni Remover is also capable of freeing up storage space on your Mac. Give it a try here: Free Download Now >

Источник