- You have to be on OSX 🍎
- Homebrew installed as dependency manager 🍺
This morning I was working on a project that I have to install Postgres. I was thinking to myself that it was a really easy thing and that it will take me 3 minutes (the time to run
brew install postgres and go grab a cup of tea in the open space)
BUT, it wasn't the case and I'm just facing with a weird issue. That's why I'm writing this article, maybe this could help someone and save your time.
- First, you have to run this brew command line
brew install postgres
- Just verify that the installation is successful
Now, you can run the command line to start Postgres
pg_ctl -D /usr/local/var/postgres start
If it works, you're lucky! But if you have
FATAL: database files are incompatible with server you're on the right post!
The solution was to run
brew postgresql-upgrade-database to upgrade your database files to the 11 version. You can have old database files who was initially created with the version 10 of Postgres. That's why you have an error.
Now you can rerun the command
pg_ctl -D /usr/local/var/postgres start and it should work like a charm 🎉
- You can also configure your Postgres! I have found a useful link who can help you : https://www.codementor.io/engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb#iv-popular-guis-for-postgresql-on-macosx