notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)Want a good monitor light? See my photosAll times are UTC		 Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details on branch 2022Q2
postgresql12-contrib The contrib utilities from the PostgreSQL distribution
12.10_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 View this port on Repology. pkg-fallout 12.10_2Version of this port present on the latest quarterly branch.
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2022-04-24 04:16:20
Last Update: 2022-04-10 19:47:23
Commit Hash: 035e778
License: PostgreSQL
WWW:
https://www.postgresql.org/
Description:
PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere. Commercial Support is also available. The original Postgres code was the effort of many graduate students, undergraduate students, and staff programmers working under the direction of Professor Michael Stonebraker at the University of California, Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query language to SQL and created a new database system which came to known as Postgres95. Many others contributed to the porting, testing, debugging and enhancement of the Postgres95 code. As the code improved, and 1995 faded into memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. WWW: https://www.postgresql.org/
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (271 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql12-contrib-12.10_2/catalog.mk
  2. /usr/local/share/licenses/postgresql12-contrib-12.10_2/LICENSE
  3. /usr/local/share/licenses/postgresql12-contrib-12.10_2/PostgreSQL
  4. bin/oid2name
  5. bin/pg_standby
  6. bin/vacuumlo
  7. include/postgresql/server/extension/cube/cubedata.h
  8. include/postgresql/server/extension/hstore/hstore.h
  9. include/postgresql/server/extension/isn/isn.h
  10. include/postgresql/server/extension/ltree/ltree.h
  11. include/postgresql/server/extension/seg/segdata.h
  12. lib/postgresql/_int.so
  13. lib/postgresql/adminpack.so
  14. lib/postgresql/amcheck.so
  15. lib/postgresql/auth_delay.so
  16. lib/postgresql/auto_explain.so
  17. lib/postgresql/autoinc.so
  18. lib/postgresql/bloom.so
  19. lib/postgresql/btree_gin.so
  20. lib/postgresql/btree_gist.so
  21. lib/postgresql/citext.so
  22. lib/postgresql/cube.so
  23. lib/postgresql/dblink.so
  24. lib/postgresql/dict_int.so
  25. lib/postgresql/dict_xsyn.so
  26. lib/postgresql/earthdistance.so
  27. lib/postgresql/file_fdw.so
  28. lib/postgresql/fuzzystrmatch.so
  29. lib/postgresql/hstore.so
  30. lib/postgresql/insert_username.so
  31. lib/postgresql/isn.so
  32. lib/postgresql/lo.so
  33. lib/postgresql/ltree.so
  34. lib/postgresql/moddatetime.so
  35. lib/postgresql/pageinspect.so
  36. lib/postgresql/passwordcheck.so
  37. lib/postgresql/pg_buffercache.so
  38. lib/postgresql/pg_freespacemap.so
  39. lib/postgresql/pg_prewarm.so
  40. lib/postgresql/pg_stat_statements.so
  41. lib/postgresql/pg_trgm.so
  42. lib/postgresql/pg_visibility.so
  43. lib/postgresql/pgcrypto.so
  44. lib/postgresql/pgrowlocks.so
  45. lib/postgresql/pgstattuple.so
  46. lib/postgresql/pgxml.so
  47. lib/postgresql/postgres_fdw.so
  48. lib/postgresql/refint.so
  49. lib/postgresql/seg.so
  50. lib/postgresql/sslinfo.so
  51. lib/postgresql/tablefunc.so
  52. lib/postgresql/tcn.so
  53. lib/postgresql/test_decoding.so
  54. lib/postgresql/tsm_system_rows.so
  55. lib/postgresql/tsm_system_time.so
  56. lib/postgresql/unaccent.so
  57. lib/postgresql/uuid-ossp.so
  58. share/doc/postgresql/README-contrib
  59. share/doc/postgresql/extension/README
  60. share/doc/postgresql/extension/autoinc.example
  61. share/doc/postgresql/extension/insert_username.example
  62. share/doc/postgresql/extension/moddatetime.example
  63. share/doc/postgresql/extension/refint.example
  64. share/postgresql/extension/adminpack--1.0--1.1.sql
  65. share/postgresql/extension/adminpack--1.0.sql
  66. share/postgresql/extension/adminpack--1.1--2.0.sql
  67. share/postgresql/extension/adminpack.control
  68. share/postgresql/extension/amcheck--1.0--1.1.sql
  69. share/postgresql/extension/amcheck--1.0.sql
  70. share/postgresql/extension/amcheck.control
  71. share/postgresql/extension/autoinc--1.0.sql
  72. share/postgresql/extension/autoinc--unpackaged--1.0.sql
  73. share/postgresql/extension/autoinc.control
  74. share/postgresql/extension/bloom--1.0.sql
  75. share/postgresql/extension/bloom.control
  76. share/postgresql/extension/btree_gin--1.0--1.1.sql
  77. share/postgresql/extension/btree_gin--1.0.sql
  78. share/postgresql/extension/btree_gin--1.1--1.2.sql
  79. share/postgresql/extension/btree_gin--1.2--1.3.sql
  80. share/postgresql/extension/btree_gin--unpackaged--1.0.sql
  81. share/postgresql/extension/btree_gin.control
  82. share/postgresql/extension/btree_gist--1.0--1.1.sql
  83. share/postgresql/extension/btree_gist--1.1--1.2.sql
  84. share/postgresql/extension/btree_gist--1.2--1.3.sql
  85. share/postgresql/extension/btree_gist--1.2.sql
  86. share/postgresql/extension/btree_gist--1.3--1.4.sql
  87. share/postgresql/extension/btree_gist--1.4--1.5.sql
  88. share/postgresql/extension/btree_gist--unpackaged--1.0.sql
  89. share/postgresql/extension/btree_gist.control
  90. share/postgresql/extension/citext--1.0--1.1.sql
  91. share/postgresql/extension/citext--1.1--1.2.sql
  92. share/postgresql/extension/citext--1.2--1.3.sql
  93. share/postgresql/extension/citext--1.3--1.4.sql
  94. share/postgresql/extension/citext--1.4--1.5.sql
  95. share/postgresql/extension/citext--1.4.sql
  96. share/postgresql/extension/citext--unpackaged--1.0.sql
  97. share/postgresql/extension/citext.control
  98. share/postgresql/extension/cube--1.0--1.1.sql
  99. share/postgresql/extension/cube--1.1--1.2.sql
  100. share/postgresql/extension/cube--1.2--1.3.sql
  101. share/postgresql/extension/cube--1.2.sql
  102. share/postgresql/extension/cube--1.3--1.4.sql
  103. share/postgresql/extension/cube--unpackaged--1.0.sql
  104. share/postgresql/extension/cube.control
  105. share/postgresql/extension/dblink--1.0--1.1.sql
  106. share/postgresql/extension/dblink--1.1--1.2.sql
  107. share/postgresql/extension/dblink--1.2.sql
  108. share/postgresql/extension/dblink--unpackaged--1.0.sql
  109. share/postgresql/extension/dblink.control
  110. share/postgresql/extension/dict_int--1.0.sql
  111. share/postgresql/extension/dict_int--unpackaged--1.0.sql
  112. share/postgresql/extension/dict_int.control
  113. share/postgresql/extension/dict_xsyn--1.0.sql
  114. share/postgresql/extension/dict_xsyn--unpackaged--1.0.sql
  115. share/postgresql/extension/dict_xsyn.control
  116. share/postgresql/extension/earthdistance--1.0--1.1.sql
  117. share/postgresql/extension/earthdistance--1.1.sql
  118. share/postgresql/extension/earthdistance--unpackaged--1.0.sql
  119. share/postgresql/extension/amcheck--1.1--1.2.sql
  120. share/postgresql/extension/citext--1.5--1.6.sql
  121. share/postgresql/extension/hstore--1.5--1.6.sql
  122. share/postgresql/extension/pg_stat_statements--1.6--1.7.sql
  123. share/postgresql/extension/earthdistance.control
  124. share/postgresql/extension/file_fdw--1.0.sql
  125. share/postgresql/extension/file_fdw.control
  126. share/postgresql/extension/fuzzystrmatch--1.0--1.1.sql
  127. share/postgresql/extension/fuzzystrmatch--1.1.sql
  128. share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql
  129. share/postgresql/extension/fuzzystrmatch.control
  130. share/postgresql/extension/hstore--1.0--1.1.sql
  131. share/postgresql/extension/hstore--1.1--1.2.sql
  132. share/postgresql/extension/hstore--1.2--1.3.sql
  133. share/postgresql/extension/hstore--1.3--1.4.sql
  134. share/postgresql/extension/hstore--1.4--1.5.sql
  135. share/postgresql/extension/hstore--1.4.sql
  136. share/postgresql/extension/hstore--unpackaged--1.0.sql
  137. share/postgresql/extension/hstore.control
  138. share/postgresql/extension/insert_username--1.0.sql
  139. share/postgresql/extension/insert_username--unpackaged--1.0.sql
  140. share/postgresql/extension/insert_username.control
  141. share/postgresql/extension/intagg--1.0--1.1.sql
  142. share/postgresql/extension/intagg--1.1.sql
  143. share/postgresql/extension/intagg--unpackaged--1.0.sql
  144. share/postgresql/extension/intagg.control
  145. share/postgresql/extension/intarray--1.0--1.1.sql
  146. share/postgresql/extension/intarray--1.1--1.2.sql
  147. share/postgresql/extension/intarray--1.2.sql
  148. share/postgresql/extension/intarray--unpackaged--1.0.sql
  149. share/postgresql/extension/intarray.control
  150. share/postgresql/extension/isn--1.0--1.1.sql
  151. share/postgresql/extension/isn--1.1--1.2.sql
  152. share/postgresql/extension/isn--1.1.sql
  153. share/postgresql/extension/isn--unpackaged--1.0.sql
  154. share/postgresql/extension/isn.control
  155. share/postgresql/extension/lo--1.0--1.1.sql
  156. share/postgresql/extension/lo--1.1.sql
  157. share/postgresql/extension/lo--unpackaged--1.0.sql
  158. share/postgresql/extension/lo.control
  159. share/postgresql/extension/ltree--1.0--1.1.sql
  160. share/postgresql/extension/ltree--1.1.sql
  161. share/postgresql/extension/ltree--unpackaged--1.0.sql
  162. share/postgresql/extension/ltree.control
  163. share/postgresql/extension/moddatetime--1.0.sql
  164. share/postgresql/extension/moddatetime--unpackaged--1.0.sql
  165. share/postgresql/extension/moddatetime.control
  166. share/postgresql/extension/pageinspect--1.0--1.1.sql
  167. share/postgresql/extension/pageinspect--1.1--1.2.sql
  168. share/postgresql/extension/pageinspect--1.2--1.3.sql
  169. share/postgresql/extension/pageinspect--1.3--1.4.sql
  170. share/postgresql/extension/pageinspect--1.4--1.5.sql
  171. share/postgresql/extension/pageinspect--1.5--1.6.sql
  172. share/postgresql/extension/pageinspect--1.5.sql
  173. share/postgresql/extension/pageinspect--1.6--1.7.sql
  174. share/postgresql/extension/pageinspect--unpackaged--1.0.sql
  175. share/postgresql/extension/pageinspect.control
  176. share/postgresql/extension/pg_buffercache--1.0--1.1.sql
  177. share/postgresql/extension/pg_buffercache--1.1--1.2.sql
  178. share/postgresql/extension/pg_buffercache--1.2--1.3.sql
  179. share/postgresql/extension/pg_buffercache--1.2.sql
  180. share/postgresql/extension/pg_buffercache--unpackaged--1.0.sql
  181. share/postgresql/extension/pg_buffercache.control
  182. share/postgresql/extension/pg_freespacemap--1.0--1.1.sql
  183. share/postgresql/extension/pg_freespacemap--1.1--1.2.sql
  184. share/postgresql/extension/pg_freespacemap--1.1.sql
  185. share/postgresql/extension/pg_freespacemap--unpackaged--1.0.sql
  186. share/postgresql/extension/pg_freespacemap.control
  187. share/postgresql/extension/pg_prewarm--1.0--1.1.sql
  188. share/postgresql/extension/pg_prewarm--1.1--1.2.sql
  189. share/postgresql/extension/pg_prewarm--1.1.sql
  190. share/postgresql/extension/pg_prewarm.control
  191. share/postgresql/extension/pg_stat_statements--1.0--1.1.sql
  192. share/postgresql/extension/pg_stat_statements--1.1--1.2.sql
  193. share/postgresql/extension/pg_stat_statements--1.2--1.3.sql
  194. share/postgresql/extension/pg_stat_statements--1.3--1.4.sql
  195. share/postgresql/extension/pg_stat_statements--1.4--1.5.sql
  196. share/postgresql/extension/pg_stat_statements--1.4.sql
  197. share/postgresql/extension/pg_stat_statements--1.5--1.6.sql
  198. share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
  199. share/postgresql/extension/pg_stat_statements.control
  200. share/postgresql/extension/pg_trgm--1.0--1.1.sql
  201. share/postgresql/extension/pg_trgm--1.1--1.2.sql
  202. share/postgresql/extension/pg_trgm--1.2--1.3.sql
  203. share/postgresql/extension/pg_trgm--1.3--1.4.sql
  204. share/postgresql/extension/pg_trgm--1.3.sql
  205. share/postgresql/extension/pg_trgm--unpackaged--1.0.sql
  206. share/postgresql/extension/pg_trgm.control
  207. share/postgresql/extension/pg_visibility--1.0--1.1.sql
  208. share/postgresql/extension/pg_visibility--1.1--1.2.sql
  209. share/postgresql/extension/pg_visibility--1.1.sql
  210. share/postgresql/extension/pg_visibility.control
  211. share/postgresql/extension/pgcrypto--1.0--1.1.sql
  212. share/postgresql/extension/pgcrypto--1.1--1.2.sql
  213. share/postgresql/extension/pgcrypto--1.2--1.3.sql
  214. share/postgresql/extension/pgcrypto--1.3.sql
  215. share/postgresql/extension/pgcrypto--unpackaged--1.0.sql
  216. share/postgresql/extension/pgcrypto.control
  217. share/postgresql/extension/pgrowlocks--1.0--1.1.sql
  218. share/postgresql/extension/pgrowlocks--1.1--1.2.sql
  219. share/postgresql/extension/pgrowlocks--1.2.sql
  220. share/postgresql/extension/pgrowlocks--unpackaged--1.0.sql
  221. share/postgresql/extension/pgrowlocks.control
  222. share/postgresql/extension/pgstattuple--1.0--1.1.sql
  223. share/postgresql/extension/pgstattuple--1.1--1.2.sql
  224. share/postgresql/extension/pgstattuple--1.2--1.3.sql
  225. share/postgresql/extension/pgstattuple--1.3--1.4.sql
  226. share/postgresql/extension/pgstattuple--1.4--1.5.sql
  227. share/postgresql/extension/pgstattuple--1.4.sql
  228. share/postgresql/extension/pgstattuple--unpackaged--1.0.sql
  229. share/postgresql/extension/pgstattuple.control
  230. share/postgresql/extension/postgres_fdw--1.0.sql
  231. share/postgresql/extension/postgres_fdw.control
  232. share/postgresql/extension/refint--1.0.sql
  233. share/postgresql/extension/refint--unpackaged--1.0.sql
  234. share/postgresql/extension/refint.control
  235. share/postgresql/extension/seg--1.0--1.1.sql
  236. share/postgresql/extension/seg--1.1--1.2.sql
  237. share/postgresql/extension/seg--1.1.sql
  238. share/postgresql/extension/seg--1.2--1.3.sql
  239. share/postgresql/extension/seg--unpackaged--1.0.sql
  240. share/postgresql/extension/seg.control
  241. share/postgresql/extension/sslinfo--1.0--1.1.sql
  242. share/postgresql/extension/sslinfo--1.1--1.2.sql
  243. share/postgresql/extension/sslinfo--1.2.sql
  244. share/postgresql/extension/sslinfo--unpackaged--1.0.sql
  245. share/postgresql/extension/sslinfo.control
  246. share/postgresql/extension/tablefunc--1.0.sql
  247. share/postgresql/extension/tablefunc--unpackaged--1.0.sql
  248. share/postgresql/extension/tablefunc.control
  249. share/postgresql/extension/tcn--1.0.sql
  250. share/postgresql/extension/tcn.control
  251. share/postgresql/extension/tsm_system_rows--1.0.sql
  252. share/postgresql/extension/tsm_system_rows.control
  253. share/postgresql/extension/tsm_system_time--1.0.sql
  254. share/postgresql/extension/tsm_system_time.control
  255. share/postgresql/extension/unaccent--1.0--1.1.sql
  256. share/postgresql/extension/unaccent--1.1.sql
  257. share/postgresql/extension/unaccent--unpackaged--1.0.sql
  258. share/postgresql/extension/unaccent.control
  259. share/postgresql/extension/uuid-ossp--1.0--1.1.sql
  260. share/postgresql/extension/uuid-ossp--1.1.sql
  261. share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
  262. share/postgresql/extension/uuid-ossp.control
  263. share/postgresql/extension/xml2--1.0--1.1.sql
  264. share/postgresql/extension/xml2--1.1.sql
  265. share/postgresql/extension/xml2--unpackaged--1.0.sql
  266. share/postgresql/extension/xml2.control
  267. share/postgresql/tsearch_data/unaccent.rules
  268. share/postgresql/tsearch_data/xsyn_sample.rules
  269. @owner
  270. @group
  271. @mode
Collapse this list.
Dependency lines:
  • postgresql12-contrib>0:databases/postgresql12-contrib
Conflicts:
CONFLICTS:
  • postgresql9*
  • postgresql1[^2]*
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port:
cd /usr/ports/databases/postgresql12-contrib/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/postgresql12-contrib
  • pkg install postgresql12-contrib
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql12-contrib
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1644361279 SHA256 (postgresql/postgresql-12.10.tar.bz2) = 83dd192e6034951192b9a86dc19cf3717a8b82120e2f11a0a36723c820d2b257 SIZE (postgresql/postgresql-12.10.tar.bz2) = 20990621
Packages (timestamps in pop-ups are UTC):
postgresql12-contrib
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest12.1812.1812.512.1812.18-12.5-
FreeBSD:13:quarterly12.1812.1812.1612.1812.1812.1712.1712.17
FreeBSD:14:latest12.1812.1812.1312.1812.1812.15-12.15
FreeBSD:14:quarterly12.1712.18-12.1712.1812.1712.1712.17
FreeBSD:15:latest12.1812.18n/a12.18n/a12.1712.1712.18
FreeBSD:15:quarterly--n/a-n/a---
Master port: databases/postgresql12-server
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. bison : devel/bison
  2. gmake>=4.3 : devel/gmake
Library dependencies:
  1. libxml2.so : textproc/libxml2
  2. libpq.so.5 : databases/postgresql12-client
There are no ports dependent upon this port
Configuration Options:
===> The following configuration options are available for postgresql12-contrib-12.10_2: DOCS=on: Build and/or install documentation OPENSSL=on: Build with OpenSSL support XML=on: XML format or parser support ===> Use 'make config' to modify these settings
Options name:
databases_postgresql12-contrib
USES:
bison pgsql:12 tar:bzip2 cpe gmake ssl compiler
pkg-message:
For install:
The PostgreSQL contrib utilities have been installed. Please see /usr/local/share/doc/postgresql/contrib/README for more information.
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://ftp.postgresql.org/pub/source/v12.10/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql12-server
CommitCreditsLog message
12.10_2
10 Apr 2022 19:47:23
commit hash: 035e778ee53345464c2d7466a3895e17073ad1f6commit hash: 035e778ee53345464c2d7466a3895e17073ad1f6commit hash: 035e778ee53345464c2d7466a3895e17073ad1f6commit hash: 035e778ee53345464c2d7466a3895e17073ad1f6 files touched by this commit		 Charlie Li (vishwin) search for other commits by this committer 
textproc/libxml2: bump all LIB_DEPENDS consumers

This is a separate and direct commit to quarterly as PORTREVISIONs
may not match from main.

PR: 262853, 262940, 262877
Approved by: fluffy (mentor)

Number of commits found: 1
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?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
ruby31Apr 23
ruby32Apr 23
ruby33Apr 23
glpiApr 22
glpiApr 22
glpiApr 22
sdl2_soundApr 22
chromiumApr 21
ungoogled-chromiumApr 21
clamavApr 19
jenkinsApr 19
jenkins-ltsApr 19
electron27Apr 18
electron28Apr 18
electron29Apr 18

19 vulnerabilities affecting 277 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2024-04-24 03:12:49 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 32217
Broken 86
Deprecated 180
Ignore 217
Forbidden 2
Restricted 2
No CDROM 1
Vulnerable 40
Expired 5
Set to expire 154
Interactive 0
new 24 hours 1
new 48 hours3
new 7 days15
new fortnight24
new month124
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2024 Dan Langille. All rights reserved.