postgresql11-contrib The contrib utilities from the PostgreSQL distribution

11.7 databases =3 11.6Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.

Maintainer: pgsql@FreeBSD.org

Port Added: 2018-10-19 21:32:27

Last Update: 2019-12-30 18:04:40

SVN Revision: 521556

License: PostgreSQL

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/

SVNWeb : Homepage

pkg-plist: as obtained via: make generate-plist

Expand this list (269 items)

1. /usr/local/share/licenses/postgresql11-contrib-11.7/catalog.mk
2. /usr/local/share/licenses/postgresql11-contrib-11.7/LICENSE
3. /usr/local/share/licenses/postgresql11-contrib-11.7/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/timetravel.so
55. lib/postgresql/tsm_system_rows.so
56. lib/postgresql/tsm_system_time.so
57. lib/postgresql/unaccent.so
58. lib/postgresql/uuid-ossp.so
59. share/doc/postgresql/README-contrib
60. share/doc/postgresql/extension/README
61. share/doc/postgresql/extension/autoinc.example
62. share/doc/postgresql/extension/insert_username.example
63. share/doc/postgresql/extension/moddatetime.example
64. share/doc/postgresql/extension/refint.example
65. share/doc/postgresql/extension/timetravel.example
66. share/postgresql/extension/adminpack--1.0--1.1.sql
67. share/postgresql/extension/adminpack--1.0.sql
68. share/postgresql/extension/adminpack--1.1--2.0.sql
69. share/postgresql/extension/adminpack.control
70. share/postgresql/extension/amcheck--1.0--1.1.sql
71. share/postgresql/extension/amcheck--1.0.sql
72. share/postgresql/extension/amcheck.control
73. share/postgresql/extension/autoinc--1.0.sql
74. share/postgresql/extension/autoinc--unpackaged--1.0.sql
75. share/postgresql/extension/autoinc.control
76. share/postgresql/extension/bloom--1.0.sql
77. share/postgresql/extension/bloom.control
78. share/postgresql/extension/btree_gin--1.0--1.1.sql
79. share/postgresql/extension/btree_gin--1.0.sql
80. share/postgresql/extension/btree_gin--1.1--1.2.sql
81. share/postgresql/extension/btree_gin--1.2--1.3.sql
82. share/postgresql/extension/btree_gin--unpackaged--1.0.sql
83. share/postgresql/extension/btree_gin.control
84. share/postgresql/extension/btree_gist--1.0--1.1.sql
85. share/postgresql/extension/btree_gist--1.1--1.2.sql
86. share/postgresql/extension/btree_gist--1.2--1.3.sql
87. share/postgresql/extension/btree_gist--1.2.sql
88. share/postgresql/extension/btree_gist--1.3--1.4.sql
89. share/postgresql/extension/btree_gist--1.4--1.5.sql
90. share/postgresql/extension/btree_gist--unpackaged--1.0.sql
91. share/postgresql/extension/btree_gist.control
92. share/postgresql/extension/citext--1.0--1.1.sql
93. share/postgresql/extension/citext--1.1--1.2.sql
94. share/postgresql/extension/citext--1.2--1.3.sql
95. share/postgresql/extension/citext--1.3--1.4.sql
96. share/postgresql/extension/citext--1.4--1.5.sql
97. share/postgresql/extension/citext--1.4.sql
98. share/postgresql/extension/citext--unpackaged--1.0.sql
99. share/postgresql/extension/citext.control
100. share/postgresql/extension/cube--1.0--1.1.sql
101. share/postgresql/extension/cube--1.1--1.2.sql
102. share/postgresql/extension/cube--1.2--1.3.sql
103. share/postgresql/extension/cube--1.2.sql
104. share/postgresql/extension/cube--1.3--1.4.sql
105. share/postgresql/extension/cube--unpackaged--1.0.sql
106. share/postgresql/extension/cube.control
107. share/postgresql/extension/dblink--1.0--1.1.sql
108. share/postgresql/extension/dblink--1.1--1.2.sql
109. share/postgresql/extension/dblink--1.2.sql
110. share/postgresql/extension/dblink--unpackaged--1.0.sql
111. share/postgresql/extension/dblink.control
112. share/postgresql/extension/dict_int--1.0.sql
113. share/postgresql/extension/dict_int--unpackaged--1.0.sql
114. share/postgresql/extension/dict_int.control
115. share/postgresql/extension/dict_xsyn--1.0.sql
116. share/postgresql/extension/dict_xsyn--unpackaged--1.0.sql
117. share/postgresql/extension/dict_xsyn.control
118. share/postgresql/extension/earthdistance--1.0--1.1.sql
119. share/postgresql/extension/earthdistance--1.1.sql
120. share/postgresql/extension/earthdistance--unpackaged--1.0.sql
121. share/postgresql/extension/earthdistance.control
122. share/postgresql/extension/file_fdw--1.0.sql
123. share/postgresql/extension/file_fdw.control
124. share/postgresql/extension/fuzzystrmatch--1.0--1.1.sql
125. share/postgresql/extension/fuzzystrmatch--1.1.sql
126. share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql
127. share/postgresql/extension/fuzzystrmatch.control
128. share/postgresql/extension/hstore--1.0--1.1.sql
129. share/postgresql/extension/hstore--1.1--1.2.sql
130. share/postgresql/extension/hstore--1.2--1.3.sql
131. share/postgresql/extension/hstore--1.3--1.4.sql
132. share/postgresql/extension/hstore--1.4--1.5.sql
133. share/postgresql/extension/hstore--1.4.sql
134. share/postgresql/extension/hstore--unpackaged--1.0.sql
135. share/postgresql/extension/hstore.control
136. share/postgresql/extension/insert_username--1.0.sql
137. share/postgresql/extension/insert_username--unpackaged--1.0.sql
138. share/postgresql/extension/insert_username.control
139. share/postgresql/extension/intagg--1.0--1.1.sql
140. share/postgresql/extension/intagg--1.1.sql
141. share/postgresql/extension/intagg--unpackaged--1.0.sql
142. share/postgresql/extension/intagg.control
143. share/postgresql/extension/intarray--1.0--1.1.sql
144. share/postgresql/extension/intarray--1.1--1.2.sql
145. share/postgresql/extension/intarray--1.2.sql
146. share/postgresql/extension/intarray--unpackaged--1.0.sql
147. share/postgresql/extension/intarray.control
148. share/postgresql/extension/isn--1.0--1.1.sql
149. share/postgresql/extension/isn--1.1--1.2.sql
150. share/postgresql/extension/isn--1.1.sql
151. share/postgresql/extension/isn--unpackaged--1.0.sql
152. share/postgresql/extension/isn.control
153. share/postgresql/extension/lo--1.0--1.1.sql
154. share/postgresql/extension/lo--1.1.sql
155. share/postgresql/extension/lo--unpackaged--1.0.sql
156. share/postgresql/extension/lo.control
157. share/postgresql/extension/ltree--1.0--1.1.sql
158. share/postgresql/extension/ltree--1.1.sql
159. share/postgresql/extension/ltree--unpackaged--1.0.sql
160. share/postgresql/extension/ltree.control
161. share/postgresql/extension/moddatetime--1.0.sql
162. share/postgresql/extension/moddatetime--unpackaged--1.0.sql
163. share/postgresql/extension/moddatetime.control
164. share/postgresql/extension/pageinspect--1.0--1.1.sql
165. share/postgresql/extension/pageinspect--1.1--1.2.sql
166. share/postgresql/extension/pageinspect--1.2--1.3.sql
167. share/postgresql/extension/pageinspect--1.3--1.4.sql
168. share/postgresql/extension/pageinspect--1.4--1.5.sql
169. share/postgresql/extension/pageinspect--1.5--1.6.sql
170. share/postgresql/extension/pageinspect--1.5.sql
171. share/postgresql/extension/pageinspect--1.6--1.7.sql
172. share/postgresql/extension/pageinspect--unpackaged--1.0.sql
173. share/postgresql/extension/pageinspect.control
174. share/postgresql/extension/pg_buffercache--1.0--1.1.sql
175. share/postgresql/extension/pg_buffercache--1.1--1.2.sql
176. share/postgresql/extension/pg_buffercache--1.2--1.3.sql
177. share/postgresql/extension/pg_buffercache--1.2.sql
178. share/postgresql/extension/pg_buffercache--unpackaged--1.0.sql
179. share/postgresql/extension/pg_buffercache.control
180. share/postgresql/extension/pg_freespacemap--1.0--1.1.sql
181. share/postgresql/extension/pg_freespacemap--1.1--1.2.sql
182. share/postgresql/extension/pg_freespacemap--1.1.sql
183. share/postgresql/extension/pg_freespacemap--unpackaged--1.0.sql
184. share/postgresql/extension/pg_freespacemap.control
185. share/postgresql/extension/pg_prewarm--1.0--1.1.sql
186. share/postgresql/extension/pg_prewarm--1.1--1.2.sql
187. share/postgresql/extension/pg_prewarm--1.1.sql
188. share/postgresql/extension/pg_prewarm.control
189. share/postgresql/extension/pg_stat_statements--1.0--1.1.sql
190. share/postgresql/extension/pg_stat_statements--1.1--1.2.sql
191. share/postgresql/extension/pg_stat_statements--1.2--1.3.sql
192. share/postgresql/extension/pg_stat_statements--1.3--1.4.sql
193. share/postgresql/extension/pg_stat_statements--1.4--1.5.sql
194. share/postgresql/extension/pg_stat_statements--1.4.sql
195. share/postgresql/extension/pg_stat_statements--1.5--1.6.sql
196. share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
197. share/postgresql/extension/pg_stat_statements.control
198. share/postgresql/extension/pg_trgm--1.0--1.1.sql
199. share/postgresql/extension/pg_trgm--1.1--1.2.sql
200. share/postgresql/extension/pg_trgm--1.2--1.3.sql
201. share/postgresql/extension/pg_trgm--1.3--1.4.sql
202. share/postgresql/extension/pg_trgm--1.3.sql
203. share/postgresql/extension/pg_trgm--unpackaged--1.0.sql
204. share/postgresql/extension/pg_trgm.control
205. share/postgresql/extension/pg_visibility--1.0--1.1.sql
206. share/postgresql/extension/pg_visibility--1.1--1.2.sql
207. share/postgresql/extension/pg_visibility--1.1.sql
208. share/postgresql/extension/pg_visibility.control
209. share/postgresql/extension/pgcrypto--1.0--1.1.sql
210. share/postgresql/extension/pgcrypto--1.1--1.2.sql
211. share/postgresql/extension/pgcrypto--1.2--1.3.sql
212. share/postgresql/extension/pgcrypto--1.3.sql
213. share/postgresql/extension/pgcrypto--unpackaged--1.0.sql
214. share/postgresql/extension/pgcrypto.control
215. share/postgresql/extension/pgrowlocks--1.0--1.1.sql
216. share/postgresql/extension/pgrowlocks--1.1--1.2.sql
217. share/postgresql/extension/pgrowlocks--1.2.sql
218. share/postgresql/extension/pgrowlocks--unpackaged--1.0.sql
219. share/postgresql/extension/pgrowlocks.control
220. share/postgresql/extension/pgstattuple--1.0--1.1.sql
221. share/postgresql/extension/pgstattuple--1.1--1.2.sql
222. share/postgresql/extension/pgstattuple--1.2--1.3.sql
223. share/postgresql/extension/pgstattuple--1.3--1.4.sql
224. share/postgresql/extension/pgstattuple--1.4--1.5.sql
225. share/postgresql/extension/pgstattuple--1.4.sql
226. share/postgresql/extension/pgstattuple--unpackaged--1.0.sql
227. share/postgresql/extension/pgstattuple.control
228. share/postgresql/extension/postgres_fdw--1.0.sql
229. share/postgresql/extension/postgres_fdw.control
230. share/postgresql/extension/refint--1.0.sql
231. share/postgresql/extension/refint--unpackaged--1.0.sql
232. share/postgresql/extension/refint.control
233. share/postgresql/extension/seg--1.0--1.1.sql
234. share/postgresql/extension/seg--1.1--1.2.sql
235. share/postgresql/extension/seg--1.1.sql
236. share/postgresql/extension/seg--1.2--1.3.sql
237. share/postgresql/extension/seg--unpackaged--1.0.sql
238. share/postgresql/extension/seg.control
239. share/postgresql/extension/sslinfo--1.0--1.1.sql
240. share/postgresql/extension/sslinfo--1.1--1.2.sql
241. share/postgresql/extension/sslinfo--1.2.sql
242. share/postgresql/extension/sslinfo--unpackaged--1.0.sql
243. share/postgresql/extension/sslinfo.control
244. share/postgresql/extension/tablefunc--1.0.sql
245. share/postgresql/extension/tablefunc--unpackaged--1.0.sql
246. share/postgresql/extension/tablefunc.control
247. share/postgresql/extension/tcn--1.0.sql
248. share/postgresql/extension/tcn.control
249. share/postgresql/extension/timetravel--1.0.sql
250. share/postgresql/extension/timetravel--unpackaged--1.0.sql
251. share/postgresql/extension/timetravel.control
252. share/postgresql/extension/tsm_system_rows--1.0.sql
253. share/postgresql/extension/tsm_system_rows.control
254. share/postgresql/extension/tsm_system_time--1.0.sql
255. share/postgresql/extension/tsm_system_time.control
256. share/postgresql/extension/unaccent--1.0--1.1.sql
257. share/postgresql/extension/unaccent--1.1.sql
258. share/postgresql/extension/unaccent--unpackaged--1.0.sql
259. share/postgresql/extension/unaccent.control
260. share/postgresql/extension/uuid-ossp--1.0--1.1.sql
261. share/postgresql/extension/uuid-ossp--1.1.sql
262. share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
263. share/postgresql/extension/uuid-ossp.control
264. share/postgresql/extension/xml2--1.0--1.1.sql
265. share/postgresql/extension/xml2--1.1.sql
266. share/postgresql/extension/xml2--unpackaged--1.0.sql
267. share/postgresql/extension/xml2.control
268. share/postgresql/tsearch_data/unaccent.rules
269. share/postgresql/tsearch_data/xsyn_sample.rules

Collapse this list.

Dependency lines:

• postgresql11-contrib>0:databases/postgresql11-contrib

Conflicts:

CONFLICTS:

• postgresql9*
• postgresql1[^1]*

Conflicts Matches:

There are no Conflicts Matches for this port. This is usually an error.

To install the port: cd /usr/ports/databases/postgresql11-contrib/ && make install clean

To add the package: pkg install postgresql11-contrib

PKGNAME: postgresql11-contrib

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1581419816 SHA256 (postgresql/postgresql-11.7.tar.bz2) = 324ae93a8846fbb6a25d562d271bc441ffa8794654c5b2839384834de220a313 SIZE (postgresql/postgresql-11.7.tar.bz2) = 19890063

Master port: databases/postgresql11-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 : devel/gmake

Library dependencies:

1. libxml2.so : textproc/libxml2
2. libpq.so.5 : databases/postgresql11-client

This port is required by:

for Build

1. databases/postgis25
2. databases/postgis30

for Run

1. databases/postgis25
2. databases/postgis30

Configuration Options

===> The following configuration options are available for postgresql11-contrib-11.7: 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

USES:

bison pgsql:11 tar:bzip2 cpe gmake ssl compiler

Master Sites:

1. https://ftp.postgresql.org/pub/source/v11.7/

postgresql{96,10,11}-contrib: Add an XML option

Avoids the libxml/libxslt2 dependency chain for systems that don't need
the XML datatype plugin.

PR:		239638
Approved by:	maintainer timeout (pgsql team, nearly 5 months)

iThe PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.5, 10.10,
9.6.15, 9.5.19, and 9.4.24, as well as the third beta of PostgreSQL 12.
This release fixes two security issues in the PostgreSQL server, two
security issues found in one of the PostgreSQL Windows installers, and
over 40 bugs reported since the previous release.

Users should install these updates as soon as possible.

A Note on the PostgreSQL 12 Beta
================================

In the spirit of the open source PostgreSQL community, we strongly
encourage you to test the new features of PostgreSQL 12 in your database
systems to help us eliminate any bugs or other issues that may exist.

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

- Optionize SSL support in postgresql11-contrib

PR:		233257
Submitted by:	amdmi3
Approved by:	maintainer timeout (pgsql, 7 weeks)

The PostgreSQL Global Development Group today announced the release of
PostgreSQL 11, the latest version of the world's most advanced open
source database.

PostgreSQL 11 provides users with improvements to overall performance of
the database system, with specific enhancements associated with very
large databases and high computational workloads. Further, PostgreSQL 11
makes significant improvements to the table partitioning system, adds
support for stored procedures capable of transaction management,
improves query parallelism and adds parallelized data definition
capabilities, and introduces just-in-time (JIT) compilation for
accelerating the execution of expressions in queries.

"For PostgreSQL 11, our development community focused on adding features
that improve PostgreSQL's ability to manage very large databases," said

9 vulnerabilities affecting 74 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2020-03-29 21:30:17