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

Get notified when packages are built

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

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

Port details on branch 2022Q2
pg_citus Horizontally scale Postgresql using sharding and replication
12.1.2 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 12.1.2Version of this port present on the latest quarterly branch.
Maintainer: matthew@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-03-26 16:53:44
Last Update: 2024-02-27 18:04:33
Commit Hash: af806fd
People watching this port, also watch:: pglogical, pgbarman-py39, p5-RT44-RTx-Calendar, p5-RT44-RT-Extension-MandatoryOnTransition
License: AGPLv3
WWW:
https://www.citusdata.com/
Description:
What is Citus? * Open-source PostgreSQL extension (not a fork) * Scalable across multiple hosts through sharding and replication * Distributed engine for query parallelization * Highly available in the face of host failures Citus horizontally scales PostgreSQL across commodity servers using sharding and replication. Its query engine parallelizes incoming SQL queries across these servers to enable real-time responses on large datasets.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (227 items)
Collapse this list.
  1. /usr/local/share/licenses/pg_citus-12.1.2/catalog.mk
  2. /usr/local/share/licenses/pg_citus-12.1.2/LICENSE
  3. /usr/local/share/licenses/pg_citus-12.1.2/AGPLv3
  4. include/postgresql/server/citus_version.h
  5. include/postgresql/server/distributed/adaptive_executor.h
  6. include/postgresql/server/distributed/argutils.h
  7. include/postgresql/server/distributed/backend_data.h
  8. include/postgresql/server/distributed/background_jobs.h
  9. include/postgresql/server/distributed/cancel_utils.h
  10. include/postgresql/server/distributed/causal_clock.h
  11. include/postgresql/server/distributed/citus_acquire_lock.h
  12. include/postgresql/server/distributed/citus_clauses.h
  13. include/postgresql/server/distributed/citus_custom_scan.h
  14. include/postgresql/server/distributed/citus_depended_object.h
  15. include/postgresql/server/distributed/citus_nodefuncs.h
  16. include/postgresql/server/distributed/citus_nodes.h
  17. include/postgresql/server/distributed/citus_ruleutils.h
  18. include/postgresql/server/distributed/citus_safe_lib.h
  19. include/postgresql/server/distributed/colocation_utils.h
  20. include/postgresql/server/distributed/combine_query_planner.h
  21. include/postgresql/server/distributed/commands.h
  22. include/postgresql/server/distributed/connection_management.h
  23. include/postgresql/server/distributed/coordinator_protocol.h
  24. include/postgresql/server/distributed/cte_inline.h
  25. include/postgresql/server/distributed/deparse_shard_query.h
  26. include/postgresql/server/distributed/deparser.h
  27. include/postgresql/server/distributed/directed_acyclic_graph_execution.h
  28. include/postgresql/server/distributed/distributed_deadlock_detection.h
  29. include/postgresql/server/distributed/distributed_execution_locks.h
  30. include/postgresql/server/distributed/distributed_planner.h
  31. include/postgresql/server/distributed/distribution_column.h
  32. include/postgresql/server/distributed/enterprise.h
  33. include/postgresql/server/distributed/error_codes.h
  34. include/postgresql/server/distributed/errormessage.h
  35. include/postgresql/server/distributed/executor_util.h
  36. include/postgresql/server/distributed/extended_op_node_utils.h
  37. include/postgresql/server/distributed/foreign_key_relationship.h
  38. include/postgresql/server/distributed/function_call_delegation.h
  39. include/postgresql/server/distributed/function_utils.h
  40. include/postgresql/server/distributed/hash_helpers.h
  41. include/postgresql/server/distributed/insert_select_executor.h
  42. include/postgresql/server/distributed/insert_select_planner.h
  43. include/postgresql/server/distributed/intermediate_result_pruning.h
  44. include/postgresql/server/distributed/intermediate_results.h
  45. include/postgresql/server/distributed/jsonbutils.h
  46. include/postgresql/server/distributed/listutils.h
  47. include/postgresql/server/distributed/local_distributed_join_planner.h
  48. include/postgresql/server/distributed/local_executor.h
  49. include/postgresql/server/distributed/local_multi_copy.h
  50. include/postgresql/server/distributed/local_plan_cache.h
  51. include/postgresql/server/distributed/locally_reserved_shared_connections.h
  52. include/postgresql/server/distributed/lock_graph.h
  53. include/postgresql/server/distributed/log_utils.h
  54. include/postgresql/server/distributed/maintenanced.h
  55. include/postgresql/server/distributed/memutils.h
  56. include/postgresql/server/distributed/merge_executor.h
  57. include/postgresql/server/distributed/merge_planner.h
  58. include/postgresql/server/distributed/metadata_cache.h
  59. include/postgresql/server/distributed/metadata_sync.h
  60. include/postgresql/server/distributed/metadata_utility.h
  61. include/postgresql/server/distributed/multi_executor.h
  62. include/postgresql/server/distributed/multi_explain.h
  63. include/postgresql/server/distributed/multi_join_order.h
  64. include/postgresql/server/distributed/multi_logical_optimizer.h
  65. include/postgresql/server/distributed/multi_logical_planner.h
  66. include/postgresql/server/distributed/multi_logical_replication.h
  67. include/postgresql/server/distributed/multi_partitioning_utils.h
  68. include/postgresql/server/distributed/multi_physical_planner.h
  69. include/postgresql/server/distributed/multi_progress.h
  70. include/postgresql/server/distributed/multi_router_planner.h
  71. include/postgresql/server/distributed/multi_server_executor.h
  72. include/postgresql/server/distributed/namespace_utils.h
  73. include/postgresql/server/distributed/param_utils.h
  74. include/postgresql/server/distributed/pg_dist_background_job.h
  75. include/postgresql/server/distributed/pg_dist_background_task.h
  76. include/postgresql/server/distributed/pg_dist_backrgound_task_depend.h
  77. include/postgresql/server/distributed/pg_dist_cleanup.h
  78. include/postgresql/server/distributed/pg_dist_colocation.h
  79. include/postgresql/server/distributed/pg_dist_local_group.h
  80. include/postgresql/server/distributed/pg_dist_node.h
  81. include/postgresql/server/distributed/pg_dist_node_metadata.h
  82. include/postgresql/server/distributed/pg_dist_partition.h
  83. include/postgresql/server/distributed/pg_dist_placement.h
  84. include/postgresql/server/distributed/pg_dist_rebalance_strategy.h
  85. include/postgresql/server/distributed/pg_dist_schema.h
  86. include/postgresql/server/distributed/pg_dist_shard.h
  87. include/postgresql/server/distributed/pg_dist_transaction.h
  88. include/postgresql/server/distributed/pg_version_constants.h
  89. include/postgresql/server/distributed/placement_access.h
  90. include/postgresql/server/distributed/placement_connection.h
  91. include/postgresql/server/distributed/priority.h
  92. include/postgresql/server/distributed/query_colocation_checker.h
  93. include/postgresql/server/distributed/query_pushdown_planning.h
  94. include/postgresql/server/distributed/query_stats.h
  95. include/postgresql/server/distributed/query_utils.h
  96. include/postgresql/server/distributed/recursive_planning.h
  97. include/postgresql/server/distributed/reference_table_utils.h
  98. include/postgresql/server/distributed/relation_access_tracking.h
  99. include/postgresql/server/distributed/relation_restriction_equivalence.h
  100. include/postgresql/server/distributed/relation_utils.h
  101. include/postgresql/server/distributed/relay_utility.h
  102. include/postgresql/server/distributed/remote_commands.h
  103. include/postgresql/server/distributed/remote_transaction.h
  104. include/postgresql/server/distributed/repartition_executor.h
  105. include/postgresql/server/distributed/repartition_join_execution.h
  106. include/postgresql/server/distributed/replicate_none_dist_table_shard.h
  107. include/postgresql/server/distributed/replication_origin_session_utils.h
  108. include/postgresql/server/distributed/resource_lock.h
  109. include/postgresql/server/distributed/run_from_same_connection.h
  110. include/postgresql/server/distributed/shard_cleaner.h
  111. include/postgresql/server/distributed/shard_pruning.h
  112. include/postgresql/server/distributed/shard_rebalancer.h
  113. include/postgresql/server/distributed/shard_split.h
  114. include/postgresql/server/distributed/shard_transfer.h
  115. include/postgresql/server/distributed/shard_utils.h
  116. include/postgresql/server/distributed/shardinterval_utils.h
  117. include/postgresql/server/distributed/shardsplit_logical_replication.h
  118. include/postgresql/server/distributed/shardsplit_shared_memory.h
  119. include/postgresql/server/distributed/shared_connection_stats.h
  120. include/postgresql/server/distributed/shared_library_init.h
  121. include/postgresql/server/distributed/statistics_collection.h
  122. include/postgresql/server/distributed/string_utils.h
  123. include/postgresql/server/distributed/subplan_execution.h
  124. include/postgresql/server/distributed/task_execution_utils.h
  125. include/postgresql/server/distributed/tdigest_extension.h
  126. include/postgresql/server/distributed/tenant_schema_metadata.h
  127. include/postgresql/server/distributed/time_constants.h
  128. include/postgresql/server/distributed/transaction_identifier.h
  129. include/postgresql/server/distributed/transaction_management.h
  130. include/postgresql/server/distributed/transaction_recovery.h
  131. include/postgresql/server/distributed/transmit.h
  132. include/postgresql/server/distributed/tuple_destination.h
  133. include/postgresql/server/distributed/tuplestore.h
  134. include/postgresql/server/distributed/type_utils.h
  135. include/postgresql/server/distributed/version_compat.h
  136. include/postgresql/server/distributed/worker_create_or_replace.h
  137. include/postgresql/server/distributed/worker_log_messages.h
  138. include/postgresql/server/distributed/worker_manager.h
  139. include/postgresql/server/distributed/worker_protocol.h
  140. include/postgresql/server/distributed/worker_shard_copy.h
  141. include/postgresql/server/distributed/worker_shard_visibility.h
  142. include/postgresql/server/distributed/worker_transaction.h
  143. lib/postgresql/citus.so
  144. lib/postgresql/citus_columnar.so
  145. lib/postgresql/citus_decoders/pgoutput.so
  146. lib/postgresql/citus_decoders/wal2json.so
  147. lib/postgresql/citus_pgoutput.so
  148. lib/postgresql/citus_wal2json.so
  149. share/postgresql/extension/citus--10.0-1--10.0-2.sql
  150. share/postgresql/extension/citus--10.0-2--10.0-3.sql
  151. share/postgresql/extension/citus--10.0-3--10.0-4.sql
  152. share/postgresql/extension/citus--10.0-4--10.1-1.sql
  153. share/postgresql/extension/citus--10.1-1--10.2-1.sql
  154. share/postgresql/extension/citus--10.2-1--10.2-2.sql
  155. share/postgresql/extension/citus--10.2-2--10.2-3.sql
  156. share/postgresql/extension/citus--10.2-3--10.2-4.sql
  157. share/postgresql/extension/citus--10.2-4--10.2-5.sql
  158. share/postgresql/extension/citus--10.2-5--10.2-4.sql
  159. share/postgresql/extension/citus--10.2-5--11.0-1.sql
  160. share/postgresql/extension/citus--11.0-1--11.0-2.sql
  161. share/postgresql/extension/citus--11.0-2--11.0-3.sql
  162. share/postgresql/extension/citus--11.0-3--11.0-4.sql
  163. share/postgresql/extension/citus--11.0-4--11.0-3.sql
  164. share/postgresql/extension/citus--11.0-4--11.1-1.sql
  165. share/postgresql/extension/citus--11.1-1--11.2-1.sql
  166. share/postgresql/extension/citus--11.2-1--11.2-2.sql
  167. share/postgresql/extension/citus--11.2-2--11.3-1.sql
  168. share/postgresql/extension/citus--11.3-1--11.3-2.sql
  169. share/postgresql/extension/citus--11.3-2--12.0-1.sql
  170. share/postgresql/extension/citus--12.0-1--12.1-1.sql
  171. share/postgresql/extension/citus--8.0-1--8.0-2.sql
  172. share/postgresql/extension/citus--8.0-1.sql
  173. share/postgresql/extension/citus--8.0-10--8.0-11.sql
  174. share/postgresql/extension/citus--8.0-11--8.0-12.sql
  175. share/postgresql/extension/citus--8.0-12--8.0-13.sql
  176. share/postgresql/extension/citus--8.0-13--8.1-1.sql
  177. share/postgresql/extension/citus--8.0-2--8.0-3.sql
  178. share/postgresql/extension/citus--8.0-3--8.0-4.sql
  179. share/postgresql/extension/citus--8.0-4--8.0-5.sql
  180. share/postgresql/extension/citus--8.0-5--8.0-6.sql
  181. share/postgresql/extension/citus--8.0-6--8.0-7.sql
  182. share/postgresql/extension/citus--8.0-7--8.0-8.sql
  183. share/postgresql/extension/citus--8.0-8--8.0-9.sql
  184. share/postgresql/extension/citus--8.0-9--8.0-10.sql
  185. share/postgresql/extension/citus--8.1-1--8.2-1.sql
  186. share/postgresql/extension/citus--8.2-1--8.2-2.sql
  187. share/postgresql/extension/citus--8.2-2--8.2-3.sql
  188. share/postgresql/extension/citus--8.2-3--8.2-4.sql
  189. share/postgresql/extension/citus--8.2-4--8.3-1.sql
  190. share/postgresql/extension/citus--8.3-1--9.0-1.sql
  191. share/postgresql/extension/citus--9.0-1--9.0-2.sql
  192. share/postgresql/extension/citus--9.0-2--9.1-1.sql
  193. share/postgresql/extension/citus--9.1-1--9.2-1.sql
  194. share/postgresql/extension/citus--9.2-1--9.2-2.sql
  195. share/postgresql/extension/citus--9.2-2--9.2-4.sql
  196. share/postgresql/extension/citus--9.2-4--9.3-2.sql
  197. share/postgresql/extension/citus--9.3-1--9.2-4.sql
  198. share/postgresql/extension/citus--9.3-2--9.4-1.sql
  199. share/postgresql/extension/citus--9.4-1--9.4-2.sql
  200. share/postgresql/extension/citus--9.4-1--9.5-1.sql
  201. share/postgresql/extension/citus--9.4-2--9.4-1.sql
  202. share/postgresql/extension/citus--9.4-2--9.4-3.sql
  203. share/postgresql/extension/citus--9.4-3--9.4-2.sql
  204. share/postgresql/extension/citus--9.5-1--10.0-4.sql
  205. share/postgresql/extension/citus--9.5-1--9.5-2.sql
  206. share/postgresql/extension/citus--9.5-2--9.5-1.sql
  207. share/postgresql/extension/citus--9.5-2--9.5-3.sql
  208. share/postgresql/extension/citus--9.5-3--9.5-2.sql
  209. share/postgresql/extension/citus.control
  210. share/postgresql/extension/citus_columnar--11.1-0--11.1-1.sql
  211. share/postgresql/extension/citus_columnar--11.1-0.sql
  212. share/postgresql/extension/citus_columnar--11.1-1--11.2-1.sql
  213. share/postgresql/extension/citus_columnar--11.1-1.sql
  214. share/postgresql/extension/citus_columnar--11.2-1--11.3-1.sql
  215. share/postgresql/extension/citus_columnar.control
  216. share/postgresql/extension/columnar--10.0-1--10.0-2.sql
  217. share/postgresql/extension/columnar--10.0-3--10.1-1.sql
  218. share/postgresql/extension/columnar--10.1-1--10.2-1.sql
  219. share/postgresql/extension/columnar--10.2-1--10.2-2.sql
  220. share/postgresql/extension/columnar--10.2-2--10.2-3.sql
  221. share/postgresql/extension/columnar--10.2-3--10.2-4.sql
  222. share/postgresql/extension/columnar--11.0-2--11.0-3.sql
  223. share/postgresql/extension/columnar--11.0-3--11.1-1.sql
  224. share/postgresql/extension/columnar--9.5-1--10.0-1.sql
  225. @owner
  226. @group
  227. @mode
Collapse this list.
Dependency lines:
  • pg_citus>0:databases/pg_citus
To install the port:
cd /usr/ports/databases/pg_citus/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg_citus
  • pkg install pg_citus
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pg_citus
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1709021068 SHA256 (citusdata-citus-v12.1.2_GH0.tar.gz) = 61d959e8129df4613186841550ea29afb9348a7e6f871d5b5df4866777b82e24 SIZE (citusdata-citus-v12.1.2_GH0.tar.gz) = 6897486

Packages (timestamps in pop-ups are UTC):
pg_citus
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest12.1.212.1.29.5.112.1.212.1.2-9.5.1-
FreeBSD:13:quarterly12.1.212.1.211.3.012.1.212.1.212.1.012.1.012.1.0
FreeBSD:14:latest12.1.212.1.211.1.512.1.212.1.211.3.0-11.3.0
FreeBSD:14:quarterly12.1.012.1.2-12.1.012.1.212.1.012.1.012.1.0
FreeBSD:15:latest12.1.212.1.2n/a12.1.0n/a12.1.012.1.012.1.0
FreeBSD:15:quarterly--n/a-n/a---
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. postgres : databases/postgresql15-server
  3. gettext-runtime>=0.22_1 : devel/gettext-runtime
  4. autoconf>=2.71 : devel/autoconf
  5. automake>=1.16.5 : devel/automake
Runtime dependencies:
  1. postgres : databases/postgresql15-server
Library dependencies:
  1. liblz4.so : archivers/liblz4
  2. libzstd.so : archivers/zstd
  3. libpq.so.5 : databases/postgresql15-client
  4. libreadline.so.8 : devel/readline
  5. libintl.so : devel/gettext-runtime
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pg_citus-12.1.2: ANONSTATS=off: Enable anonymous statistics collection ===> Use 'make config' to modify these settings
Options name:
databases_pg_citus
USES:
compiler:c11 gmake pgsql:14+ autoreconf readline ssl gettext-runtime
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/citusdata/citus/tar.gz/v12.1.2?dummy=/
Collapse this list.

There are no commits on branch 2022Q2 for this port