Postgis version 2.5.0 was released this weekend. I take this opportunity to sort the different versions (EOLed) .
As pgRouting has also been updated this weekend, I'm upgrading to a new version in this diff.
Details
Details
poudriere 11/12 i386/amd64
Diff Detail
Diff Detail
- Repository
- rP FreeBSD ports repository
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
Event Timeline
There are a very large number of changes, so older changes are hidden. Show Older Changes
| databases/postgis/Makefile | ||
|---|---|---|
| 64–65 ↗ | (On Diff #48454) | That's a no on flavors. The ports tree has a *default* postgresql version, only the default will be built. |
Comment Actions
If you want to add postgresql flavors, which is most certainly a bad idea, it should go in USES=pgsql.
It is a bad idea because the way postgresql works in the ports tree is bad and should be changed. We should only have one postgresql-client, most probably the latest version available, and everything, including the different versions of servers should use it. The only flavors should be for ports that need the server, and in any case, it should go in USES=pgsql.
| postgis/Makefile | ||
|---|---|---|
| 22 ↗ | (On Diff #48497) | Why += ? |
| 37 ↗ | (On Diff #48497) | Wrong place in the Makefile. See Chapter 15. Order of Variables in Port Makefiles. |
| 61–62 ↗ | (On Diff #48497) | USES=localbase |
| 80 ↗ | (On Diff #48497) | Remove this, and use options helpers. |
Comment Actions
Thank you, @mat.
Indeed, I also think there is some change to be made on the postgresql side. I had already started to create a USE for postgis before the existence of flavours, but which was not committeed at the time (and which I did not continue).
Here is my need, to be able to install pgrouting versions that can take the latest version of postgis and the versions of postgresql present (95, 96, 10) directly in the pkg, without the need to compile; ok, I can make packages with poudriere but if it is directly in the official pkg it was better.
Following your advice, I will propose a new one diff that removes flavors and does only the cleaning of postgis, its upgrade and the upgrade of pgrouting.
| databases/postgis/Makefile | ||
|---|---|---|
| 78 ↗ | (On Diff #49805) | D17320 in general works fine for me on a semi production box, many thanks. I wonder if the lib version should be something other than 0.0.0? This never changed in our PostGIS ports before. Looking into [1], PostGIS in its internal structures uses macros for it: #define LIBLWGEOM_VERSION "2.5.1dev" |
| databases/postgis/Makefile | ||
|---|---|---|
| 78 ↗ | (On Diff #49805) | Should be ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/liblwgeom-${VER}.so.${PORTVERSION} instead? |
Comment Actions
I don't quite understand the rationale here. According to https://postgis.net/source/, 2.3 and 2.4 are supported. Why remove them.
| databases/postgis/Makefile | ||
|---|---|---|
| 61 ↗ | (On Diff #49805) | Please, remove this, and use options target helpers. |
| databases/postgis/Makefile | ||
|---|---|---|
| 78 ↗ | (On Diff #49805) | To be honest, I am not an expert in library naming schemes. For me, it seems ok. |
Comment Actions
I had made a proposal to be able to have a postgis USE to select the version we want but it was never followed (except rainer ;) ).
What I would like is to be able to have packages postgresql10-postgis25 postgresql95-postgis25 ... postgresql10-postgis24, postgresql95-postgis24... etc. ala debian, but I don't think this is feasible and what about maintainability?
In any case, I doubt that there is a real need to maintain several versions of postgis concurrently. Rainer, what's your opinion?
If you think we should leave the other ports, I will. On the other hand, all ports that must depend on postgis will depend on the latest current version.
I also recommend that a "pkg install postgis" install the latest version.
| databases/postgis/Makefile | ||
|---|---|---|
| 78 ↗ | (On Diff #49805) | If I'm not wrong, it's generated in a file. You should leave it like that. see https://github.com/postgis/postgis/blob/svn-trunk/Version.config#L10 |
Comment Actions
[..snip..]
In any case, I doubt that there is a real need to maintain several versions of postgis concurrently. Rainer, what's your opinion?
If you think we should leave the other ports, I will. On the other hand, all ports that must depend on postgis will depend on the latest current version.
I also recommend that a "pkg install postgis" install the latest version.
I would be fine with having only one PostGIS version for all PostgreSQL versions. Version 2.5 will work with all existing PostgreSQL versions except of 9.3, which is EOL now[1].
On the other hand, there are several older versions already installed. For these versions, the users have to migrate their PostGIS data to the newer version 2.5. This migration can be painful with complex data ...
Another problem could be, that future versions of PostgreSQL on FreeBSD again will need two PostGIS versions, e.g. 2.5 and 3.x
[1] https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
Comment Actions
[..snip..]
I would be fine with having only one PostGIS version for all PostgreSQL versions. Version 2.5 will work with all existing PostgreSQL versions except of 9.3, which is EOL now[1].On the other hand, there are several older versions already installed. For these versions, the users have to migrate their PostGIS data to the newer version 2.5. This migration can be painful with complex data ...
mmm... I agree with you. OK to let all versions still supported upstream. But pgrouting and (others?) will be linked by default with the latest version of PostGIS.
Another problem could be, that future versions of PostgreSQL on FreeBSD again will need two PostGIS versions, e.g. 2.5 and 3.x
These are two major versions, so for me, it doesn't cause me any problems to have these two versions together.
[1] https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
Comment Actions
Hi Loïc,
Yes, for me, it seems ok. I am fine with your changes.
Thanks for your work, really appreciated.
| databases/postgis/Makefile | ||
|---|---|---|
| 20 ↗ | (On Diff #50648) | Wrong place in the Makefile. See Chapter 15. Order of Variables in Port Makefiles. |
| 37 ↗ | (On Diff #50648) | Why +=? |
| 56–57 ↗ | (On Diff #50648) | Wrong place in the Makefile. |
| databases/postgis/pkg-install | ||
| 25–27 ↗ | (On Diff #50648) | I really do not like this. |
Comment Actions
Beside the in-line comment:
- You could save some lines with "${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/*" in post-install:.
- Please fix %%PORTVERSION%% substitution in PLIST, e.g. "%%ADDRSTD%%share/postgresql/extension/address_standardizer--%%PORTVERSION%%--2.5.0next.sql".
- Please sort PLIST.
Thank you for your hard work on postgis.
| MOVED | ||
|---|---|---|
| 10531–10533 ↗ | (On Diff #50648) | Please use databases/postgis for the second field. |
| databases/postgis/Makefile | ||
| 7 ↗ | (On Diff #50648) | It should be https://download.osgeo.org/postgis/source/ |
| 22 ↗ | (On Diff #50648) | According to PostGIS Support Matrix, PostGIS 2.5 supports pgsql:9.4+. |
| 48–49 ↗ | (On Diff #50648) | It is SFCGAL_CONFIGURE_WITH=sfcgal=${LOCALBASE}/bin/sfcgal-config |
| 53–54 ↗ | (On Diff #50648) | Please remove it if not needed. |
| 56–57 ↗ | (On Diff #50648) | Is it still needed when you have USES=localbase already? |
| 59 ↗ | (On Diff #50648) | Since you use it in the Makefile, please also use it in PLIST via PLIST_SUB for consistency, e.g. lib/liblwgeom-2.5.so.0.0.0. |
| databases/postgis/pkg-descr | ||
| 15 ↗ | (On Diff #50648) | Please use https://postgis.net/ |
| databases/postgis/pkg-install | ||
| 1–37 ↗ | (On Diff #50648) | Is it needed? The hard-coded stdc++ in geos has been removed in its Makefile. |
| databases/postgis/Makefile | ||
|---|---|---|
| 62 ↗ | (On Diff #50648) | This seems dubious, PRE-INSTALL is what gets shown when the package is being installed, just before the installation. I do not see how things could be needed to be done twice, once before configure runs, and once before the package is installed. |
Comment Actions
Thank you mat and sunpoet.
I corrected the different points and deleted the pkg-install file which was obsolete (thanks sunpoet).
Comment Actions
LGTM. BTW, it would be great to sort USES, e.g. USES=... pgsql pkgconfig ...
Thanks for your work!
| databases/postgis/Makefile | ||
|---|---|---|
| 67–72 ↗ | (On Diff #52068) | Similar to stripping bin/*, these can be merged to post-install: as "${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so" |
Comment Actions
On the contrary, I have changed this logic so that the latest version is simply called "postgis". This simplifies the updating of the ports that depend on it and you can install the latest version without worrying about the version number.
The only disadvantage to this is that in case of package updates, it will be necessary to update the database with the new extension. What do you think about that @rhurlin_gwdg.de ?
Comment Actions
Hi Loïc,
I also tend to simplifying the name of the latest postgis ports version. The problem is, as you said before, that 'automated' updates like with pkg, poudriere, portmaster etc. do not point out, that a second step like 'ALTER EXTENSION postgis* UPDATE' is necessary.
It is something like updating PostgreSQL itself and doing a dump before and a restore after the update, or pg_upgrade, depending on the situation.
It would be nice to have a really good message for users after the PostGIS update process is done. This is often tricky, because several databases could need this ALTER EXTENSION, accessible by different users. But this is also the case with a PostGIS port, numbered by its version (e.g. postgis25).
Perhaps, something like a user tunable knob and a mechanism for automated post upgrade steps could be of interest here?
Comment Actions
Hi rainer,
It's a good idea and I think it should be complementary to https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=213038
For this tour, I propose to stay on the name "postgis25" in order to merge it and we look at that in another ticket.
Comment Actions
Remove core, the herald rule was over broad.
Personal note: I'm unconvinced the triggering text "GNU General Public License" belongs in pkg-descr.
Comment Actions
Personal note: I'm unconvinced the triggering text "GNU General Public License" belongs in pkg-descr.
This pkg-descr was here before me, I can change it, but please I would like to do it in another PR to update all Postgis ports.