notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
postgis25 Geographic objects support for PostgreSQL databases
2.5.4_2 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port 2.5.3Version of this port present on the latest quarterly branch.
Maintainer: lbartoletti@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2019-03-15 00:47:20
Last Update: 2020-05-22 20:20:42
SVN Revision: 536219
Also Listed In: geography
License: GPLv2
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (431 items)
  1. @ldconfig
  2. /usr/local/share/licenses/postgis25-2.5.4_2/catalog.mk
  3. /usr/local/share/licenses/postgis25-2.5.4_2/LICENSE
  4. /usr/local/share/licenses/postgis25-2.5.4_2/GPLv2
  5. bin/pgsql2shp
  6. bin/raster2pgsql
  7. bin/shp2pgsql
  8. @comment bin/shp2pgsql-gui
  9. include/liblwgeom.h
  10. include/liblwgeom_topo.h
  11. lib/liblwgeom-2.5.so.0
  12. lib/liblwgeom-2.5.so.0.0.0
  13. lib/liblwgeom.a
  14. lib/liblwgeom.la
  15. lib/liblwgeom.so
  16. lib/postgresql/address_standardizer.so
  17. lib/postgresql/postgis-2.5.so
  18. lib/postgresql/postgis_topology-2.5.so
  19. lib/postgresql/rtpostgis-2.5.so
  20. share/doc/postgresql/extension/README.address_standardizer
  21. share/postgis/tiger_geocoder/COPYING
  22. share/postgis/tiger_geocoder/README
  23. share/postgis/tiger_geocoder/create_geocode.bat
  24. share/postgis/tiger_geocoder/create_geocode.sh
  25. share/postgis/tiger_geocoder/create_geocode.sql
  26. share/postgis/tiger_geocoder/geocode/census_tracts_functions.sql
  27. share/postgis/tiger_geocoder/geocode/geocode.sql
  28. share/postgis/tiger_geocoder/geocode/geocode_address.sql
  29. share/postgis/tiger_geocoder/geocode/geocode_intersection.sql
  30. share/postgis/tiger_geocoder/geocode/geocode_location.sql
  31. share/postgis/tiger_geocoder/geocode/includes_address.sql
  32. share/postgis/tiger_geocoder/geocode/interpolate_from_address.sql
  33. share/postgis/tiger_geocoder/geocode/other_helper_functions.sql
  34. share/postgis/tiger_geocoder/geocode/rate_attributes.sql
  35. share/postgis/tiger_geocoder/geocode/reverse_geocode.sql
  36. share/postgis/tiger_geocoder/geocode_settings.sql
  37. share/postgis/tiger_geocoder/legacy_import/tiger2008/import_tiger_shps.sh
  38. share/postgis/tiger_geocoder/normalize/count_words.sql
  39. share/postgis/tiger_geocoder/normalize/end_soundex.sql
  40. share/postgis/tiger_geocoder/normalize/get_last_words.sql
  41. share/postgis/tiger_geocoder/normalize/location_extract.sql
  42. share/postgis/tiger_geocoder/normalize/location_extract_countysub_exact.sql
  43. share/postgis/tiger_geocoder/normalize/location_extract_countysub_fuzzy.sql
  44. share/postgis/tiger_geocoder/normalize/location_extract_place_exact.sql
  45. share/postgis/tiger_geocoder/normalize/location_extract_place_fuzzy.sql
  46. share/postgis/tiger_geocoder/normalize/normalize_address.sql
  47. share/postgis/tiger_geocoder/normalize/pprint_addy.sql
  48. share/postgis/tiger_geocoder/normalize/state_extract.sql
  49. share/postgis/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
  50. share/postgis/tiger_geocoder/pagc_normalize/pagc_tables.sql
  51. share/postgis/tiger_geocoder/regress/geocode_regress
  52. share/postgis/tiger_geocoder/regress/geocode_regress.sql
  53. share/postgis/tiger_geocoder/regress/normalize_address_desired_regress
  54. share/postgis/tiger_geocoder/regress/normalize_address_regress
  55. share/postgis/tiger_geocoder/regress/normalize_address_regress.sql
  56. share/postgis/tiger_geocoder/regress/pagc_normalize_address_desired_regress
  57. share/postgis/tiger_geocoder/regress/pagc_normalize_address_regress
  58. share/postgis/tiger_geocoder/regress/pagc_normalize_address_regress.sql
  59. share/postgis/tiger_geocoder/regress/regress.sql
  60. share/postgis/tiger_geocoder/regress/reverse_geocode_regress
  61. share/postgis/tiger_geocoder/regress/reverse_geocode_regress.sql
  62. share/postgis/tiger_geocoder/tables/lookup_tables_2011.sql
  63. share/postgis/tiger_geocoder/tiger_loader_2011.sql
  64. share/postgis/tiger_geocoder/tiger_loader_2012.sql
  65. share/postgis/tiger_geocoder/tiger_loader_2013.sql
  66. share/postgis/tiger_geocoder/tiger_loader_2014.sql
  67. share/postgis/tiger_geocoder/tiger_loader_2015.sql
  68. share/postgis/tiger_geocoder/tiger_loader_2016.sql
  69. share/postgis/tiger_geocoder/tiger_loader_2017.sql
  70. share/postgis/tiger_geocoder/topology/README
  71. share/postgis/tiger_geocoder/topology/tiger_topology_loader.sql
  72. share/postgis/tiger_geocoder/upgrade_geocode.sql
  73. share/postgis/tiger_geocoder/upgrade_geocoder.bat
  74. share/postgis/tiger_geocoder/upgrade_geocoder.sh
  75. share/postgis/tiger_geocoder/utility/cull_null.sql
  76. share/postgis/tiger_geocoder/utility/levenshtein_ignore_case.sql
  77. share/postgis/tiger_geocoder/utility/nullable_levenshtein.sql
  78. share/postgis/tiger_geocoder/utility/set_search_path.sql
  79. share/postgis/tiger_geocoder/utility/standardize_tiger_data.sql
  80. share/postgis/tiger_geocoder/utility/utmzone.sql
  81. share/postgis/utils/README
  82. share/postgis/utils/check_all_upgrades.sh
  83. share/postgis/utils/create_spatial_ref_sys_config_dump.pl
  84. share/postgis/utils/create_undef.pl
  85. share/postgis/utils/create_unpackaged.pl
  86. share/postgis/utils/postgis_proc_set_search_path.pl
  87. share/postgis/utils/postgis_proc_upgrade.pl
  88. share/postgis/utils/postgis_restore.pl
  89. share/postgis/utils/profile_intersects.pl
  90. share/postgis/utils/read_scripts_version.pl
  91. share/postgis/utils/svn_repo_revision.pl
  92. share/postgis/utils/test_estimation.pl
  93. share/postgis/utils/test_geography_estimation.pl
  94. share/postgis/utils/test_geography_joinestimation.pl
  95. share/postgis/utils/test_joinestimation.pl
  96. @comment share/postgresql/applications/shp2pgsql-gui.desktop
  97. share/postgresql/contrib/postgis-2.5/legacy.sql
  98. share/postgresql/contrib/postgis-2.5/legacy_gist.sql
  99. share/postgresql/contrib/postgis-2.5/legacy_minimal.sql
  100. share/postgresql/contrib/postgis-2.5/postgis.sql
  101. share/postgresql/contrib/postgis-2.5/postgis_comments.sql
  102. share/postgresql/contrib/postgis-2.5/postgis_for_extension.sql
  103. share/postgresql/contrib/postgis-2.5/postgis_proc_set_search_path.sql
  104. share/postgresql/contrib/postgis-2.5/postgis_restore.pl
  105. share/postgresql/contrib/postgis-2.5/postgis_upgrade.sql
  106. share/postgresql/contrib/postgis-2.5/postgis_upgrade_for_extension.sql
  107. share/postgresql/contrib/postgis-2.5/raster_comments.sql
  108. share/postgresql/contrib/postgis-2.5/rtpostgis.sql
  109. share/postgresql/contrib/postgis-2.5/rtpostgis_for_extension.sql
  110. share/postgresql/contrib/postgis-2.5/rtpostgis_legacy.sql
  111. share/postgresql/contrib/postgis-2.5/rtpostgis_proc_set_search_path.sql
  112. share/postgresql/contrib/postgis-2.5/rtpostgis_upgrade.sql
  113. share/postgresql/contrib/postgis-2.5/rtpostgis_upgrade_for_extension.sql
  114. share/postgresql/contrib/postgis-2.5/sfcgal.sql
  115. share/postgresql/contrib/postgis-2.5/sfcgal_comments.sql
  116. share/postgresql/contrib/postgis-2.5/sfcgal_upgrade.sql
  117. share/postgresql/contrib/postgis-2.5/spatial_ref_sys.sql
  118. share/postgresql/contrib/postgis-2.5/topology.sql
  119. share/postgresql/contrib/postgis-2.5/topology_comments.sql
  120. share/postgresql/contrib/postgis-2.5/topology_upgrade.sql
  121. share/postgresql/contrib/postgis-2.5/uninstall_legacy.sql
  122. share/postgresql/contrib/postgis-2.5/uninstall_postgis.sql
  123. share/postgresql/contrib/postgis-2.5/uninstall_rtpostgis.sql
  124. share/postgresql/contrib/postgis-2.5/uninstall_sfcgal.sql
  125. share/postgresql/contrib/postgis-2.5/uninstall_topology.sql
  126. share/postgresql/extension/address_standardizer--1.0--2.5.4.sql
  127. share/postgresql/extension/address_standardizer--2.0.0--2.5.4.sql
  128. share/postgresql/extension/address_standardizer--2.0.1--2.5.4.sql
  129. share/postgresql/extension/address_standardizer--2.0.2--2.5.4.sql
  130. share/postgresql/extension/address_standardizer--2.0.3--2.5.4.sql
  131. share/postgresql/extension/address_standardizer--2.0.4--2.5.4.sql
  132. share/postgresql/extension/address_standardizer--2.0.5--2.5.4.sql
  133. share/postgresql/extension/address_standardizer--2.0.6--2.5.4.sql
  134. share/postgresql/extension/address_standardizer--2.0.7--2.5.4.sql
  135. share/postgresql/extension/address_standardizer--2.1.0--2.5.4.sql
  136. share/postgresql/extension/address_standardizer--2.1.1--2.5.4.sql
  137. share/postgresql/extension/address_standardizer--2.1.2--2.5.4.sql
  138. share/postgresql/extension/address_standardizer--2.1.3--2.5.4.sql
  139. share/postgresql/extension/address_standardizer--2.1.4--2.5.4.sql
  140. share/postgresql/extension/address_standardizer--2.1.5--2.5.4.sql
  141. share/postgresql/extension/address_standardizer--2.1.6--2.5.4.sql
  142. share/postgresql/extension/address_standardizer--2.1.7--2.5.4.sql
  143. share/postgresql/extension/address_standardizer--2.1.8--2.5.4.sql
  144. share/postgresql/extension/address_standardizer--2.1.9--2.5.4.sql
  145. share/postgresql/extension/address_standardizer--2.2.0--2.5.4.sql
  146. share/postgresql/extension/address_standardizer--2.2.1--2.5.4.sql
  147. share/postgresql/extension/address_standardizer--2.2.2--2.5.4.sql
  148. share/postgresql/extension/address_standardizer--2.2.3--2.5.4.sql
  149. share/postgresql/extension/address_standardizer--2.2.4--2.5.4.sql
  150. share/postgresql/extension/address_standardizer--2.2.5--2.5.4.sql
  151. share/postgresql/extension/address_standardizer--2.2.6--2.5.4.sql
  152. share/postgresql/extension/address_standardizer--2.2.7--2.5.4.sql
  153. share/postgresql/extension/address_standardizer--2.2.8--2.5.4.sql
  154. share/postgresql/extension/address_standardizer--2.3.0--2.5.4.sql
  155. share/postgresql/extension/address_standardizer--2.3.1--2.5.4.sql
  156. share/postgresql/extension/address_standardizer--2.3.2--2.5.4.sql
  157. share/postgresql/extension/address_standardizer--2.3.3--2.5.4.sql
  158. share/postgresql/extension/address_standardizer--2.3.4--2.5.4.sql
  159. share/postgresql/extension/address_standardizer--2.3.5--2.5.4.sql
  160. share/postgresql/extension/address_standardizer--2.3.6--2.5.4.sql
  161. share/postgresql/extension/address_standardizer--2.3.7--2.5.4.sql
  162. share/postgresql/extension/address_standardizer--2.3.8--2.5.4.sql
  163. share/postgresql/extension/address_standardizer--2.3.9--2.5.4.sql
  164. share/postgresql/extension/address_standardizer--2.3.10--2.5.4.sql
  165. share/postgresql/extension/address_standardizer--2.4.0--2.5.4.sql
  166. share/postgresql/extension/address_standardizer--2.4.1--2.5.4.sql
  167. share/postgresql/extension/address_standardizer--2.4.2--2.5.4.sql
  168. share/postgresql/extension/address_standardizer--2.4.3--2.5.4.sql
  169. share/postgresql/extension/address_standardizer--2.4.4--2.5.4.sql
  170. share/postgresql/extension/address_standardizer--2.4.5--2.5.4.sql
  171. share/postgresql/extension/address_standardizer--2.4.6--2.5.4.sql
  172. share/postgresql/extension/address_standardizer--2.4.7--2.5.4.sql
  173. share/postgresql/extension/address_standardizer--2.4.8--2.5.4.sql
  174. share/postgresql/extension/address_standardizer--2.5.0--2.5.4.sql
  175. share/postgresql/extension/address_standardizer--2.5.1--2.5.4.sql
  176. share/postgresql/extension/address_standardizer--2.5.2--2.5.4.sql
  177. share/postgresql/extension/address_standardizer--2.5.3--2.5.4.sql
  178. share/postgresql/extension/address_standardizer--ANY--2.5.4.sql
  179. share/postgresql/extension/address_standardizer--2.5.4--2.5.4next.sql
  180. share/postgresql/extension/address_standardizer--2.5.4.sql
  181. share/postgresql/extension/address_standardizer--2.5.4dev--2.5.4.sql
  182. share/postgresql/extension/address_standardizer--2.5.4next--2.5.4.sql
  183. share/postgresql/extension/address_standardizer.control
  184. share/postgresql/extension/address_standardizer.sql
  185. share/postgresql/extension/address_standardizer_data_us--2.5.4--2.5.4next.sql
  186. share/postgresql/extension/address_standardizer_data_us--2.5.4.sql
  187. share/postgresql/extension/address_standardizer_data_us--2.5.4next--2.5.4.sql
  188. share/postgresql/extension/address_standardizer_data_us.control
  189. share/postgresql/extension/address_standardizer_data_us.sql
  190. share/postgresql/extension/postgis--2.0.0--2.5.4.sql
  191. share/postgresql/extension/postgis--2.0.1--2.5.4.sql
  192. share/postgresql/extension/postgis--2.0.2--2.5.4.sql
  193. share/postgresql/extension/postgis--2.0.3--2.5.4.sql
  194. share/postgresql/extension/postgis--2.0.4--2.5.4.sql
  195. share/postgresql/extension/postgis--2.0.5--2.5.4.sql
  196. share/postgresql/extension/postgis--2.0.6--2.5.4.sql
  197. share/postgresql/extension/postgis--2.0.7--2.5.4.sql
  198. share/postgresql/extension/postgis--2.1.0--2.5.4.sql
  199. share/postgresql/extension/postgis--2.1.1--2.5.4.sql
  200. share/postgresql/extension/postgis--2.1.2--2.5.4.sql
  201. share/postgresql/extension/postgis--2.1.3--2.5.4.sql
  202. share/postgresql/extension/postgis--2.1.4--2.5.4.sql
  203. share/postgresql/extension/postgis--2.1.5--2.5.4.sql
  204. share/postgresql/extension/postgis--2.1.6--2.5.4.sql
  205. share/postgresql/extension/postgis--2.1.7--2.5.4.sql
  206. share/postgresql/extension/postgis--2.1.8--2.5.4.sql
  207. share/postgresql/extension/postgis--2.1.9--2.5.4.sql
  208. share/postgresql/extension/postgis--2.2.0--2.5.4.sql
  209. share/postgresql/extension/postgis--2.2.1--2.5.4.sql
  210. share/postgresql/extension/postgis--2.2.2--2.5.4.sql
  211. share/postgresql/extension/postgis--2.2.3--2.5.4.sql
  212. share/postgresql/extension/postgis--2.2.4--2.5.4.sql
  213. share/postgresql/extension/postgis--2.2.5--2.5.4.sql
  214. share/postgresql/extension/postgis--2.2.6--2.5.4.sql
  215. share/postgresql/extension/postgis--2.2.7--2.5.4.sql
  216. share/postgresql/extension/postgis--2.2.8--2.5.4.sql
  217. share/postgresql/extension/postgis--2.3.0--2.5.4.sql
  218. share/postgresql/extension/postgis--2.3.1--2.5.4.sql
  219. share/postgresql/extension/postgis--2.3.2--2.5.4.sql
  220. share/postgresql/extension/postgis--2.3.3--2.5.4.sql
  221. share/postgresql/extension/postgis--2.3.4--2.5.4.sql
  222. share/postgresql/extension/postgis--2.3.5--2.5.4.sql
  223. share/postgresql/extension/postgis--2.3.6--2.5.4.sql
  224. share/postgresql/extension/postgis--2.3.7--2.5.4.sql
  225. share/postgresql/extension/postgis--2.3.8--2.5.4.sql
  226. share/postgresql/extension/postgis--2.3.9--2.5.4.sql
  227. share/postgresql/extension/postgis--2.3.10--2.5.4.sql
  228. share/postgresql/extension/postgis--2.4.0--2.5.4.sql
  229. share/postgresql/extension/postgis--2.4.1--2.5.4.sql
  230. share/postgresql/extension/postgis--2.4.2--2.5.4.sql
  231. share/postgresql/extension/postgis--2.4.3--2.5.4.sql
  232. share/postgresql/extension/postgis--2.4.4--2.5.4.sql
  233. share/postgresql/extension/postgis--2.4.5--2.5.4.sql
  234. share/postgresql/extension/postgis--2.4.6--2.5.4.sql
  235. share/postgresql/extension/postgis--2.4.7--2.5.4.sql
  236. share/postgresql/extension/postgis--2.4.8--2.5.4.sql
  237. share/postgresql/extension/postgis--2.5.0--2.5.4.sql
  238. share/postgresql/extension/postgis--2.5.1--2.5.4.sql
  239. share/postgresql/extension/postgis--2.5.2--2.5.4.sql
  240. share/postgresql/extension/postgis--2.5.3--2.5.4.sql
  241. share/postgresql/extension/postgis--2.5.4--2.5.4next.sql
  242. share/postgresql/extension/postgis--2.5.4.sql
  243. share/postgresql/extension/postgis--2.5.4dev--2.5.4.sql
  244. share/postgresql/extension/postgis--2.5.4next--2.5.4.sql
  245. share/postgresql/extension/postgis--ANY--2.5.4.sql
  246. share/postgresql/extension/postgis--unpackaged--2.5.4.sql
  247. share/postgresql/extension/postgis.control
  248. share/postgresql/extension/postgis_sfcgal--2.0.0--2.5.4.sql
  249. share/postgresql/extension/postgis_sfcgal--2.0.1--2.5.4.sql
  250. share/postgresql/extension/postgis_sfcgal--2.0.2--2.5.4.sql
  251. share/postgresql/extension/postgis_sfcgal--2.0.3--2.5.4.sql
  252. share/postgresql/extension/postgis_sfcgal--2.0.4--2.5.4.sql
  253. share/postgresql/extension/postgis_sfcgal--2.0.5--2.5.4.sql
  254. share/postgresql/extension/postgis_sfcgal--2.0.6--2.5.4.sql
  255. share/postgresql/extension/postgis_sfcgal--2.0.7--2.5.4.sql
  256. share/postgresql/extension/postgis_sfcgal--2.1.0--2.5.4.sql
  257. share/postgresql/extension/postgis_sfcgal--2.1.1--2.5.4.sql
  258. share/postgresql/extension/postgis_sfcgal--2.1.2--2.5.4.sql
  259. share/postgresql/extension/postgis_sfcgal--2.1.3--2.5.4.sql
  260. share/postgresql/extension/postgis_sfcgal--2.1.4--2.5.4.sql
  261. share/postgresql/extension/postgis_sfcgal--2.1.5--2.5.4.sql
  262. share/postgresql/extension/postgis_sfcgal--2.1.6--2.5.4.sql
  263. share/postgresql/extension/postgis_sfcgal--2.1.7--2.5.4.sql
  264. share/postgresql/extension/postgis_sfcgal--2.1.8--2.5.4.sql
  265. share/postgresql/extension/postgis_sfcgal--2.1.9--2.5.4.sql
  266. share/postgresql/extension/postgis_sfcgal--2.2.0--2.5.4.sql
  267. share/postgresql/extension/postgis_sfcgal--2.2.1--2.5.4.sql
  268. share/postgresql/extension/postgis_sfcgal--2.2.2--2.5.4.sql
  269. share/postgresql/extension/postgis_sfcgal--2.2.3--2.5.4.sql
  270. share/postgresql/extension/postgis_sfcgal--2.2.4--2.5.4.sql
  271. share/postgresql/extension/postgis_sfcgal--2.2.5--2.5.4.sql
  272. share/postgresql/extension/postgis_sfcgal--2.2.6--2.5.4.sql
  273. share/postgresql/extension/postgis_sfcgal--2.2.7--2.5.4.sql
  274. share/postgresql/extension/postgis_sfcgal--2.2.8--2.5.4.sql
  275. share/postgresql/extension/postgis_sfcgal--2.3.0--2.5.4.sql
  276. share/postgresql/extension/postgis_sfcgal--2.3.1--2.5.4.sql
  277. share/postgresql/extension/postgis_sfcgal--2.3.2--2.5.4.sql
  278. share/postgresql/extension/postgis_sfcgal--2.3.3--2.5.4.sql
  279. share/postgresql/extension/postgis_sfcgal--2.3.4--2.5.4.sql
  280. share/postgresql/extension/postgis_sfcgal--2.3.5--2.5.4.sql
  281. share/postgresql/extension/postgis_sfcgal--2.3.6--2.5.4.sql
  282. share/postgresql/extension/postgis_sfcgal--2.3.7--2.5.4.sql
  283. share/postgresql/extension/postgis_sfcgal--2.3.8--2.5.4.sql
  284. share/postgresql/extension/postgis_sfcgal--2.3.9--2.5.4.sql
  285. share/postgresql/extension/postgis_sfcgal--2.3.10--2.5.4.sql
  286. share/postgresql/extension/postgis_sfcgal--2.4.0--2.5.4.sql
  287. share/postgresql/extension/postgis_sfcgal--2.4.1--2.5.4.sql
  288. share/postgresql/extension/postgis_sfcgal--2.4.2--2.5.4.sql
  289. share/postgresql/extension/postgis_sfcgal--2.4.3--2.5.4.sql
  290. share/postgresql/extension/postgis_sfcgal--2.4.4--2.5.4.sql
  291. share/postgresql/extension/postgis_sfcgal--2.4.5--2.5.4.sql
  292. share/postgresql/extension/postgis_sfcgal--2.4.6--2.5.4.sql
  293. share/postgresql/extension/postgis_sfcgal--2.4.7--2.5.4.sql
  294. share/postgresql/extension/postgis_sfcgal--2.4.8--2.5.4.sql
  295. share/postgresql/extension/postgis_sfcgal--2.5.0--2.5.4.sql
  296. share/postgresql/extension/postgis_sfcgal--2.5.1--2.5.4.sql
  297. share/postgresql/extension/postgis_sfcgal--2.5.2--2.5.4.sql
  298. share/postgresql/extension/postgis_sfcgal--2.5.3--2.5.4.sql
  299. share/postgresql/extension/postgis_sfcgal--2.5.4--2.5.4next.sql
  300. share/postgresql/extension/postgis_sfcgal--2.5.4.sql
  301. share/postgresql/extension/postgis_sfcgal--2.5.4dev--2.5.4.sql
  302. share/postgresql/extension/postgis_sfcgal--2.5.4next--2.5.4.sql
  303. share/postgresql/extension/postgis_sfcgal--ANY--2.5.4.sql
  304. share/postgresql/extension/postgis_sfcgal--unpackaged--2.5.4.sql
  305. share/postgresql/extension/postgis_sfcgal.control
  306. share/postgresql/extension/postgis_tiger_geocoder--2.0.0--2.5.4.sql
  307. share/postgresql/extension/postgis_tiger_geocoder--2.0.1--2.5.4.sql
  308. share/postgresql/extension/postgis_tiger_geocoder--2.0.2--2.5.4.sql
  309. share/postgresql/extension/postgis_tiger_geocoder--2.0.3--2.5.4.sql
  310. share/postgresql/extension/postgis_tiger_geocoder--2.0.4--2.5.4.sql
  311. share/postgresql/extension/postgis_tiger_geocoder--2.0.5--2.5.4.sql
  312. share/postgresql/extension/postgis_tiger_geocoder--2.0.6--2.5.4.sql
  313. share/postgresql/extension/postgis_tiger_geocoder--2.0.7--2.5.4.sql
  314. share/postgresql/extension/postgis_tiger_geocoder--2.1.0--2.5.4.sql
  315. share/postgresql/extension/postgis_tiger_geocoder--2.1.1--2.5.4.sql
  316. share/postgresql/extension/postgis_tiger_geocoder--2.1.2--2.5.4.sql
  317. share/postgresql/extension/postgis_tiger_geocoder--2.1.3--2.5.4.sql
  318. share/postgresql/extension/postgis_tiger_geocoder--2.1.4--2.5.4.sql
  319. share/postgresql/extension/postgis_tiger_geocoder--2.1.5--2.5.4.sql
  320. share/postgresql/extension/postgis_tiger_geocoder--2.1.6--2.5.4.sql
  321. share/postgresql/extension/postgis_tiger_geocoder--2.1.7--2.5.4.sql
  322. share/postgresql/extension/postgis_tiger_geocoder--2.1.8--2.5.4.sql
  323. share/postgresql/extension/postgis_tiger_geocoder--2.1.9--2.5.4.sql
  324. share/postgresql/extension/postgis_tiger_geocoder--2.2.0--2.5.4.sql
  325. share/postgresql/extension/postgis_tiger_geocoder--2.2.1--2.5.4.sql
  326. share/postgresql/extension/postgis_tiger_geocoder--2.2.2--2.5.4.sql
  327. share/postgresql/extension/postgis_tiger_geocoder--2.2.3--2.5.4.sql
  328. share/postgresql/extension/postgis_tiger_geocoder--2.2.4--2.5.4.sql
  329. share/postgresql/extension/postgis_tiger_geocoder--2.2.5--2.5.4.sql
  330. share/postgresql/extension/postgis_tiger_geocoder--2.2.6--2.5.4.sql
  331. share/postgresql/extension/postgis_tiger_geocoder--2.2.7--2.5.4.sql
  332. share/postgresql/extension/postgis_tiger_geocoder--2.2.8--2.5.4.sql
  333. share/postgresql/extension/postgis_tiger_geocoder--2.3.0--2.5.4.sql
  334. share/postgresql/extension/postgis_tiger_geocoder--2.3.1--2.5.4.sql
  335. share/postgresql/extension/postgis_tiger_geocoder--2.3.2--2.5.4.sql
  336. share/postgresql/extension/postgis_tiger_geocoder--2.3.3--2.5.4.sql
  337. share/postgresql/extension/postgis_tiger_geocoder--2.3.4--2.5.4.sql
  338. share/postgresql/extension/postgis_tiger_geocoder--2.3.5--2.5.4.sql
  339. share/postgresql/extension/postgis_tiger_geocoder--2.3.6--2.5.4.sql
  340. share/postgresql/extension/postgis_tiger_geocoder--2.3.7--2.5.4.sql
  341. share/postgresql/extension/postgis_tiger_geocoder--2.3.8--2.5.4.sql
  342. share/postgresql/extension/postgis_tiger_geocoder--2.3.9--2.5.4.sql
  343. share/postgresql/extension/postgis_tiger_geocoder--2.3.10--2.5.4.sql
  344. share/postgresql/extension/postgis_tiger_geocoder--2.4.0--2.5.4.sql
  345. share/postgresql/extension/postgis_tiger_geocoder--2.4.1--2.5.4.sql
  346. share/postgresql/extension/postgis_tiger_geocoder--2.4.2--2.5.4.sql
  347. share/postgresql/extension/postgis_tiger_geocoder--2.4.3--2.5.4.sql
  348. share/postgresql/extension/postgis_tiger_geocoder--2.4.4--2.5.4.sql
  349. share/postgresql/extension/postgis_tiger_geocoder--2.4.5--2.5.4.sql
  350. share/postgresql/extension/postgis_tiger_geocoder--2.4.6--2.5.4.sql
  351. share/postgresql/extension/postgis_tiger_geocoder--2.4.7--2.5.4.sql
  352. share/postgresql/extension/postgis_tiger_geocoder--2.4.8--2.5.4.sql
  353. share/postgresql/extension/postgis_tiger_geocoder--2.5.0--2.5.4.sql
  354. share/postgresql/extension/postgis_tiger_geocoder--2.5.1--2.5.4.sql
  355. share/postgresql/extension/postgis_tiger_geocoder--2.5.2--2.5.4.sql
  356. share/postgresql/extension/postgis_tiger_geocoder--2.5.3--2.5.4.sql
  357. share/postgresql/extension/postgis_tiger_geocoder--2.5.4--2.5.4next.sql
  358. share/postgresql/extension/postgis_tiger_geocoder--2.5.4.sql
  359. share/postgresql/extension/postgis_tiger_geocoder--2.5.4dev--2.5.4.sql
  360. share/postgresql/extension/postgis_tiger_geocoder--2.5.4next--2.5.4.sql
  361. share/postgresql/extension/postgis_tiger_geocoder--ANY--2.5.4.sql
  362. share/postgresql/extension/postgis_tiger_geocoder--unpackaged--2.5.4.sql
  363. share/postgresql/extension/postgis_tiger_geocoder.control
  364. share/postgresql/extension/postgis_topology--2.0.0--2.5.4.sql
  365. share/postgresql/extension/postgis_topology--2.0.1--2.5.4.sql
  366. share/postgresql/extension/postgis_topology--2.0.2--2.5.4.sql
  367. share/postgresql/extension/postgis_topology--2.0.3--2.5.4.sql
  368. share/postgresql/extension/postgis_topology--2.0.4--2.5.4.sql
  369. share/postgresql/extension/postgis_topology--2.0.5--2.5.4.sql
  370. share/postgresql/extension/postgis_topology--2.0.6--2.5.4.sql
  371. share/postgresql/extension/postgis_topology--2.0.7--2.5.4.sql
  372. share/postgresql/extension/postgis_topology--2.1.0--2.5.4.sql
  373. share/postgresql/extension/postgis_topology--2.1.1--2.5.4.sql
  374. share/postgresql/extension/postgis_topology--2.1.2--2.5.4.sql
  375. share/postgresql/extension/postgis_topology--2.1.3--2.5.4.sql
  376. share/postgresql/extension/postgis_topology--2.1.4--2.5.4.sql
  377. share/postgresql/extension/postgis_topology--2.1.5--2.5.4.sql
  378. share/postgresql/extension/postgis_topology--2.1.6--2.5.4.sql
  379. share/postgresql/extension/postgis_topology--2.1.7--2.5.4.sql
  380. share/postgresql/extension/postgis_topology--2.1.8--2.5.4.sql
  381. share/postgresql/extension/postgis_topology--2.1.9--2.5.4.sql
  382. share/postgresql/extension/postgis_topology--2.2.0--2.5.4.sql
  383. share/postgresql/extension/postgis_topology--2.2.1--2.5.4.sql
  384. share/postgresql/extension/postgis_topology--2.2.2--2.5.4.sql
  385. share/postgresql/extension/postgis_topology--2.2.3--2.5.4.sql
  386. share/postgresql/extension/postgis_topology--2.2.4--2.5.4.sql
  387. share/postgresql/extension/postgis_topology--2.2.5--2.5.4.sql
  388. share/postgresql/extension/postgis_topology--2.2.6--2.5.4.sql
  389. share/postgresql/extension/postgis_topology--2.2.7--2.5.4.sql
  390. share/postgresql/extension/postgis_topology--2.2.8--2.5.4.sql
  391. share/postgresql/extension/postgis_topology--2.3.0--2.5.4.sql
  392. share/postgresql/extension/postgis_topology--2.3.1--2.5.4.sql
  393. share/postgresql/extension/postgis_topology--2.3.2--2.5.4.sql
  394. share/postgresql/extension/postgis_topology--2.3.3--2.5.4.sql
  395. share/postgresql/extension/postgis_topology--2.3.4--2.5.4.sql
  396. share/postgresql/extension/postgis_topology--2.3.5--2.5.4.sql
  397. share/postgresql/extension/postgis_topology--2.3.6--2.5.4.sql
  398. share/postgresql/extension/postgis_topology--2.3.7--2.5.4.sql
  399. share/postgresql/extension/postgis_topology--2.3.8--2.5.4.sql
  400. share/postgresql/extension/postgis_topology--2.3.9--2.5.4.sql
  401. share/postgresql/extension/postgis_topology--2.3.10--2.5.4.sql
  402. share/postgresql/extension/postgis_topology--2.4.0--2.5.4.sql
  403. share/postgresql/extension/postgis_topology--2.4.1--2.5.4.sql
  404. share/postgresql/extension/postgis_topology--2.4.2--2.5.4.sql
  405. share/postgresql/extension/postgis_topology--2.4.3--2.5.4.sql
  406. share/postgresql/extension/postgis_topology--2.4.4--2.5.4.sql
  407. share/postgresql/extension/postgis_topology--2.4.5--2.5.4.sql
  408. share/postgresql/extension/postgis_topology--2.4.6--2.5.4.sql
  409. share/postgresql/extension/postgis_topology--2.4.7--2.5.4.sql
  410. share/postgresql/extension/postgis_topology--2.4.8--2.5.4.sql
  411. share/postgresql/extension/postgis_topology--2.5.0--2.5.4.sql
  412. share/postgresql/extension/postgis_topology--2.5.1--2.5.4.sql
  413. share/postgresql/extension/postgis_topology--2.5.2--2.5.4.sql
  414. share/postgresql/extension/postgis_topology--2.5.3--2.5.4.sql
  415. share/postgresql/extension/postgis_topology--2.5.4--2.5.4next.sql
  416. share/postgresql/extension/postgis_topology--2.5.4.sql
  417. share/postgresql/extension/postgis_topology--2.5.4dev--2.5.4.sql
  418. share/postgresql/extension/postgis_topology--2.5.4next--2.5.4.sql
  419. share/postgresql/extension/postgis_topology--ANY--2.5.4.sql
  420. share/postgresql/extension/postgis_topology--unpackaged--2.5.4.sql
  421. share/postgresql/extension/postgis_topology.control
  422. @comment share/postgresql/icons/hicolor/8x8/apps/shp2pgsql-gui.png
  423. @comment share/postgresql/icons/hicolor/16x16/apps/shp2pgsql-gui.png
  424. @comment share/postgresql/icons/hicolor/22x22/apps/shp2pgsql-gui.png
  425. @comment share/postgresql/icons/hicolor/24x24/apps/shp2pgsql-gui.png
  426. @comment share/postgresql/icons/hicolor/32x32/apps/shp2pgsql-gui.png
  427. @comment share/postgresql/icons/hicolor/36x36/apps/shp2pgsql-gui.png
  428. @comment share/postgresql/icons/hicolor/40x40/apps/shp2pgsql-gui.png
  429. @comment share/postgresql/icons/hicolor/42x42/apps/shp2pgsql-gui.png
  430. @comment share/postgresql/icons/hicolor/48x48/apps/shp2pgsql-gui.png
  431. @comment share/postgresql/icons/hicolor/64x64/apps/shp2pgsql-gui.png
Collapse this list.
Dependency lines:
  • postgis25>0:databases/postgis25
Conflicts:
CONFLICTS_INSTALL:
  • postgis20
  • postgis21
  • postgis22
  • postgis23
  • postgis24
  • postgis30
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port: cd /usr/ports/databases/postgis25/ && make install clean
To add the package: pkg install postgis25
PKGNAME: postgis25
Flavors: there is no flavor information for this port.
distinfo:
Packages:
postgis25
ABIlatestquarterly
FreeBSD:11:aarch64-2.5.3_2
FreeBSD:11:amd642.5.4_22.5.3_2
FreeBSD:11:i3862.5.4_22.5.3_2
FreeBSD:12:aarch64-2.5.3_2
FreeBSD:12:amd642.5.4_22.5.3_2
FreeBSD:12:i3862.5.4_22.5.3_2
FreeBSD:13:aarch642.5.4-
FreeBSD:13:amd642.5.4_2-
FreeBSD:13:i3862.5.4_2-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.3 : devel/gmake
  2. pkgconf>=1.3.0_1 : devel/pkgconf
  3. vacuumlo : databases/postgresql11-contrib
  4. postgres : databases/postgresql11-server
  5. msgfmt : devel/gettext-tools
  6. perl5>=5.30.r1<5.31 : lang/perl5.30
Runtime dependencies:
  1. vacuumlo : databases/postgresql11-contrib
  2. postgres : databases/postgresql11-server
Library dependencies:
  1. libproj.so : graphics/proj
  2. libgeos.so : graphics/geos
  3. libjson-c.so : devel/json-c
  4. libgdal.so : graphics/gdal
  5. libpcre.so : devel/pcre
  6. libSFCGAL.so : databases/sfcgal
  7. libxml2.so : textproc/libxml2
  8. libiconv.so : converters/libiconv
  9. libintl.so : devel/gettext-runtime
This port is required by:
for Libraries
  1. graphics/tinyows

Configuration Options

USES:

Master Sites:
  1. https://download.osgeo.org/postgis/source/

Number of commits found: 13

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
22 May 2020 19:20:42
Original commit files touched by this commit  2.5.4_2
Revision:536219
sunpoet search for other commits by this committer
Bump PORTREVISION for devel/json-c json-c
08 May 2020 05:35:11
Original commit files touched by this commit  2.5.4_1
Revision:534326
lbartoletti search for other commits by this committer
smath/cgal: Update to 5.0.2

The new version of CGAL brings improvements and a lot of changes, including 2
major ones [1](header only[2] and require c++14) requiring to patch all software
depending on it.

[1] https://www.cgal.org/2019/11/08/cgal50/
[2] https://doc.cgal.org/latest/Manual/installation.html

math/cgal:

   - Update to 5.0.2

databases/sfcgal:

   - Fix with cgal5 : use c++14 and add gmpxx link
(Only the first 15 lines of the commit message are shown above View all of this commit message)
05 Apr 2020 20:16:04
Original commit files touched by this commit  2.5.4
Revision:530836
lbartoletti search for other commits by this committer
databases/postgis25, databases/postgis30: Update to latest versions

   - databases/postgis25
      -  Update to 2.5.4
      -  Add an option to NLS
      -  Move CONFLICTS_INSTALL (pet portlint)
    - databases/postigs30
      -  Update to 3.0.1

Changelog:
    - https://postgis.net/2020/02/28/postgis-2.5.4/
    - https://postgis.net/2020/02/20/postgis-3.0.1/

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D24301
22 Jan 2020 06:02:25
Original commit files touched by this commit  2.5.3_2
Revision:523793
sunpoet search for other commits by this committer
Bump PORTREVISION for graphics/gdal shlib change
14 Jan 2020 21:45:15
Original commit files touched by this commit  2.5.3_1
Revision:523070
lbartoletti search for other commits by this committer
Change my mail address to lbartoletti@FreeBSD.org

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D23169
02 Nov 2019 13:54:50
Original commit files touched by this commit  2.5.3_1
Revision:516323
tcberner search for other commits by this committer
databases/postgis30: Geographic objects support for PostgreSQL databases

  * Add CONFLICTS_INSTALL for databases/postgis2*
  * Add USE=NLS for databases/postgis2*
  * New port databases/postgis30
  * New default options for postgis: WAGYU, PROTOBUF and JSON
  * RASTER is now a separated extension (enabled by default), use "CREATE
    EXTENSION postgis_raster;" as for topology or sfcgal extensions

Changelog:

   https://postgis.net/2019/10/20/postgis-3.0.0/

PR:		241358
Submitted by:	Loic Bartoletti <lbartoletti@tuxfamily.org>
19 Aug 2019 15:37:02
Original commit files touched by this commit  2.5.3
Revision:509291
amdmi3 search for other commits by this committer
- Update to 2.5.3
- Whitespace fix
- Fix incorrect substitutions and sorting in plist

PR:		239908
Submitted by:	amdmi3
Approved by:	lbartoletti@tuxfamily.org (maintainer)
27 Jul 2019 11:57:49
Original commit files touched by this commit  2.5.2_1
Revision:507442
sunpoet search for other commits by this committer
Remove useless pkg-install

Differential Revision:	https://reviews.freebsd.org/D20216
Submitted by:	Loic Bartoletti <lbartoletti@tuxfamily.org> (maintainer)
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.5.2_1
Revision:507372
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
12 Jul 2019 02:25:07
Original commit files touched by this commit  2.5.2
Revision:506432
linimon search for other commits by this committer
Prepare for powerpc-on-clang by deleting hard-coded tests for libstdc++.so
as a stand-in for "are we running on gcc".

For people already testing powerpc on clang, it is possible that they
already have both compilers in base.  Thus, the assumption that "gcc is
in base" (e.g.  libstdc++.so exists) always means "force use of GCC" is
already broken.  It will be for everyone on -CURRENT once the switch is
made.

While here, standardize on compiler:c++11-lang instead of -lib (they are
equivalent these days), pet portlint, and do some other cleanup.

Approved by:	portmgr (tier-2 blanket)
29 Mar 2019 14:41:55
Original commit files touched by this commit  2.5.2
Revision:497146
linimon search for other commits by this committer
Fix build on gcc-based architectures:

  lwgeom_functions_basic.c:1566: error: #pragma GCC diagnostic not allowed
inside functions

PR:		236728
Submitted by:	Piotr Kubaj
Approved by:	maintainer
20 Mar 2019 07:02:30
Original commit files touched by this commit  2.5.2
Revision:496315
tobik search for other commits by this committer
databases/postgis25: Do not set CONFLICTS_INSTALL twice
15 Mar 2019 00:47:02
Original commit files touched by this commit  2.5.2
Revision:495753
wen search for other commits by this committer
- Repocopy postgis24 --> postgis25 and update to 2.5.2

PR:		231712
Submitted by:	darcy@dbitech.ca
Reviewed by:	sunpoet@, rhurlin_gwdg.de, harrison.grundy-astrodoggroup.com
Approved by:	lbartoletti_tuxfamily.org(maintainer)
Differential Revision:	https://reviews.freebsd.org/D17320

Number of commits found: 13

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
powerdns-recursorMay 26
sympaMay 26
chromiumMay 24
piwigoMay 23
drupal7May 22
sympaMay 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19

17 vulnerabilities affecting 180 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-27 17:20:39


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39438
Broken 79
Deprecated 627
Ignore 347
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 15
Set to expire 581
Interactive 0
new 24 hours 3
new 48 hours10
new 7 days35
new fortnight81
new month237

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.