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
postgresql10-server PostgreSQL is the most advanced open-source database available anywhere
10.13_2 databases on this many watch lists=6 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port 10.12Version of this port present on the latest quarterly branch.
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-08-10 14:23:49
Last Update: 2020-05-17 21:37:04
SVN Revision: 535676

People watching this port, also watch: nginx, openssl, coreutils, smartmontools, pkg

License: PostgreSQL
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (850 items)
  1. /usr/local/share/licenses/postgresql10-server-10.13_2/catalog.mk
  2. /usr/local/share/licenses/postgresql10-server-10.13_2/LICENSE
  3. /usr/local/share/licenses/postgresql10-server-10.13_2/PostgreSQL
  4. bin/initdb
  5. bin/pg_archivecleanup
  6. bin/pg_basebackup
  7. bin/pg_controldata
  8. bin/pg_ctl
  9. bin/pg_receivewal
  10. bin/pg_recvlogical
  11. bin/pg_resetwal
  12. bin/pg_rewind
  13. bin/pg_test_fsync
  14. bin/pg_test_timing
  15. bin/pg_upgrade
  16. bin/pg_waldump
  17. bin/postgres
  18. bin/postmaster
  19. etc/periodic/daily/502.pgsql
  20. include/postgresql/server/plpgsql.h
  21. lib/postgresql/ascii_and_mic.so
  22. lib/postgresql/cyrillic_and_mic.so
  23. lib/postgresql/dict_snowball.so
  24. lib/postgresql/euc2004_sjis2004.so
  25. lib/postgresql/euc_cn_and_mic.so
  26. lib/postgresql/euc_jp_and_sjis.so
  27. lib/postgresql/euc_kr_and_mic.so
  28. lib/postgresql/euc_tw_and_big5.so
  29. lib/postgresql/latin2_and_win1250.so
  30. lib/postgresql/latin_and_mic.so
  31. lib/postgresql/libpqwalreceiver.so
  32. lib/postgresql/pgoutput.so
  33. lib/postgresql/plpgsql.so
  34. lib/postgresql/utf8_and_ascii.so
  35. lib/postgresql/utf8_and_big5.so
  36. lib/postgresql/utf8_and_cyrillic.so
  37. lib/postgresql/utf8_and_euc2004.so
  38. lib/postgresql/utf8_and_euc_cn.so
  39. lib/postgresql/utf8_and_euc_jp.so
  40. lib/postgresql/utf8_and_euc_kr.so
  41. lib/postgresql/utf8_and_euc_tw.so
  42. lib/postgresql/utf8_and_gb18030.so
  43. lib/postgresql/utf8_and_gbk.so
  44. lib/postgresql/utf8_and_iso8859.so
  45. lib/postgresql/utf8_and_iso8859_1.so
  46. lib/postgresql/utf8_and_johab.so
  47. lib/postgresql/utf8_and_sjis.so
  48. lib/postgresql/utf8_and_sjis2004.so
  49. lib/postgresql/utf8_and_uhc.so
  50. lib/postgresql/utf8_and_win.so
  51. lib/libpgcommon.a
  52. share/doc/postgresql/README-server
  53. share/postgresql/conversion_create.sql
  54. share/postgresql/information_schema.sql
  55. share/postgresql/pg_hba.conf.sample
  56. share/postgresql/pg_ident.conf.sample
  57. share/postgresql/postgres.bki
  58. share/postgresql/postgres.description
  59. share/postgresql/postgresql.conf.sample
  60. share/postgresql/recovery.conf.sample
  61. share/postgresql/sql_features.txt
  62. share/postgresql/system_views.sql
  63. share/postgresql/extension/plpgsql--1.0.sql
  64. share/postgresql/extension/plpgsql--unpackaged--1.0.sql
  65. share/postgresql/extension/plpgsql.control
  66. share/postgresql/postgres.shdescription
  67. share/locale/cs/LC_MESSAGES/initdb-10.mo
  68. share/locale/cs/LC_MESSAGES/pg_archivecleanup-10.mo
  69. share/locale/cs/LC_MESSAGES/pg_basebackup-10.mo
  70. share/locale/cs/LC_MESSAGES/pg_controldata-10.mo
  71. share/locale/cs/LC_MESSAGES/pg_ctl-10.mo
  72. share/locale/cs/LC_MESSAGES/pg_resetwal-10.mo
  73. share/locale/cs/LC_MESSAGES/pg_rewind-10.mo
  74. share/locale/cs/LC_MESSAGES/pg_test_fsync-10.mo
  75. share/locale/cs/LC_MESSAGES/pg_test_timing-10.mo
  76. share/locale/cs/LC_MESSAGES/pg_upgrade-10.mo
  77. share/locale/cs/LC_MESSAGES/pg_waldump-10.mo
  78. share/locale/cs/LC_MESSAGES/plpgsql-10.mo
  79. share/locale/de/LC_MESSAGES/initdb-10.mo
  80. share/locale/de/LC_MESSAGES/pg_archivecleanup-10.mo
  81. share/locale/de/LC_MESSAGES/pg_basebackup-10.mo
  82. share/locale/de/LC_MESSAGES/pg_controldata-10.mo
  83. share/locale/de/LC_MESSAGES/pg_ctl-10.mo
  84. share/locale/de/LC_MESSAGES/pg_resetwal-10.mo
  85. share/locale/de/LC_MESSAGES/pg_rewind-10.mo
  86. share/locale/de/LC_MESSAGES/pg_test_fsync-10.mo
  87. share/locale/de/LC_MESSAGES/pg_test_timing-10.mo
  88. share/locale/de/LC_MESSAGES/pg_upgrade-10.mo
  89. share/locale/de/LC_MESSAGES/pg_waldump-10.mo
  90. share/locale/de/LC_MESSAGES/plpgsql-10.mo
  91. share/locale/de/LC_MESSAGES/postgres-10.mo
  92. share/locale/es/LC_MESSAGES/initdb-10.mo
  93. share/locale/es/LC_MESSAGES/pg_archivecleanup-10.mo
  94. share/locale/es/LC_MESSAGES/pg_basebackup-10.mo
  95. share/locale/es/LC_MESSAGES/pg_controldata-10.mo
  96. share/locale/es/LC_MESSAGES/pg_ctl-10.mo
  97. share/locale/es/LC_MESSAGES/pg_resetwal-10.mo
  98. share/locale/es/LC_MESSAGES/pg_rewind-10.mo
  99. share/locale/es/LC_MESSAGES/pg_test_fsync-10.mo
  100. share/locale/es/LC_MESSAGES/pg_test_timing-10.mo
  101. share/locale/es/LC_MESSAGES/pg_upgrade-10.mo
  102. share/locale/es/LC_MESSAGES/pg_waldump-10.mo
  103. share/locale/es/LC_MESSAGES/plpgsql-10.mo
  104. share/locale/es/LC_MESSAGES/postgres-10.mo
  105. share/locale/fr/LC_MESSAGES/initdb-10.mo
  106. share/locale/fr/LC_MESSAGES/pg_archivecleanup-10.mo
  107. share/locale/fr/LC_MESSAGES/pg_basebackup-10.mo
  108. share/locale/fr/LC_MESSAGES/pg_controldata-10.mo
  109. share/locale/fr/LC_MESSAGES/pg_ctl-10.mo
  110. share/locale/fr/LC_MESSAGES/pg_resetwal-10.mo
  111. share/locale/fr/LC_MESSAGES/pg_rewind-10.mo
  112. share/locale/fr/LC_MESSAGES/pg_test_fsync-10.mo
  113. share/locale/fr/LC_MESSAGES/pg_test_timing-10.mo
  114. share/locale/fr/LC_MESSAGES/pg_upgrade-10.mo
  115. share/locale/fr/LC_MESSAGES/pg_waldump-10.mo
  116. share/locale/fr/LC_MESSAGES/plpgsql-10.mo
  117. share/locale/fr/LC_MESSAGES/postgres-10.mo
  118. share/locale/he/LC_MESSAGES/initdb-10.mo
  119. share/locale/he/LC_MESSAGES/pg_basebackup-10.mo
  120. share/locale/he/LC_MESSAGES/pg_ctl-10.mo
  121. share/locale/it/LC_MESSAGES/initdb-10.mo
  122. share/locale/it/LC_MESSAGES/pg_basebackup-10.mo
  123. share/locale/it/LC_MESSAGES/pg_controldata-10.mo
  124. share/locale/it/LC_MESSAGES/pg_ctl-10.mo
  125. share/locale/it/LC_MESSAGES/pg_rewind-10.mo
  126. share/locale/it/LC_MESSAGES/plpgsql-10.mo
  127. share/locale/it/LC_MESSAGES/postgres-10.mo
  128. share/locale/ja/LC_MESSAGES/initdb-10.mo
  129. share/locale/ja/LC_MESSAGES/pg_archivecleanup-10.mo
  130. share/locale/ja/LC_MESSAGES/pg_basebackup-10.mo
  131. share/locale/ja/LC_MESSAGES/pg_controldata-10.mo
  132. share/locale/ja/LC_MESSAGES/pg_ctl-10.mo
  133. share/locale/ja/LC_MESSAGES/pg_resetwal-10.mo
  134. share/locale/ja/LC_MESSAGES/pg_rewind-10.mo
  135. share/locale/ja/LC_MESSAGES/pg_test_fsync-10.mo
  136. share/locale/ja/LC_MESSAGES/pg_test_timing-10.mo
  137. share/locale/ja/LC_MESSAGES/pg_upgrade-10.mo
  138. share/locale/ja/LC_MESSAGES/pg_waldump-10.mo
  139. share/locale/ja/LC_MESSAGES/plpgsql-10.mo
  140. share/locale/ja/LC_MESSAGES/postgres-10.mo
  141. share/locale/ko/LC_MESSAGES/initdb-10.mo
  142. share/locale/ko/LC_MESSAGES/pg_archivecleanup-10.mo
  143. share/locale/ko/LC_MESSAGES/pg_basebackup-10.mo
  144. share/locale/ko/LC_MESSAGES/pg_controldata-10.mo
  145. share/locale/ko/LC_MESSAGES/pg_ctl-10.mo
  146. share/locale/ko/LC_MESSAGES/pg_resetwal-10.mo
  147. share/locale/ko/LC_MESSAGES/pg_rewind-10.mo
  148. share/locale/ko/LC_MESSAGES/pg_test_fsync-10.mo
  149. share/locale/ko/LC_MESSAGES/pg_test_timing-10.mo
  150. share/locale/ko/LC_MESSAGES/pg_upgrade-10.mo
  151. share/locale/ko/LC_MESSAGES/pg_waldump-10.mo
  152. share/locale/ko/LC_MESSAGES/plpgsql-10.mo
  153. share/locale/ko/LC_MESSAGES/postgres-10.mo
  154. share/locale/pl/LC_MESSAGES/initdb-10.mo
  155. share/locale/pl/LC_MESSAGES/pg_archivecleanup-10.mo
  156. share/locale/pl/LC_MESSAGES/pg_basebackup-10.mo
  157. share/locale/pl/LC_MESSAGES/pg_controldata-10.mo
  158. share/locale/pl/LC_MESSAGES/pg_ctl-10.mo
  159. share/locale/pl/LC_MESSAGES/pg_resetwal-10.mo
  160. share/locale/pl/LC_MESSAGES/pg_rewind-10.mo
  161. share/locale/pl/LC_MESSAGES/pg_test_fsync-10.mo
  162. share/locale/pl/LC_MESSAGES/pg_test_timing-10.mo
  163. share/locale/pl/LC_MESSAGES/plpgsql-10.mo
  164. share/locale/pl/LC_MESSAGES/postgres-10.mo
  165. share/locale/pt_BR/LC_MESSAGES/initdb-10.mo
  166. share/locale/pt_BR/LC_MESSAGES/pg_controldata-10.mo
  167. share/locale/pt_BR/LC_MESSAGES/pg_ctl-10.mo
  168. share/locale/pt_BR/LC_MESSAGES/pg_resetwal-10.mo
  169. share/locale/pt_BR/LC_MESSAGES/pg_rewind-10.mo
  170. share/locale/pt_BR/LC_MESSAGES/plpgsql-10.mo
  171. share/locale/ro/LC_MESSAGES/plpgsql-10.mo
  172. share/locale/ru/LC_MESSAGES/initdb-10.mo
  173. share/locale/ru/LC_MESSAGES/pg_archivecleanup-10.mo
  174. share/locale/ru/LC_MESSAGES/pg_basebackup-10.mo
  175. share/locale/ru/LC_MESSAGES/pg_controldata-10.mo
  176. share/locale/ru/LC_MESSAGES/pg_ctl-10.mo
  177. share/locale/ru/LC_MESSAGES/pg_resetwal-10.mo
  178. share/locale/ru/LC_MESSAGES/pg_rewind-10.mo
  179. share/locale/ru/LC_MESSAGES/pg_test_fsync-10.mo
  180. share/locale/ru/LC_MESSAGES/pg_test_timing-10.mo
  181. share/locale/ru/LC_MESSAGES/pg_upgrade-10.mo
  182. share/locale/ru/LC_MESSAGES/pg_waldump-10.mo
  183. share/locale/ru/LC_MESSAGES/plpgsql-10.mo
  184. share/locale/ru/LC_MESSAGES/postgres-10.mo
  185. share/locale/sv/LC_MESSAGES/initdb-10.mo
  186. share/locale/sv/LC_MESSAGES/pg_archivecleanup-10.mo
  187. share/locale/sv/LC_MESSAGES/pg_basebackup-10.mo
  188. share/locale/sv/LC_MESSAGES/pg_controldata-10.mo
  189. share/locale/sv/LC_MESSAGES/pg_ctl-10.mo
  190. share/locale/sv/LC_MESSAGES/pg_resetwal-10.mo
  191. share/locale/sv/LC_MESSAGES/pg_rewind-10.mo
  192. share/locale/sv/LC_MESSAGES/pg_test_fsync-10.mo
  193. share/locale/sv/LC_MESSAGES/pg_test_timing-10.mo
  194. share/locale/sv/LC_MESSAGES/pg_upgrade-10.mo
  195. share/locale/sv/LC_MESSAGES/pg_waldump-10.mo
  196. share/locale/sv/LC_MESSAGES/plpgsql-10.mo
  197. share/locale/sv/LC_MESSAGES/postgres-10.mo
  198. share/locale/tr/LC_MESSAGES/initdb-10.mo
  199. share/locale/tr/LC_MESSAGES/pg_archivecleanup-10.mo
  200. share/locale/tr/LC_MESSAGES/pg_basebackup-10.mo
  201. share/locale/tr/LC_MESSAGES/pg_controldata-10.mo
  202. share/locale/tr/LC_MESSAGES/pg_ctl-10.mo
  203. share/locale/tr/LC_MESSAGES/pg_resetwal-10.mo
  204. share/locale/tr/LC_MESSAGES/pg_rewind-10.mo
  205. share/locale/tr/LC_MESSAGES/pg_test_fsync-10.mo
  206. share/locale/tr/LC_MESSAGES/pg_test_timing-10.mo
  207. share/locale/tr/LC_MESSAGES/pg_upgrade-10.mo
  208. share/locale/tr/LC_MESSAGES/pg_waldump-10.mo
  209. share/locale/tr/LC_MESSAGES/plpgsql-10.mo
  210. share/locale/tr/LC_MESSAGES/postgres-10.mo
  211. share/locale/zh_CN/LC_MESSAGES/initdb-10.mo
  212. share/locale/zh_CN/LC_MESSAGES/pg_controldata-10.mo
  213. share/locale/zh_CN/LC_MESSAGES/pg_ctl-10.mo
  214. share/locale/zh_CN/LC_MESSAGES/pg_resetwal-10.mo
  215. share/locale/zh_CN/LC_MESSAGES/pg_rewind-10.mo
  216. share/locale/zh_CN/LC_MESSAGES/plpgsql-10.mo
  217. share/locale/zh_CN/LC_MESSAGES/postgres-10.mo
  218. share/locale/zh_TW/LC_MESSAGES/plpgsql-10.mo
  219. share/postgresql/snowball_create.sql
  220. @comment share/postgresql/timezone/Africa/Abidjan
  221. @comment share/postgresql/timezone/Africa/Accra
  222. @comment share/postgresql/timezone/Africa/Addis_Ababa
  223. @comment share/postgresql/timezone/Africa/Algiers
  224. @comment share/postgresql/timezone/Africa/Asmara
  225. @comment share/postgresql/timezone/Africa/Asmera
  226. @comment share/postgresql/timezone/Africa/Bamako
  227. @comment share/postgresql/timezone/Africa/Bangui
  228. @comment share/postgresql/timezone/Africa/Banjul
  229. @comment share/postgresql/timezone/Africa/Bissau
  230. @comment share/postgresql/timezone/Africa/Blantyre
  231. @comment share/postgresql/timezone/Africa/Brazzaville
  232. @comment share/postgresql/timezone/Africa/Bujumbura
  233. @comment share/postgresql/timezone/Africa/Cairo
  234. @comment share/postgresql/timezone/Africa/Casablanca
  235. @comment share/postgresql/timezone/Africa/Ceuta
  236. @comment share/postgresql/timezone/Africa/Conakry
  237. @comment share/postgresql/timezone/Africa/Dakar
  238. @comment share/postgresql/timezone/Africa/Dar_es_Salaam
  239. @comment share/postgresql/timezone/Africa/Djibouti
  240. @comment share/postgresql/timezone/Africa/Douala
  241. @comment share/postgresql/timezone/Africa/El_Aaiun
  242. @comment share/postgresql/timezone/Africa/Freetown
  243. @comment share/postgresql/timezone/Africa/Gaborone
  244. @comment share/postgresql/timezone/Africa/Harare
  245. @comment share/postgresql/timezone/Africa/Johannesburg
  246. @comment share/postgresql/timezone/Africa/Juba
  247. @comment share/postgresql/timezone/Africa/Kampala
  248. @comment share/postgresql/timezone/Africa/Khartoum
  249. @comment share/postgresql/timezone/Africa/Kigali
  250. @comment share/postgresql/timezone/Africa/Kinshasa
  251. @comment share/postgresql/timezone/Africa/Lagos
  252. @comment share/postgresql/timezone/Africa/Libreville
  253. @comment share/postgresql/timezone/Africa/Lome
  254. @comment share/postgresql/timezone/Africa/Luanda
  255. @comment share/postgresql/timezone/Africa/Lubumbashi
  256. @comment share/postgresql/timezone/Africa/Lusaka
  257. @comment share/postgresql/timezone/Africa/Malabo
  258. @comment share/postgresql/timezone/Africa/Maputo
  259. @comment share/postgresql/timezone/Africa/Maseru
  260. @comment share/postgresql/timezone/Africa/Mbabane
  261. @comment share/postgresql/timezone/Africa/Mogadishu
  262. @comment share/postgresql/timezone/Africa/Monrovia
  263. @comment share/postgresql/timezone/Africa/Nairobi
  264. @comment share/postgresql/timezone/Africa/Ndjamena
  265. @comment share/postgresql/timezone/Africa/Niamey
  266. @comment share/postgresql/timezone/Africa/Nouakchott
  267. @comment share/postgresql/timezone/Africa/Ouagadougou
  268. @comment share/postgresql/timezone/Africa/Porto-Novo
  269. @comment share/postgresql/timezone/Africa/Sao_Tome
  270. @comment share/postgresql/timezone/Africa/Timbuktu
  271. @comment share/postgresql/timezone/Africa/Tripoli
  272. @comment share/postgresql/timezone/Africa/Tunis
  273. @comment share/postgresql/timezone/Africa/Windhoek
  274. @comment share/postgresql/timezone/America/Adak
  275. @comment share/postgresql/timezone/America/Anchorage
  276. @comment share/postgresql/timezone/America/Anguilla
  277. @comment share/postgresql/timezone/America/Antigua
  278. @comment share/postgresql/timezone/America/Araguaina
  279. @comment share/postgresql/timezone/America/Argentina/Buenos_Aires
  280. @comment share/postgresql/timezone/America/Argentina/Catamarca
  281. @comment share/postgresql/timezone/America/Argentina/ComodRivadavia
  282. @comment share/postgresql/timezone/America/Argentina/Cordoba
  283. @comment share/postgresql/timezone/America/Argentina/Jujuy
  284. @comment share/postgresql/timezone/America/Argentina/La_Rioja
  285. @comment share/postgresql/timezone/America/Argentina/Mendoza
  286. @comment share/postgresql/timezone/America/Argentina/Rio_Gallegos
  287. @comment share/postgresql/timezone/America/Argentina/Salta
  288. @comment share/postgresql/timezone/America/Argentina/San_Juan
  289. @comment share/postgresql/timezone/America/Argentina/San_Luis
  290. @comment share/postgresql/timezone/America/Argentina/Tucuman
  291. @comment share/postgresql/timezone/America/Argentina/Ushuaia
  292. @comment share/postgresql/timezone/America/Aruba
  293. @comment share/postgresql/timezone/America/Asuncion
  294. @comment share/postgresql/timezone/America/Atikokan
  295. @comment share/postgresql/timezone/America/Atka
  296. @comment share/postgresql/timezone/America/Bahia
  297. @comment share/postgresql/timezone/America/Bahia_Banderas
  298. @comment share/postgresql/timezone/America/Barbados
  299. @comment share/postgresql/timezone/America/Belem
  300. @comment share/postgresql/timezone/America/Belize
  301. @comment share/postgresql/timezone/America/Blanc-Sablon
  302. @comment share/postgresql/timezone/America/Boa_Vista
  303. @comment share/postgresql/timezone/America/Bogota
  304. @comment share/postgresql/timezone/America/Boise
  305. @comment share/postgresql/timezone/America/Buenos_Aires
  306. @comment share/postgresql/timezone/America/Cambridge_Bay
  307. @comment share/postgresql/timezone/America/Campo_Grande
  308. @comment share/postgresql/timezone/America/Cancun
  309. @comment share/postgresql/timezone/America/Caracas
  310. @comment share/postgresql/timezone/America/Catamarca
  311. @comment share/postgresql/timezone/America/Cayenne
  312. @comment share/postgresql/timezone/America/Cayman
  313. @comment share/postgresql/timezone/America/Chicago
  314. @comment share/postgresql/timezone/America/Chihuahua
  315. @comment share/postgresql/timezone/America/Coral_Harbour
  316. @comment share/postgresql/timezone/America/Cordoba
  317. @comment share/postgresql/timezone/America/Costa_Rica
  318. @comment share/postgresql/timezone/America/Creston
  319. @comment share/postgresql/timezone/America/Cuiaba
  320. @comment share/postgresql/timezone/America/Curacao
  321. @comment share/postgresql/timezone/America/Danmarkshavn
  322. @comment share/postgresql/timezone/America/Dawson
  323. @comment share/postgresql/timezone/America/Dawson_Creek
  324. @comment share/postgresql/timezone/America/Denver
  325. @comment share/postgresql/timezone/America/Detroit
  326. @comment share/postgresql/timezone/America/Dominica
  327. @comment share/postgresql/timezone/America/Edmonton
  328. @comment share/postgresql/timezone/America/Eirunepe
  329. @comment share/postgresql/timezone/America/El_Salvador
  330. @comment share/postgresql/timezone/America/Ensenada
  331. @comment share/postgresql/timezone/America/Fort_Nelson
  332. @comment share/postgresql/timezone/America/Fort_Wayne
  333. @comment share/postgresql/timezone/America/Fortaleza
  334. @comment share/postgresql/timezone/America/Glace_Bay
  335. @comment share/postgresql/timezone/America/Godthab
  336. @comment share/postgresql/timezone/America/Goose_Bay
  337. @comment share/postgresql/timezone/America/Grand_Turk
  338. @comment share/postgresql/timezone/America/Grenada
  339. @comment share/postgresql/timezone/America/Guadeloupe
  340. @comment share/postgresql/timezone/America/Guatemala
  341. @comment share/postgresql/timezone/America/Guayaquil
  342. @comment share/postgresql/timezone/America/Guyana
  343. @comment share/postgresql/timezone/America/Halifax
  344. @comment share/postgresql/timezone/America/Havana
  345. @comment share/postgresql/timezone/America/Hermosillo
  346. @comment share/postgresql/timezone/America/Indiana/Indianapolis
  347. @comment share/postgresql/timezone/America/Indiana/Knox
  348. @comment share/postgresql/timezone/America/Indiana/Marengo
  349. @comment share/postgresql/timezone/America/Indiana/Petersburg
  350. @comment share/postgresql/timezone/America/Indiana/Tell_City
  351. @comment share/postgresql/timezone/America/Indiana/Vevay
  352. @comment share/postgresql/timezone/America/Indiana/Vincennes
  353. @comment share/postgresql/timezone/America/Indiana/Winamac
  354. @comment share/postgresql/timezone/America/Indianapolis
  355. @comment share/postgresql/timezone/America/Inuvik
  356. @comment share/postgresql/timezone/America/Iqaluit
  357. @comment share/postgresql/timezone/America/Jamaica
  358. @comment share/postgresql/timezone/America/Jujuy
  359. @comment share/postgresql/timezone/America/Juneau
  360. @comment share/postgresql/timezone/America/Kentucky/Louisville
  361. @comment share/postgresql/timezone/America/Kentucky/Monticello
  362. @comment share/postgresql/timezone/America/Knox_IN
  363. @comment share/postgresql/timezone/America/Kralendijk
  364. @comment share/postgresql/timezone/America/La_Paz
  365. @comment share/postgresql/timezone/America/Lima
  366. @comment share/postgresql/timezone/America/Los_Angeles
  367. @comment share/postgresql/timezone/America/Louisville
  368. @comment share/postgresql/timezone/America/Lower_Princes
  369. @comment share/postgresql/timezone/America/Maceio
  370. @comment share/postgresql/timezone/America/Managua
  371. @comment share/postgresql/timezone/America/Manaus
  372. @comment share/postgresql/timezone/America/Marigot
  373. @comment share/postgresql/timezone/America/Martinique
  374. @comment share/postgresql/timezone/America/Matamoros
  375. @comment share/postgresql/timezone/America/Mazatlan
  376. @comment share/postgresql/timezone/America/Mendoza
  377. @comment share/postgresql/timezone/America/Menominee
  378. @comment share/postgresql/timezone/America/Merida
  379. @comment share/postgresql/timezone/America/Metlakatla
  380. @comment share/postgresql/timezone/America/Mexico_City
  381. @comment share/postgresql/timezone/America/Miquelon
  382. @comment share/postgresql/timezone/America/Moncton
  383. @comment share/postgresql/timezone/America/Monterrey
  384. @comment share/postgresql/timezone/America/Montevideo
  385. @comment share/postgresql/timezone/America/Montreal
  386. @comment share/postgresql/timezone/America/Montserrat
  387. @comment share/postgresql/timezone/America/Nassau
  388. @comment share/postgresql/timezone/America/New_York
  389. @comment share/postgresql/timezone/America/Nipigon
  390. @comment share/postgresql/timezone/America/Nome
  391. @comment share/postgresql/timezone/America/Noronha
  392. @comment share/postgresql/timezone/America/North_Dakota/Beulah
  393. @comment share/postgresql/timezone/America/North_Dakota/Center
  394. @comment share/postgresql/timezone/America/North_Dakota/New_Salem
  395. @comment share/postgresql/timezone/America/Nuuk
  396. @comment share/postgresql/timezone/America/Ojinaga
  397. @comment share/postgresql/timezone/America/Panama
  398. @comment share/postgresql/timezone/America/Pangnirtung
  399. @comment share/postgresql/timezone/America/Paramaribo
  400. @comment share/postgresql/timezone/America/Phoenix
  401. @comment share/postgresql/timezone/America/Port-au-Prince
  402. @comment share/postgresql/timezone/America/Port_of_Spain
  403. @comment share/postgresql/timezone/America/Porto_Acre
  404. @comment share/postgresql/timezone/America/Porto_Velho
  405. @comment share/postgresql/timezone/America/Puerto_Rico
  406. @comment share/postgresql/timezone/America/Punta_Arenas
  407. @comment share/postgresql/timezone/America/Rainy_River
  408. @comment share/postgresql/timezone/America/Rankin_Inlet
  409. @comment share/postgresql/timezone/America/Recife
  410. @comment share/postgresql/timezone/America/Regina
  411. @comment share/postgresql/timezone/America/Resolute
  412. @comment share/postgresql/timezone/America/Rio_Branco
  413. @comment share/postgresql/timezone/America/Rosario
  414. @comment share/postgresql/timezone/America/Santa_Isabel
  415. @comment share/postgresql/timezone/America/Santarem
  416. @comment share/postgresql/timezone/America/Santiago
  417. @comment share/postgresql/timezone/America/Santo_Domingo
  418. @comment share/postgresql/timezone/America/Sao_Paulo
  419. @comment share/postgresql/timezone/America/Scoresbysund
  420. @comment share/postgresql/timezone/America/Shiprock
  421. @comment share/postgresql/timezone/America/Sitka
  422. @comment share/postgresql/timezone/America/St_Barthelemy
  423. @comment share/postgresql/timezone/America/St_Johns
  424. @comment share/postgresql/timezone/America/St_Kitts
  425. @comment share/postgresql/timezone/America/St_Lucia
  426. @comment share/postgresql/timezone/America/St_Thomas
  427. @comment share/postgresql/timezone/America/St_Vincent
  428. @comment share/postgresql/timezone/America/Swift_Current
  429. @comment share/postgresql/timezone/America/Tegucigalpa
  430. @comment share/postgresql/timezone/America/Thule
  431. @comment share/postgresql/timezone/America/Thunder_Bay
  432. @comment share/postgresql/timezone/America/Tijuana
  433. @comment share/postgresql/timezone/America/Toronto
  434. @comment share/postgresql/timezone/America/Tortola
  435. @comment share/postgresql/timezone/America/Vancouver
  436. @comment share/postgresql/timezone/America/Virgin
  437. @comment share/postgresql/timezone/America/Whitehorse
  438. @comment share/postgresql/timezone/America/Winnipeg
  439. @comment share/postgresql/timezone/America/Yakutat
  440. @comment share/postgresql/timezone/America/Yellowknife
  441. @comment share/postgresql/timezone/Antarctica/Casey
  442. @comment share/postgresql/timezone/Antarctica/Davis
  443. @comment share/postgresql/timezone/Antarctica/DumontDUrville
  444. @comment share/postgresql/timezone/Antarctica/Macquarie
  445. @comment share/postgresql/timezone/Antarctica/Mawson
  446. @comment share/postgresql/timezone/Antarctica/McMurdo
  447. @comment share/postgresql/timezone/Antarctica/Palmer
  448. @comment share/postgresql/timezone/Antarctica/Rothera
  449. @comment share/postgresql/timezone/Antarctica/South_Pole
  450. @comment share/postgresql/timezone/Antarctica/Syowa
  451. @comment share/postgresql/timezone/Antarctica/Troll
  452. @comment share/postgresql/timezone/Antarctica/Vostok
  453. @comment share/postgresql/timezone/Arctic/Longyearbyen
  454. @comment share/postgresql/timezone/Asia/Aden
  455. @comment share/postgresql/timezone/Asia/Almaty
  456. @comment share/postgresql/timezone/Asia/Amman
  457. @comment share/postgresql/timezone/Asia/Anadyr
  458. @comment share/postgresql/timezone/Asia/Aqtau
  459. @comment share/postgresql/timezone/Asia/Aqtobe
  460. @comment share/postgresql/timezone/Asia/Ashgabat
  461. @comment share/postgresql/timezone/Asia/Ashkhabad
  462. @comment share/postgresql/timezone/Asia/Atyrau
  463. @comment share/postgresql/timezone/Asia/Baghdad
  464. @comment share/postgresql/timezone/Asia/Bahrain
  465. @comment share/postgresql/timezone/Asia/Baku
  466. @comment share/postgresql/timezone/Asia/Bangkok
  467. @comment share/postgresql/timezone/Asia/Barnaul
  468. @comment share/postgresql/timezone/Asia/Beirut
  469. @comment share/postgresql/timezone/Asia/Bishkek
  470. @comment share/postgresql/timezone/Asia/Brunei
  471. @comment share/postgresql/timezone/Asia/Calcutta
  472. @comment share/postgresql/timezone/Asia/Chita
  473. @comment share/postgresql/timezone/Asia/Choibalsan
  474. @comment share/postgresql/timezone/Asia/Chongqing
  475. @comment share/postgresql/timezone/Asia/Chungking
  476. @comment share/postgresql/timezone/Asia/Colombo
  477. @comment share/postgresql/timezone/Asia/Dacca
  478. @comment share/postgresql/timezone/Asia/Damascus
  479. @comment share/postgresql/timezone/Asia/Dhaka
  480. @comment share/postgresql/timezone/Asia/Dili
  481. @comment share/postgresql/timezone/Asia/Dubai
  482. @comment share/postgresql/timezone/Asia/Dushanbe
  483. @comment share/postgresql/timezone/Asia/Famagusta
  484. @comment share/postgresql/timezone/Asia/Gaza
  485. @comment share/postgresql/timezone/Asia/Harbin
  486. @comment share/postgresql/timezone/Asia/Hebron
  487. @comment share/postgresql/timezone/Asia/Ho_Chi_Minh
  488. @comment share/postgresql/timezone/Asia/Hong_Kong
  489. @comment share/postgresql/timezone/Asia/Hovd
  490. @comment share/postgresql/timezone/Asia/Irkutsk
  491. @comment share/postgresql/timezone/Asia/Istanbul
  492. @comment share/postgresql/timezone/Asia/Jakarta
  493. @comment share/postgresql/timezone/Asia/Jayapura
  494. @comment share/postgresql/timezone/Asia/Jerusalem
  495. @comment share/postgresql/timezone/Asia/Kabul
  496. @comment share/postgresql/timezone/Asia/Kamchatka
  497. @comment share/postgresql/timezone/Asia/Karachi
  498. @comment share/postgresql/timezone/Asia/Kashgar
  499. @comment share/postgresql/timezone/Asia/Kathmandu
  500. @comment share/postgresql/timezone/Asia/Katmandu
  501. @comment share/postgresql/timezone/Asia/Khandyga
  502. @comment share/postgresql/timezone/Asia/Kolkata
  503. @comment share/postgresql/timezone/Asia/Krasnoyarsk
  504. @comment share/postgresql/timezone/Asia/Kuala_Lumpur
  505. @comment share/postgresql/timezone/Asia/Kuching
  506. @comment share/postgresql/timezone/Asia/Kuwait
  507. @comment share/postgresql/timezone/Asia/Macao
  508. @comment share/postgresql/timezone/Asia/Macau
  509. @comment share/postgresql/timezone/Asia/Magadan
  510. @comment share/postgresql/timezone/Asia/Makassar
  511. @comment share/postgresql/timezone/Asia/Manila
  512. @comment share/postgresql/timezone/Asia/Muscat
  513. @comment share/postgresql/timezone/Asia/Nicosia
  514. @comment share/postgresql/timezone/Asia/Novokuznetsk
  515. @comment share/postgresql/timezone/Asia/Novosibirsk
  516. @comment share/postgresql/timezone/Asia/Omsk
  517. @comment share/postgresql/timezone/Asia/Oral
  518. @comment share/postgresql/timezone/Asia/Phnom_Penh
  519. @comment share/postgresql/timezone/Asia/Pontianak
  520. @comment share/postgresql/timezone/Asia/Pyongyang
  521. @comment share/postgresql/timezone/Asia/Qatar
  522. @comment share/postgresql/timezone/Asia/Qostanay
  523. @comment share/postgresql/timezone/Asia/Qyzylorda
  524. @comment share/postgresql/timezone/Asia/Rangoon
  525. @comment share/postgresql/timezone/Asia/Riyadh
  526. @comment share/postgresql/timezone/Asia/Saigon
  527. @comment share/postgresql/timezone/Asia/Sakhalin
  528. @comment share/postgresql/timezone/Asia/Samarkand
  529. @comment share/postgresql/timezone/Asia/Seoul
  530. @comment share/postgresql/timezone/Asia/Shanghai
  531. @comment share/postgresql/timezone/Asia/Singapore
  532. @comment share/postgresql/timezone/Asia/Srednekolymsk
  533. @comment share/postgresql/timezone/Asia/Taipei
  534. @comment share/postgresql/timezone/Asia/Tashkent
  535. @comment share/postgresql/timezone/Asia/Tbilisi
  536. @comment share/postgresql/timezone/Asia/Tehran
  537. @comment share/postgresql/timezone/Asia/Tel_Aviv
  538. @comment share/postgresql/timezone/Asia/Thimbu
  539. @comment share/postgresql/timezone/Asia/Thimphu
  540. @comment share/postgresql/timezone/Asia/Tokyo
  541. @comment share/postgresql/timezone/Asia/Tomsk
  542. @comment share/postgresql/timezone/Asia/Ujung_Pandang
  543. @comment share/postgresql/timezone/Asia/Ulaanbaatar
  544. @comment share/postgresql/timezone/Asia/Ulan_Bator
  545. @comment share/postgresql/timezone/Asia/Urumqi
  546. @comment share/postgresql/timezone/Asia/Ust-Nera
  547. @comment share/postgresql/timezone/Asia/Vientiane
  548. @comment share/postgresql/timezone/Asia/Vladivostok
  549. @comment share/postgresql/timezone/Asia/Yakutsk
  550. @comment share/postgresql/timezone/Asia/Yangon
  551. @comment share/postgresql/timezone/Asia/Yekaterinburg
  552. @comment share/postgresql/timezone/Asia/Yerevan
  553. @comment share/postgresql/timezone/Atlantic/Azores
  554. @comment share/postgresql/timezone/Atlantic/Bermuda
  555. @comment share/postgresql/timezone/Atlantic/Canary
  556. @comment share/postgresql/timezone/Atlantic/Cape_Verde
  557. @comment share/postgresql/timezone/Atlantic/Faeroe
  558. @comment share/postgresql/timezone/Atlantic/Faroe
  559. @comment share/postgresql/timezone/Atlantic/Jan_Mayen
  560. @comment share/postgresql/timezone/Atlantic/Madeira
  561. @comment share/postgresql/timezone/Atlantic/Reykjavik
  562. @comment share/postgresql/timezone/Atlantic/South_Georgia
  563. @comment share/postgresql/timezone/Atlantic/St_Helena
  564. @comment share/postgresql/timezone/Atlantic/Stanley
  565. @comment share/postgresql/timezone/Australia/ACT
  566. @comment share/postgresql/timezone/Australia/Adelaide
  567. @comment share/postgresql/timezone/Australia/Brisbane
  568. @comment share/postgresql/timezone/Australia/Broken_Hill
  569. @comment share/postgresql/timezone/Australia/Canberra
  570. @comment share/postgresql/timezone/Australia/Currie
  571. @comment share/postgresql/timezone/Australia/Darwin
  572. @comment share/postgresql/timezone/Australia/Eucla
  573. @comment share/postgresql/timezone/Australia/Hobart
  574. @comment share/postgresql/timezone/Australia/LHI
  575. @comment share/postgresql/timezone/Australia/Lindeman
  576. @comment share/postgresql/timezone/Australia/Lord_Howe
  577. @comment share/postgresql/timezone/Australia/Melbourne
  578. @comment share/postgresql/timezone/Australia/NSW
  579. @comment share/postgresql/timezone/Australia/North
  580. @comment share/postgresql/timezone/Australia/Perth
  581. @comment share/postgresql/timezone/Australia/Queensland
  582. @comment share/postgresql/timezone/Australia/South
  583. @comment share/postgresql/timezone/Australia/Sydney
  584. @comment share/postgresql/timezone/Australia/Tasmania
  585. @comment share/postgresql/timezone/Australia/Victoria
  586. @comment share/postgresql/timezone/Australia/West
  587. @comment share/postgresql/timezone/Australia/Yancowinna
  588. @comment share/postgresql/timezone/Brazil/Acre
  589. @comment share/postgresql/timezone/Brazil/DeNoronha
  590. @comment share/postgresql/timezone/Brazil/East
  591. @comment share/postgresql/timezone/Brazil/West
  592. @comment share/postgresql/timezone/CET
  593. @comment share/postgresql/timezone/CST6CDT
  594. @comment share/postgresql/timezone/Canada/Atlantic
  595. @comment share/postgresql/timezone/Canada/Central
  596. @comment share/postgresql/timezone/Canada/Eastern
  597. @comment share/postgresql/timezone/Canada/Mountain
  598. @comment share/postgresql/timezone/Canada/Newfoundland
  599. @comment share/postgresql/timezone/Canada/Pacific
  600. @comment share/postgresql/timezone/Canada/Saskatchewan
  601. @comment share/postgresql/timezone/Canada/Yukon
  602. @comment share/postgresql/timezone/Chile/Continental
  603. @comment share/postgresql/timezone/Chile/EasterIsland
  604. @comment share/postgresql/timezone/Cuba
  605. @comment share/postgresql/timezone/EET
  606. @comment share/postgresql/timezone/EST
  607. @comment share/postgresql/timezone/EST5EDT
  608. @comment share/postgresql/timezone/Egypt
  609. @comment share/postgresql/timezone/Eire
  610. @comment share/postgresql/timezone/Etc/GMT
  611. @comment share/postgresql/timezone/Etc/GMT+0
  612. @comment share/postgresql/timezone/Etc/GMT+1
  613. @comment share/postgresql/timezone/Etc/GMT+10
  614. @comment share/postgresql/timezone/Etc/GMT+11
  615. @comment share/postgresql/timezone/Etc/GMT+12
  616. @comment share/postgresql/timezone/Etc/GMT+2
  617. @comment share/postgresql/timezone/Etc/GMT+3
  618. @comment share/postgresql/timezone/Etc/GMT+4
  619. @comment share/postgresql/timezone/Etc/GMT+5
  620. @comment share/postgresql/timezone/Etc/GMT+6
  621. @comment share/postgresql/timezone/Etc/GMT+7
  622. @comment share/postgresql/timezone/Etc/GMT+8
  623. @comment share/postgresql/timezone/Etc/GMT+9
  624. @comment share/postgresql/timezone/Etc/GMT-0
  625. @comment share/postgresql/timezone/Etc/GMT-1
  626. @comment share/postgresql/timezone/Etc/GMT-10
  627. @comment share/postgresql/timezone/Etc/GMT-11
  628. @comment share/postgresql/timezone/Etc/GMT-12
  629. @comment share/postgresql/timezone/Etc/GMT-13
  630. @comment share/postgresql/timezone/Etc/GMT-14
  631. @comment share/postgresql/timezone/Etc/GMT-2
  632. @comment share/postgresql/timezone/Etc/GMT-3
  633. @comment share/postgresql/timezone/Etc/GMT-4
  634. @comment share/postgresql/timezone/Etc/GMT-5
  635. @comment share/postgresql/timezone/Etc/GMT-6
  636. @comment share/postgresql/timezone/Etc/GMT-7
  637. @comment share/postgresql/timezone/Etc/GMT-8
  638. @comment share/postgresql/timezone/Etc/GMT-9
  639. @comment share/postgresql/timezone/Etc/GMT0
  640. @comment share/postgresql/timezone/Etc/Greenwich
  641. @comment share/postgresql/timezone/Etc/UCT
  642. @comment share/postgresql/timezone/Etc/UTC
  643. @comment share/postgresql/timezone/Etc/Universal
  644. @comment share/postgresql/timezone/Etc/Zulu
  645. @comment share/postgresql/timezone/Europe/Amsterdam
  646. @comment share/postgresql/timezone/Europe/Andorra
  647. @comment share/postgresql/timezone/Europe/Astrakhan
  648. @comment share/postgresql/timezone/Europe/Athens
  649. @comment share/postgresql/timezone/Europe/Belfast
  650. @comment share/postgresql/timezone/Europe/Belgrade
  651. @comment share/postgresql/timezone/Europe/Berlin
  652. @comment share/postgresql/timezone/Europe/Bratislava
  653. @comment share/postgresql/timezone/Europe/Brussels
  654. @comment share/postgresql/timezone/Europe/Bucharest
  655. @comment share/postgresql/timezone/Europe/Budapest
  656. @comment share/postgresql/timezone/Europe/Busingen
  657. @comment share/postgresql/timezone/Europe/Chisinau
  658. @comment share/postgresql/timezone/Europe/Copenhagen
  659. @comment share/postgresql/timezone/Europe/Dublin
  660. @comment share/postgresql/timezone/Europe/Gibraltar
  661. @comment share/postgresql/timezone/Europe/Guernsey
  662. @comment share/postgresql/timezone/Europe/Helsinki
  663. @comment share/postgresql/timezone/Europe/Isle_of_Man
  664. @comment share/postgresql/timezone/Europe/Istanbul
  665. @comment share/postgresql/timezone/Europe/Jersey
  666. @comment share/postgresql/timezone/Europe/Kaliningrad
  667. @comment share/postgresql/timezone/Europe/Kiev
  668. @comment share/postgresql/timezone/Europe/Kirov
  669. @comment share/postgresql/timezone/Europe/Lisbon
  670. @comment share/postgresql/timezone/Europe/Ljubljana
  671. @comment share/postgresql/timezone/Europe/London
  672. @comment share/postgresql/timezone/Europe/Luxembourg
  673. @comment share/postgresql/timezone/Europe/Madrid
  674. @comment share/postgresql/timezone/Europe/Malta
  675. @comment share/postgresql/timezone/Europe/Mariehamn
  676. @comment share/postgresql/timezone/Europe/Minsk
  677. @comment share/postgresql/timezone/Europe/Monaco
  678. @comment share/postgresql/timezone/Europe/Moscow
  679. @comment share/postgresql/timezone/Europe/Nicosia
  680. @comment share/postgresql/timezone/Europe/Oslo
  681. @comment share/postgresql/timezone/Europe/Paris
  682. @comment share/postgresql/timezone/Europe/Podgorica
  683. @comment share/postgresql/timezone/Europe/Prague
  684. @comment share/postgresql/timezone/Europe/Riga
  685. @comment share/postgresql/timezone/Europe/Rome
  686. @comment share/postgresql/timezone/Europe/Samara
  687. @comment share/postgresql/timezone/Europe/San_Marino
  688. @comment share/postgresql/timezone/Europe/Sarajevo
  689. @comment share/postgresql/timezone/Europe/Saratov
  690. @comment share/postgresql/timezone/Europe/Simferopol
  691. @comment share/postgresql/timezone/Europe/Skopje
  692. @comment share/postgresql/timezone/Europe/Sofia
  693. @comment share/postgresql/timezone/Europe/Stockholm
  694. @comment share/postgresql/timezone/Europe/Tallinn
  695. @comment share/postgresql/timezone/Europe/Tirane
  696. @comment share/postgresql/timezone/Europe/Tiraspol
  697. @comment share/postgresql/timezone/Europe/Ulyanovsk
  698. @comment share/postgresql/timezone/Europe/Uzhgorod
  699. @comment share/postgresql/timezone/Europe/Vaduz
  700. @comment share/postgresql/timezone/Europe/Vatican
  701. @comment share/postgresql/timezone/Europe/Vienna
  702. @comment share/postgresql/timezone/Europe/Vilnius
  703. @comment share/postgresql/timezone/Europe/Volgograd
  704. @comment share/postgresql/timezone/Europe/Warsaw
  705. @comment share/postgresql/timezone/Europe/Zagreb
  706. @comment share/postgresql/timezone/Europe/Zaporozhye
  707. @comment share/postgresql/timezone/Europe/Zurich
  708. @comment share/postgresql/timezone/Factory
  709. @comment share/postgresql/timezone/GB
  710. @comment share/postgresql/timezone/GB-Eire
  711. @comment share/postgresql/timezone/GMT
  712. @comment share/postgresql/timezone/GMT+0
  713. @comment share/postgresql/timezone/GMT-0
  714. @comment share/postgresql/timezone/GMT0
  715. @comment share/postgresql/timezone/Greenwich
  716. @comment share/postgresql/timezone/HST
  717. @comment share/postgresql/timezone/Hongkong
  718. @comment share/postgresql/timezone/Iceland
  719. @comment share/postgresql/timezone/Indian/Antananarivo
  720. @comment share/postgresql/timezone/Indian/Chagos
  721. @comment share/postgresql/timezone/Indian/Christmas
  722. @comment share/postgresql/timezone/Indian/Cocos
  723. @comment share/postgresql/timezone/Indian/Comoro
  724. @comment share/postgresql/timezone/Indian/Kerguelen
  725. @comment share/postgresql/timezone/Indian/Mahe
  726. @comment share/postgresql/timezone/Indian/Maldives
  727. @comment share/postgresql/timezone/Indian/Mauritius
  728. @comment share/postgresql/timezone/Indian/Mayotte
  729. @comment share/postgresql/timezone/Indian/Reunion
  730. @comment share/postgresql/timezone/Iran
  731. @comment share/postgresql/timezone/Israel
  732. @comment share/postgresql/timezone/Jamaica
  733. @comment share/postgresql/timezone/Japan
  734. @comment share/postgresql/timezone/Kwajalein
  735. @comment share/postgresql/timezone/Libya
  736. @comment share/postgresql/timezone/MET
  737. @comment share/postgresql/timezone/MST
  738. @comment share/postgresql/timezone/MST7MDT
  739. @comment share/postgresql/timezone/Mexico/BajaNorte
  740. @comment share/postgresql/timezone/Mexico/BajaSur
  741. @comment share/postgresql/timezone/Mexico/General
  742. @comment share/postgresql/timezone/NZ
  743. @comment share/postgresql/timezone/NZ-CHAT
  744. @comment share/postgresql/timezone/Navajo
  745. @comment share/postgresql/timezone/PRC
  746. @comment share/postgresql/timezone/PST8PDT
  747. @comment share/postgresql/timezone/Pacific/Apia
  748. @comment share/postgresql/timezone/Pacific/Auckland
  749. @comment share/postgresql/timezone/Pacific/Bougainville
  750. @comment share/postgresql/timezone/Pacific/Chatham
  751. @comment share/postgresql/timezone/Pacific/Chuuk
  752. @comment share/postgresql/timezone/Pacific/Easter
  753. @comment share/postgresql/timezone/Pacific/Efate
  754. @comment share/postgresql/timezone/Pacific/Enderbury
  755. @comment share/postgresql/timezone/Pacific/Fakaofo
  756. @comment share/postgresql/timezone/Pacific/Fiji
  757. @comment share/postgresql/timezone/Pacific/Funafuti
  758. @comment share/postgresql/timezone/Pacific/Galapagos
  759. @comment share/postgresql/timezone/Pacific/Gambier
  760. @comment share/postgresql/timezone/Pacific/Guadalcanal
  761. @comment share/postgresql/timezone/Pacific/Guam
  762. @comment share/postgresql/timezone/Pacific/Honolulu
  763. @comment share/postgresql/timezone/Pacific/Johnston
  764. @comment share/postgresql/timezone/Pacific/Kiritimati
  765. @comment share/postgresql/timezone/Pacific/Kosrae
  766. @comment share/postgresql/timezone/Pacific/Kwajalein
  767. @comment share/postgresql/timezone/Pacific/Majuro
  768. @comment share/postgresql/timezone/Pacific/Marquesas
  769. @comment share/postgresql/timezone/Pacific/Midway
  770. @comment share/postgresql/timezone/Pacific/Nauru
  771. @comment share/postgresql/timezone/Pacific/Niue
  772. @comment share/postgresql/timezone/Pacific/Norfolk
  773. @comment share/postgresql/timezone/Pacific/Noumea
  774. @comment share/postgresql/timezone/Pacific/Pago_Pago
  775. @comment share/postgresql/timezone/Pacific/Palau
  776. @comment share/postgresql/timezone/Pacific/Pitcairn
  777. @comment share/postgresql/timezone/Pacific/Pohnpei
  778. @comment share/postgresql/timezone/Pacific/Ponape
  779. @comment share/postgresql/timezone/Pacific/Port_Moresby
  780. @comment share/postgresql/timezone/Pacific/Rarotonga
  781. @comment share/postgresql/timezone/Pacific/Saipan
  782. @comment share/postgresql/timezone/Pacific/Samoa
  783. @comment share/postgresql/timezone/Pacific/Tahiti
  784. @comment share/postgresql/timezone/Pacific/Tarawa
  785. @comment share/postgresql/timezone/Pacific/Tongatapu
  786. @comment share/postgresql/timezone/Pacific/Truk
  787. @comment share/postgresql/timezone/Pacific/Wake
  788. @comment share/postgresql/timezone/Pacific/Wallis
  789. @comment share/postgresql/timezone/Pacific/Yap
  790. @comment share/postgresql/timezone/Poland
  791. @comment share/postgresql/timezone/Portugal
  792. @comment share/postgresql/timezone/ROC
  793. @comment share/postgresql/timezone/ROK
  794. @comment share/postgresql/timezone/Singapore
  795. @comment share/postgresql/timezone/Turkey
  796. @comment share/postgresql/timezone/UCT
  797. @comment share/postgresql/timezone/US/Alaska
  798. @comment share/postgresql/timezone/US/Aleutian
  799. @comment share/postgresql/timezone/US/Arizona
  800. @comment share/postgresql/timezone/US/Central
  801. @comment share/postgresql/timezone/US/East-Indiana
  802. @comment share/postgresql/timezone/US/Eastern
  803. @comment share/postgresql/timezone/US/Hawaii
  804. @comment share/postgresql/timezone/US/Indiana-Starke
  805. @comment share/postgresql/timezone/US/Michigan
  806. @comment share/postgresql/timezone/US/Mountain
  807. @comment share/postgresql/timezone/US/Pacific
  808. @comment share/postgresql/timezone/US/Samoa
  809. @comment share/postgresql/timezone/UTC
  810. @comment share/postgresql/timezone/Universal
  811. @comment share/postgresql/timezone/W-SU
  812. @comment share/postgresql/timezone/WET
  813. @comment share/postgresql/timezone/Zulu
  814. @comment share/postgresql/timezone/posixrules
  815. share/postgresql/timezonesets/Africa.txt
  816. share/postgresql/timezonesets/America.txt
  817. share/postgresql/timezonesets/Antarctica.txt
  818. share/postgresql/timezonesets/Asia.txt
  819. share/postgresql/timezonesets/Atlantic.txt
  820. share/postgresql/timezonesets/Australia
  821. share/postgresql/timezonesets/Australia.txt
  822. share/postgresql/timezonesets/Default
  823. share/postgresql/timezonesets/Etc.txt
  824. share/postgresql/timezonesets/Europe.txt
  825. share/postgresql/timezonesets/India
  826. share/postgresql/timezonesets/Indian.txt
  827. share/postgresql/timezonesets/Pacific.txt
  828. share/postgresql/tsearch_data/danish.stop
  829. share/postgresql/tsearch_data/dutch.stop
  830. share/postgresql/tsearch_data/english.stop
  831. share/postgresql/tsearch_data/finnish.stop
  832. share/postgresql/tsearch_data/french.stop
  833. share/postgresql/tsearch_data/german.stop
  834. share/postgresql/tsearch_data/hungarian.stop
  835. share/postgresql/tsearch_data/hunspell_sample.affix
  836. share/postgresql/tsearch_data/hunspell_sample_long.affix
  837. share/postgresql/tsearch_data/hunspell_sample_long.dict
  838. share/postgresql/tsearch_data/hunspell_sample_num.affix
  839. share/postgresql/tsearch_data/hunspell_sample_num.dict
  840. share/postgresql/tsearch_data/ispell_sample.affix
  841. share/postgresql/tsearch_data/ispell_sample.dict
  842. share/postgresql/tsearch_data/italian.stop
  843. share/postgresql/tsearch_data/norwegian.stop
  844. share/postgresql/tsearch_data/portuguese.stop
  845. share/postgresql/tsearch_data/russian.stop
  846. share/postgresql/tsearch_data/spanish.stop
  847. share/postgresql/tsearch_data/swedish.stop
  848. share/postgresql/tsearch_data/synonym_sample.syn
  849. share/postgresql/tsearch_data/thesaurus_sample.ths
  850. share/postgresql/tsearch_data/turkish.stop
Collapse this list.
Dependency lines:
  • postgresql10-server>0:databases/postgresql10-server
Conflicts:
CONFLICTS:
  • postgresql9*
  • postgresql1[^0]*
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port: cd /usr/ports/databases/postgresql10-server/ && make install clean
To add the package: pkg install postgresql10-server
PKGNAME: postgresql10-server
Flavors: there is no flavor information for this port.
distinfo:
Packages:
postgresql10-server
ABIlatestquarterly
FreeBSD:11:aarch6410.510.12_1
FreeBSD:11:amd6410.13_210.12_1
FreeBSD:11:i38610.13_210.12_1
FreeBSD:12:aarch6410.510.12_1
FreeBSD:12:amd6410.13_210.12_1
FreeBSD:12:i38610.13_210.12_1
FreeBSD:13:aarch6410.12_2-
FreeBSD:13:amd6410.13_2-
FreeBSD:13:i38610.13_2-
 

Slave ports
  1. databases/postgresql10-client
  2. databases/postgresql10-contrib
  3. databases/postgresql10-docs
  4. databases/postgresql10-plperl
  5. databases/postgresql10-plpython
  6. databases/postgresql10-pltcl

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. msgfmt : devel/gettext-tools
Library dependencies:
  1. libicudata.so : devel/icu
  2. libpq.so.5 : databases/postgresql10-client
  3. libintl.so : devel/gettext-runtime
This port is required by:
for Build
  1. databases/postgresql10-plpython
  2. databases/postgresql10-pltcl
for Run
  1. databases/postgresql10-plperl
  2. databases/postgresql10-plpython
  3. databases/postgresql10-pltcl

Configuration Options

USES:

Master Sites:
  1. https://ftp.postgresql.org/pub/source/v10.13/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2012-05-30
    Affects: users of databases/postgresql*-server
    Author: jgh@FreeBSD.org
    Reason: 
      Affected users are those who use the crypt(text, text) function with
      DES encryption in the optional pg_crypto module. Passwords affected
      are those that contain characters that cannot be represented with
      7-bit ASCII. If a password contains a character that has the most
      significant bit set (0x80), and DES encryption is used, that character
      and all characters after it will be ignored.
    
    

Number of commits found: 41

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
17 May 2020 20:37:04
Original commit files touched by this commit  10.13_2
Revision:535676
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 12.3, 11.8, 10.13,
9.6.18, and 9.5.22.  This release fixes one security issue found in the
PostgreSQL server and over 75 bugs reported over the last three months.

Please plan to update at your earliest convenience.

Update the backup warning text. [1]

Add plpython and plperl libs for hstore, jsonb and ltree for the versions where
they exist. These libs are added to the postgresql??-plpython and -plperl
ports, inspired by [2].

PR:		237910 [1], 245246 [2]
Submitted by:	Francesco [1], Loic Bartoletti [2]
23 Apr 2020 20:14:49
Original commit files touched by this commit  10.12_2
Revision:532707
jbeich search for other commits by this committer
devel/icu: update to 67.1

Changes:	http://site.icu-project.org/download/67
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
Reported by:	GitHub (watch releases)
13 Mar 2020 09:54:52
Original commit files touched by this commit  10.12_1
Revision:528344
jbeich search for other commits by this committer
Fix up PORTREVISION style after "portedit bump-revision"
13 Mar 2020 09:47:17
Original commit files touched by this commit  10.12_1
Revision:528343
jbeich search for other commits by this committer
devel/icu: update to 66.1

Changes:	http://site.icu-project.org/download/66
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
13 Feb 2020 19:14:37
Original commit files touched by this commit  10.12
Revision:526063
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 12.2, 11.7, 10.12,
9.6.17, 9.5.21, and 9.4.26. This release fixes one security issue found
in the PostgreSQL server and over 75 bugs reported over the last three
months.

Users should plan to update as soon as possible.

PostgreSQL 9.4 Now EOL

This is the last release for PostgreSQL 9.4, which will no longer
receive security updates and bug fixes. PostgreSQL 9.4 introduced new
features such as JSONB support, the `ALTER SYSTEM` command, the ability
to stream logical changes to an output plugin, and more:
(Only the first 15 lines of the commit message are shown above View all of this commit message)
30 Dec 2019 18:04:40
Original commit files touched by this commit  10.11
Revision:521556 This port version is marked as vulnerable.
adamw search for other commits by this committer
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)
14 Nov 2019 16:24:45
Original commit files touched by this commit  10.11
Revision:517600 This port version is marked as vulnerable.
girgen search for other commits by this committer
Upgrade PostgreSQL

The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 12.1, 11.6, 10.11,
9.6.16, 9.5.20, and 9.4.25. This release fixes over 50 bugs reported
over the last three months.

PostgreSQL 9.4 will stop receiving fixes on February 13, 2020, which is
the next planned cumulative update release. We suggest that you make
plans to upgrade to a newer, supported version of PostgreSQL. Please see
our versioning policy for more information:

This update also fixes over 50 bugs that were reported in the last
several months. Some of these issues affect only version 12, but may
also affect all supported versions.

Specific change to the FreeBSD port:
Starting now, the default for TZDATA has changed to using the underlying OS'
time zone database instead of the one built in to PostgreSQL. This change is
made since PostgreSQL will not release a patch in the event where the time zone
database changes, whereas FreeBSD will.

Release notes:	https://www.postgresql.org/about/news/1994/
URL:		https://www.postgresql.org/support/versioning/
03 Oct 2019 20:35:30
Original commit files touched by this commit  10.10_1
Revision:513733 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/icu: update to 65.1

Changes:	http://site.icu-project.org/download/65
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
13 Aug 2019 16:01:59
Original commit files touched by this commit  10.10
Revision:508835  Sanity Test Failure This port version is marked as vulnerable.
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
08 Aug 2019 15:33:03
Original commit files touched by this commit  10.10
Revision:508390 This port version is marked as vulnerable.
girgen search for other commits by this committer
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.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
26 Jul 2019 20:46:57
Original commit files touched by this commit  10.9_1
Revision:507372 This port version is marked as vulnerable.
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
27 Jun 2019 21:28:00
Original commit files touched by this commit  10.9
Revision:505245 This port version is marked as vulnerable.
girgen search for other commits by this committer
Upgrade PostgreSQL to latest version

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 11.4, 10.9, 9.6.14, 9.5.18, and
9.4.23, as well as the second beta of PostgreSQL 12. This release fixes one
security issue and over 25 bugs since the previous cumulative update in May.

This release is made outside of the normal update release schedule as the
security vulnerability was determined to be critical enough to distribute the
fix as quickly as possible. Users who are running PostgreSQL 10, PostgreSQL 11,
or the PostgreSQL 12 beta should upgrade as soon as possible.

All other users should plan to apply this update at the next scheduled
downtime.

Release notes:	https://www.postgresql.org/about/news/1949/
Security:	245629d4-991e-11e9-82aa-6cc21735f730
09 May 2019 22:32:11
Original commit files touched by this commit  10.8
Revision:501149 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.3, 10.8, 9.6.13,
9.5.17, and 9.4.22. This release fixes two security issues in the
PostgreSQL server, a security issue found in two of the PostgreSQL
Windows installers, and over 60 bugs reported over the last three months.

Security:	CVE-2019-10129: Memory disclosure in partition routing

Prior to this release, a user running PostgreSQL 11 can read arbitrary
bytes of server memory by executing a purpose-crafted INSERT statement
to a partitioned table.

Security:	CVE-2019-10130: Selectivity estimators bypass row security policies

PostgreSQL maintains statistics for tables by sampling data available in
(Only the first 15 lines of the commit message are shown above View all of this commit message)
25 Apr 2019 18:34:42
Original commit files touched by this commit  10.7_2
Revision:500060 This port version is marked as vulnerable.
crees search for other commits by this committer
Don't overwrite PORTREVISION from the slave, following readline update.

I've had to bump revision for several slaves here, but most will not
be rebuilt, except the -client slaves.  Apologies for anyone having
to rebuild -clients unnecessarily, but it's not a heavy task- better safe
than sorry.

PR:		ports/236156
Reported by:	Andrew Dunstan (PostgreSQL), koobs, Dmitri Goutnik
27 Mar 2019 21:11:09
Original commit files touched by this commit  10.7_1
Revision:496981 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/icu: update to 64.1

Changes:	http://site.icu-project.org/download/64
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		236325
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D19479
15 Feb 2019 15:45:23
Original commit files touched by this commit  10.7_1
Revision:493002 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix mistake in previous commit about postgres username
15 Feb 2019 11:02:22
Original commit files touched by this commit  10.7
Revision:492989 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.2, 10.7, 9.6.12,
9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL
interfaces with `fsync()` and includes fixes for partitioning and over
70 other bugs that were reported over the past three months.

Users should plan to apply this update at the next scheduled downtime.

FreeBSD port adds OPTIONS knob to support LLVM JIT. [1]

Highlight: Change in behavior with fsync()
------------------------------------------

When available in an operating system and enabled in the configuration
file (which it is by default), PostgreSQL uses the kernel function
(Only the first 15 lines of the commit message are shown above View all of this commit message)
12 Dec 2018 01:35:36
Original commit files touched by this commit  10.6_2
Revision:487272 This port version is marked as vulnerable.
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

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, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
12 Nov 2018 15:54:20
Original commit files touched by this commit  10.6_1
Revision:484807 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix build problems on i386

Use GCC seems to be proper way to do it. SSE2 would not be available for all
CPU:s.
08 Nov 2018 23:21:19
Original commit files touched by this commit  10.6_1
Revision:484488 This port version is marked as vulnerable.
girgen search for other commits by this committer
Posted on 2018-11-08 by PostgreSQL Global Development Group The PostgreSQL
Global Development Group has released an update to all supported versions of
our database system, including 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25.
This release fixes one security issue as well as bugs reported over the last
three months.

All users using the affected versions of PostgreSQL should update as soon as
possible. Please see the notes on "Updating" below for any post-update steps
that may be required if you are using pg_stat_statements in your installation.

This update is also the final release for PostgreSQL 9.3, which is now
end-of-life and will no longer receive any bug or security fixes. If your
environment still uses PostgreSQL 9.3, please make plans to update to a
community supported version as soon as possible. Please see our versioning
policy for more information.

Releasenotes:	https://www.postgresql.org/about/news/1905/
Security:	1c27a706-e3aa-11e8-b77a-6cc21735f730
Security:	CVE-2018-16850
23 Oct 2018 11:35:04
Original commit files touched by this commit  10.5_1
Revision:482830 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/icu: update to 63.1

Changes:	http://site.icu-project.org/download/63
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		232300
Exp-run by:	antoine
10 Sep 2018 13:14:52
Original commit files touched by this commit  10.5
Revision:479406 This port version is marked as vulnerable.
mat search for other commits by this committer
Add DOCS options to ports that should have one.

Also various fixes related to said option.

PR:		230864
Submitted by:	mat
exp-runs by:	antoine
10 Aug 2018 09:25:20
Original commit files touched by this commit  10.5
Revision:476819 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.5, 9.6.10, 9.5.14, 9.4.19,
9.3.24.  This release fixes two security issues as well as bugs reported over
the last three months.

If you have untrusted users accessing your system and you are either running
PostgreSQL 9.5 or a newer version OR have installed the "dblink" or
"postgres_fdw" extensions, you must apply this update as soon as possible. All
other users can upgrade at the next convenient downtime.

Please note that PostgreSQL changed its versioning scheme with the release of
version 10.0, so updating to version 10.5 from any 10.x release is considered a
minor update.

The PostgreSQL Global Development Group also announces that the third beta
(Only the first 15 lines of the commit message are shown above View all of this commit message)
29 Jun 2018 14:22:11
Original commit files touched by this commit  10.4_1
Revision:473551 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/icu: update to 62.1

Changes:	http://site.icu-project.org/download/62
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		229359
Exp-run by:	antoine (only 10.4)
11 May 2018 13:10:52
Original commit files touched by this commit  10.4
Revision:469638 This port version is marked as vulnerable.
girgen search for other commits by this committer
Up

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.4, 9.6.9, 9.5.13, 9.4.18, 9.3.23.
This release fixes one security issue as well as several bugs reported over the
last three months. Users should plan to update at the next convenient downtime.

Please see the "Updating" section for post-installation steps for the security
fix and the "incorrect volatility and parallel-safety markings" fix.

Releasenotes:	https://www.postgresql.org/about/news/1851/
Security:	CVE-2018-1115 Too-permissive access control list on function
pg_logfile_rotate()

FreeBSD's port of PostgreSQL uses syslog by default, so the above security
problem is only a problem if you changed the logging configuration. Please
visit the releasenotes linked above and take the actions needed.
07 May 2018 19:21:01
Original commit files touched by this commit  10.3_1
Revision:469321 This port version is marked as vulnerable.
sunpoet search for other commits by this committer
Update WWW

Approved by:	portmgr (blanket)
06 Apr 2018 15:53:17
Original commit files touched by this commit  10.3_1
Revision:466648 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/icu: update to 61.1

Changes:	http://site.icu-project.org/download/61
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		227042
Exp-run by:	antoine
MFH:		2018Q2 (required by Firefox 61)
01 Mar 2018 15:10:17
Original commit files touched by this commit  10.3
Revision:463327 This port version is marked as vulnerable.
girgen search for other commits by this committer
2018-03-01 Security Update Release

The PostgreSQL Global Development Group has released an update to all supported
versions of the PostgreSQL database system, including 10.3, 9.6.8, 9.5.12,
9.4.17, and 9.3.22.

The purpose of this release is to address CVE-2018-1058, which describes how a
user can create like-named objects in different schemas that can change the
behavior of other users' queries and cause unexpected or malicious behavior,
also known as a "trojan-horse" attack. Most of this release centers around added
documentation that describes the issue and how to take steps to mitigate the
impact on PostgreSQL databases.

We strongly encourage all of our users to please visit
https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path
for a detailed explanation of CVE-2018-1058 and how to protect your PostgreSQL
installations.

After evaluating the documentation for CVE-2018-1058, a database administrator
may need to take follow up steps on their PostgreSQL installations to ensure
they are protected from exploitation.

Security:	CVE-2018-1058
15 Feb 2018 14:41:29
Original commit files touched by this commit  10.2
Revision:461928 This port version is marked as vulnerable.
brnrd search for other commits by this committer
security/openssl-devel: Remove BROKEN from some ports

 * databases/freetds: Fixed 2017-02-14
 * databases/postgresql10-server: Fixed 2016-09-15 [1]
 * ftp/lftp: Fixed in 4.8.0
 * ftp/proftpd: Fixed in 1.3.5c
 * ftp/wget: Fixed in 1.19.3 [2]
 * lang/erlang-runtime20: Fixed in 20.0
 * net/socat: Fixed in 1.7.3.2
 * security/libssh2: Fixed in 1.8.0 [3]
 * security/p5-Crypt-OpenSSL-X509: Fixed in 1.8.8
 * sysutils/bacula9-server: Fixed in 9.0.6
 * www/nginx: Fixed in 1.9.14

 * Bulk build OK 10.3/11.1 both i386 and amd64:
    - multimedia/librtmp
    - net/libvncserver
    - www/lynx

PR:		225875 [1], 225872 [2], 225873 [3]
08 Feb 2018 19:58:22
Original commit files touched by this commit  10.2
Revision:461263 This port version is marked as vulnerable.
antoine search for other commits by this committer
Remove DTRACE from OPTIONS_DEFAULT, causes segmentation fault during build

With hat:	portmgr
08 Feb 2018 17:38:36
Original commit files touched by this commit  10.2
Revision:461251 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update to latest versions of PostgreSQL

2018-02-08 Security Update Release
==================================

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.2, 9.6.7, 9.5.11, 9.4.16, 9.3.21.
This release fixes two security issues. This release also fixes issues with
VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as
well as fixes for using parallel queries and logical replication.

All users using the affected versions of PostgreSQL should update as soon as
possible. Please see the notes on "Updating" below for any post-update steps
that may be required.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
30 Jan 2018 13:45:50
Original commit files touched by this commit  10.1_1
Revision:460386 This port version is marked as vulnerable.
mat search for other commits by this committer
Fix ICU depend for postgresql10-server.

PR:		225049
Submitted by:	mat
Approved by:	maintainer timeout
Sponsored by:	Absolight
20 Dec 2017 22:09:08
Original commit files touched by this commit  10.1_1
Revision:456862 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix problem with logical replication

PR:	224466
09 Nov 2017 16:11:21
Original commit files touched by this commit  10.1
Revision:453847 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update to latest versions of PostgreSQL

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20,
and 9.2.24. This release fixes three security issues. This release also fixes
issues found in BRIN indexing, logical replication and other bugs reported over
the past three months.

Please note that the CVE-2017-12172 does not affect the FreeBSD port unless you
decided to not use the contrib/startscript instead of the startscript
distributed with the FreeBSD port/package.

Security:	CVE-2017-12172, CVE-2017-15099, CVE-2017-15098
URL:		https://www.postgresql.org/about/news/1801/
15 Oct 2017 17:53:04
Original commit files touched by this commit  10.0_1
Revision:452158 This port version is marked as vulnerable.
bapt search for other commits by this committer
Recommand psycopg2 over PyGreSQL

Submitted by:	Christoph Moench-Tegeder <cmt@burggraben.net>
08 Oct 2017 16:39:59
Original commit files touched by this commit  10.0_1
Revision:451550 This port version is marked as vulnerable.
girgen search for other commits by this committer
PostgreSQL has renamed wal as xlog to avoid human errors.

This has caused some binaries to change names. Fix the port so they will be
installed again with their new names.

Noticed by:	VoidChicken@gmail.com
PR:		222864
05 Oct 2017 13:39:45
Original commit files touched by this commit  10.0
Revision:451310 This port version is marked as vulnerable.
girgen search for other commits by this committer
PostgreSQL 10 Released!

Some highlights:

Logical Replication - A publish/subscribe framework for distributing data
Declarative Table Partitioning - Convenience in dividing your data
Improved Query Parallelism - Quickly conquer your analysis
Quorum Commit for Synchronous Replication - Distribute data with confidence
SCRAM-SHA-256 authentication - Secure your data access

URL:	https://www.postgresql.org/about/news/1786/
24 Sep 2017 18:58:59
Original commit files touched by this commit  10.r1_1
Revision:450532 This port version is marked as vulnerable.
girgen search for other commits by this committer
Correct default data directory for postgresql 10

...and make sure not to bump portrevision more than necessary.

POINTED OUT BY: Peter Laursen
21 Sep 2017 13:43:01
Original commit files touched by this commit  10.r1
Revision:450258 This port version is marked as vulnerable.
girgen search for other commits by this committer
Upgrading to RC 1

PostgreSQL 10 RC 1 requires an upgrade from beta 4, or earlier either
using pg_dump / pg_restore or pg_upgrade.

Any bug fixes applied to 9.6 or earlier that also affected 10 are
included in RC 1, as well issues that were reported with Beta 4.

Changes Since Beta 4

PostgreSQL 10 RC 1 contains fixes for issues discovered by users when
testing Beta 4, including:

* Add psql variables showing server version and psql version.
* Several fixes for partitioning
* Several fixes for logical replication
* Several fixes for transition tables
* Fix for query that could end up in an uninterruptible state

Note that some known issues remain unfixed.  Before reporting a bug in
the release candidate, please check the Open Items page.

URL: https://wiki.postgresql.org/wiki/New_in_postgres_10
URL: https://www.postgresql.org/docs/devel/static/release-10.html
13 Aug 2017 13:52:53
Original commit files touched by this commit  10.b3_1
Revision:447889 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix broken postgresql10-contrib
10 Aug 2017 14:23:31
Original commit files touched by this commit  10.b3_1
Revision:447680 This port version is marked as vulnerable.
girgen search for other commits by this committer
Add PostgreSQL-10 to the ports tree

The PostgreSQL Global Development Group announces today that the
third beta release of PostgreSQL 10 is available for download. This
release contains previews of all of the features which will be
available in the final release of version 10, including fixes to many
of the issues found in the second beta.  Users are encouraged to begin
testing their applications against 10 beta3.

URL:	https://www.postgresql.org/about/news/1771/

Number of commits found: 41

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
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

14 vulnerabilities affecting 165 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-25 19:05:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39434
Broken 80
Deprecated 623
Ignore 348
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 15
Set to expire 577
Interactive 0
new 24 hours 7
new 48 hours11
new 7 days36
new fortnight85
new month244

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