As there are two ways to solve this question, I asked for another approach here.
Whenever a major release of PostgreSQL appears, homebrew will happily install it right away, unless one pins a certain version or installs a specific version from Homebrew/core.
So far so good, but the problem is that PostGIS also keeps updating and eventually will be incompatible with pinned or Homebrew/core versions of PostgreSQL. Again, one can pin PostGIS, yet Homebrew/core does not offer previous versions. From time to time I do brew cleanup and somehow I am now left with a broken PostGIS database. Ok, so "time to jump to PostgreSQL 10.1", I though, but pg_upgrade now gets stuck with the error
ERROR: could not access file "$libdir/postgis-2.3": No such file or directory
That means I can't back nor forth: I cannot figure out how to get PostGIS working with postgresql@9.6 and I cannot pg_upgrade to the new version of PostgreSQL (10.1).
Therefore my question can be answered in two ways. Here I am asking:
How to install PostGIS with older PostgreSQL versions, i.e. postgresql@9.6, using homebrew?
The second approach is described at Upgrading PostgreSQL with broken PostGIS installation ("$libdir/postgis-2.3" error)?
Tried so far:
- This gist offers a solution and it might actually work. However, I had to use
ln -sinstead ofcp -a. It seems to be working now, but unfortunately I have the problem that my database is already on 2.4 and there seems to be no downgrade path. Will keep trying.
No comments:
Post a Comment