How can I upgrade my PostgreSQL server? I've installed the latest client version with homebrew.
$ psql (9.6.1, server 9.5.4) My server is in 9.5.4 version.
How can I upgrade it to 9.6 ?
OS: MacOS
-
stackoverflow.com/a/27624397/3270427McNets– McNets2016-12-02 21:16:31 +00:00Commented Dec 2, 2016 at 21:16
-
The example is a little bit complicated. I'll post now the good answer. Anyway thanks for your comment @mcNetsShahen Hovhannisyan– Shahen Hovhannisyan2016-12-02 21:33:08 +00:00Commented Dec 2, 2016 at 21:33
-
usually you can upgrade a minor version by simply copying new binariesMcNets– McNets2016-12-02 21:34:05 +00:00Commented Dec 2, 2016 at 21:34
-
packtpub.com/big-data-and-business-intelligence/…McNets– McNets2016-12-02 21:35:53 +00:00Commented Dec 2, 2016 at 21:35
Add a comment
|
1 Answer
I found answer to my question.
For the first we should uninstall posrgresql
$ brew uninstall postgresql
Then we should remove db files
$ rm -rf /usr/local/var/postgres
After that we should remove Cellar data
$ rm -rf /usr/local/Cellar/postgresql
And after removing all files we can start to install new version
$ brew install postgresql
If service will not run automatically we can start it just typing the following
$ brew services start postgresql
That's all !