{"id":2984,"date":"2020-03-02T15:28:44","date_gmt":"2020-03-02T21:28:44","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=2984"},"modified":"2020-03-02T15:28:44","modified_gmt":"2020-03-02T21:28:44","slug":"how-to-completely-uninstall-postgresql","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=2984","title":{"rendered":"How To Completely Uninstall PostgreSQL"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

If you\u2019re using PostgreSQL, you may need to remove the package from your system at some point. It\u2019s important to know how to uninstall PostgreSQL properly to make sure all components of the package are completely removed and you don\u2019t encounter any errors. In this article, we\u2019ll explain how to uninstall PostgreSQL from Linux, macOS and Windows operating systems.<\/p>\n\n\n\n

NOTE:<\/em><\/strong> Be sure to elevate the privileges for any of the commands in this article with sudo<\/code> if the terminal returns a Permission denied<\/code> error.<\/p>\n\n\n\n

Uninstall and remove PostgreSQL on Debian Linux<\/h2>\n\n\n\n

You can use the apt-get<\/code> command to completely remove PostgreSQL on a Debian-based distribution of Linux such as Linux Mint or Ubuntu:<\/p>\n\n\n\n

1
2
3
<\/td>		sudo apt-get –purge remove postgresql
sudo apt-get purge postgresql*
sudo apt-get –purge remove postgresql postgresql-doc postgresql-common<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Grep for all PostgreSQL packages in Debian Linux<\/h3>\n\n\n\n

You can use the dpkg<\/code> command for managing Debian packages, in conjunction with grep<\/code>, to search for all<\/em> the package names installed that contain the sub-string postgres<\/code>. An example of this command is shown below:<\/p>\n\n\n\n

1
<\/td>		dpkg -l | grep postgres<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Finally, make sure to use the APT-GET repository\u2019s --purge remove<\/code> command, followed by the postgres<\/code> package name. This command will remove the package and purge all the data associated with it:<\/p>\n\n\n\n

1
<\/td>		sudo apt-get –purge remove {POSTGRESS-PACKAGE NAME}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Remove all of the PostgreSQL data and directories<\/h3>\n\n\n\n

Use the rm<\/code> command with the -rf<\/code> options to recursively remove all of the directories and data for the postgresql<\/code> packages:<\/p>\n\n\n\n

1
2
3
<\/td>		sudo rm -rf \/var\/lib\/postgresql\/
sudo rm -rf \/var\/log\/postgresql\/
sudo rm -rf \/etc\/postgresql\/<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\"Screenshot<\/figure>\n\n\n\n

After you complete your rm<\/code> commands, execute the dpkg -l | grep postgres<\/code> command one more time to verify that all of the packages have been removed.<\/p>\n\n\n\n

Uninstall and remove PostgreSQL packages on Fedora Linux<\/h2>\n\n\n\n

You can use the YUM repository\u2019s yum<\/code> command to uninstall PostgreSQL on Fedora-based distributions of Linux such Red Hat or CentOS:<\/p>\n\n\n\n

1
<\/td>		yum remove postgresql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

To use a wildcard operator (*<\/code>) to remove all<\/em> packages with names beginning with postgres<\/code>, use the following command:<\/p>\n\n\n\n

1
<\/td>		yum remove postgres\\*<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Be sure to remove the pgsql<\/code> directory as well:<\/p>\n\n\n\n

1
<\/td>		rm \/var\/lib\/pgsql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

NOTE:<\/em><\/strong> Keep in mind that sudo<\/code> is not enabled for RHEL users by default. Instead, use the su<\/code> (switch user) command to enter as root<\/code> and execute the above commands with elevated privileges if necessary.<\/p>\n\n\n\n

Grep for the PostgreSQL packages in Fedora using \u2018rpm\u2019<\/h3>\n\n\n\n

You can use the rpm<\/code> command with the -qa<\/code> options to grep for any packages that contain \u201cpostgres\u201d in their name:<\/p>\n\n\n\n

1
<\/td>		rpm -qa | grep postgres<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

If you prefer, you can shorten the search to something like post<\/code> as well:<\/p>\n\n\n\n

1
<\/td>		rpm -qa | grep post<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\"Screenshot<\/figure>\n\n\n\n

You can also use grep<\/code> in conjunction with YUM\u2019s list<\/code> command to return a list of all package instances of PostgreSQL:<\/p>\n\n\n\n

1
<\/td>		yum list installed | grep postgres<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Uninstall the PostgreSQL package using YUM remove<\/h3>\n\n\n\n

Once you\u2019ve located the package, use YUM\u2019s remove<\/code> command to uninstall PostgreSQL from your Linux system:<\/p>\n\n\n\n

1
<\/td>		yum remove {POSTGRESS-PACKAGE NAME}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Navigate to the assigned directory for the PostgreSQL data, and then use the rm<\/code> command to delete all of your databases and tables.<\/p>\n\n\n\n

Uninstall and remove PostgreSQL from Windows<\/h2>\n\n\n\n

If you\u2019re using Windows, type uninstall<\/code> or remove<\/code> into the search bar at the bottom left-hand side of the screen:<\/p>\n\n\n\n

\"Screenshot<\/figure>\n\n\n\n

Then, follow the steps for the removal process, making sure to select the \u201cEntire Components option when prompted.<\/p>\n\n\n\n

You\u2019ll see a pop-up stating something like: The data directory s(C:\\Program Files\\PostgreSQL\\11\\data) has not been removed<\/code>. Simply click \u201cOK\u201d to close the pop-up window, and do not<\/strong> select the option to restart your PC.<\/p>\n\n\n\n

Delete the data folder for PostgreSQL in Windows<\/h3>\n\n\n\n

After you\u2019ve completed the removal process described in the previous section, open File Explorer for Windows and navigate to the data<\/code> folder. Right-click the data folder and click the Delete button. Be sure to empty the recycle bin afterwards to ensure that any sensitive data has been properly deleted.<\/p>\n\n\n\n

\"Screenshot<\/figure>\n\n\n\n

After all of the data has been deleted, you should restart Windows 10.<\/p>\n\n\n\n

Uninstall and remove PostgreSQL on macOS<\/h2>\n\n\n\n

To uninstall PostgreSQL on macOS, open a new instance of Finder and navigate to the Applications directory. Look for the PostgreSQL folder and drag its contents to the Trash application folder in macOS.<\/p>\n\n\n\n

\"Screenshot<\/figure>\n\n\n\n

Remove the PostgreSQL data in a terminal in macOS<\/h3>\n\n\n\n

After you\u2019ve removed the PostgreSQL folder, open the Utilities folder in a Finder window, and then open the Terminal application.<\/p>\n\n\n\n

\"Screenshot<\/figure>\n\n\n\n

Use the cd<\/code> command to navigate to the PostgreSQL<\/code> directory. You can do this by typing the directory path into the terminal prompt and pressing Return:<\/p>\n\n\n\n

1
<\/td>		cd \/Library\/PostgreSQL\/11<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Then, use the rm -rf<\/code> command to remove the directory and its contents:<\/p>\n\n\n\n

1
<\/td>		sudo rm -rf<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Don\u2019t forget to empty the Trash application\u2019s contents when you are finished.<\/p>\n\n\n\n

Uninstall the Homebrew installation of PostgreSQL on macOS<\/h3>\n\n\n\n

You can use the brew<\/code> command in a macOS terminal window to remove the Homebrew version of PostgreSQL. First, use the list<\/code> command to return all of the applications installed using Homebrew:<\/p>\n\n\n\n

1
<\/td>		brew list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Then, use the following command to force the removal the Homebrew installation of postgresql<\/code>:<\/p>\n\n\n\n

1
<\/td>		brew uninstall –force postgresql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

If you find yourself needing to uninstall PostgreSQL, it\u2019s important to do a careful and thorough job. Taking shortcuts when it comes to the removal process can leave sensitive data remaining on your machine. In this article, we explained how to uninstall and remove PostgreSQL from Windows, Linux and macOS. With the step-by-step instructions detailed in this tutorial, you\u2019ll be ready to remove PostgreSQL from any of your own machines.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction If you\u2019re using PostgreSQL, you may need to remove the package from your system at some point. It\u2019s important to know how to uninstall PostgreSQL properly to make sure all components of the package are completely removed and you don\u2019t encounter any errors. In this article, we\u2019ll explain how to uninstall PostgreSQL from Linux, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-2984","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2984"}],"version-history":[{"count":1,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2984\/revisions"}],"predecessor-version":[{"id":2985,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2984\/revisions\/2985"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}