BREW UNINSTALL POSTGRES HOW TO

After uninstalling, the server might still be running. Postgresql How to brew uninstall postgres on OX Sierra Start manually. If you are using version 9.4, the command would be: sudo port uninstall postgresql94-server. If you installed PostgreSQL using Brew and have problems with this installation, start by uninstalling PostgreSQL using Brew.

BREW UNINSTALL POSTGRES INSTALL

If your luck is as good as mine then you should have a fully working PostgreSQL install with your previous database(s). First use the installed command to determine which version of the PostgreSQL server you have installed: sudo port installed. Get the list of experts for PostgreSQL training in Edison, Read PostgreSQL training reviews, curriculum, class dates, course price and get registered for the sessions. $ pg_restore -no-acl -no-owner -d my_database my_database.dump $ launchctl load ~/Library/LaunchAgents/Ĭreate and restore the old database(s): $ createdb my_database Reinstall and start PostgreSQL: $ brew uninstall postgresql $ launchctl unload ~/Library/LaunchAgents/īetter to keep the existing data just in case this process needs to be rolled back: $ mv /usr/local/var/postgres somewhere/safe How to dump/restore databases and reinstall PostgreSQL on a Mac with Homebrewĭump any databases you wish to keep and stop PostgreSQL: $ pg_dump -Fc -no-acl -no-owner my_database > my_database.dump In the end I resorted to blatting the current install and starting again. I didn’t want to lose my local data and spent a long time failing to find a proper fix - I tried a quick reinstall but that didn’t work either. psql worked but psql -l would output the same error. By default, Postgres.app creates a database with the same name as your user name. A PostgreSQL server (cluster) can have multiple databases. All you need to do is click the Initialize button.

Also, there was a postgres database - though the postgres role didn’t appear to exist. By default, Postgres.app configures a server (cluster) with the latest supported version of PostgreSQL.

It was strange because most of my databases were working but a couple weren’t. I recently encountered a strange error with PostgreSQL on my development machine: psql: FATAL: database 'postgres' does not existĭETAIL: The database subdirectory 'base/12641' is missing.

Brew uninstall postgres