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

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it is already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

Port details on branch 2023Q3
rubygem-pg_query Parses SQL queries using a copy of the PostgreSQL server query parser
4.2.1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 6.1.0Version of this port present on the latest quarterly branch.
Maintainer: mfechner@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2023-07-08 11:01:31
Last Update: 2023-07-08 09:07:46
Commit Hash: b266641
Also Listed In: rubygems
License: BSD3CLAUSE
WWW:
https://github.com/lfittl/pg_query
Description:
This Ruby extension uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parsetree. In addition the extension allows you to normalize queries (replacing constant values with ?) and parse these normalized queries into a parsetree again.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (3 items)
Collapse this list.
  1. /usr/local/share/licenses/rubygem-pg_query-4.2.1/catalog.mk
  2. /usr/local/share/licenses/rubygem-pg_query-4.2.1/LICENSE
  3. /usr/local/share/licenses/rubygem-pg_query-4.2.1/BSD3CLAUSE
Collapse this list.
Dependency lines:
  • rubygem-pg_query>0:databases/rubygem-pg_query
To install the port:
cd /usr/ports/databases/rubygem-pg_query/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/rubygem-pg_query
  • pkg install rubygem-pg_query
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: rubygem-pg_query
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1687446390 SHA256 (rubygem/pg_query-4.2.1.gem) = b04820a9d1c0c1608e3240b7d84baabbee1b95a7302f29fdd0f00e901c604833 SIZE (rubygem/pg_query-4.2.1.gem) = 2274816
Packages (timestamps in pop-ups are UTC):
rubygem-pg_query
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest6.1.06.1.0-6.1.06.1.0---
FreeBSD:13:quarterly6.1.06.1.04.2.16.0.06.1.04.2.34.2.34.2.3
FreeBSD:14:latest6.0.06.1.02.2.06.0.06.1.02.2.1-2.2.1
FreeBSD:14:quarterly6.1.06.1.0-6.1.06.1.04.2.34.2.34.2.3
FreeBSD:15:latest6.1.06.1.0n/a6.0.0n/a4.2.34.2.3-
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. rubygem-pathname>0 : devel/rubygem-pathname
  2. ruby31 : lang/ruby31
  3. gem : devel/ruby-gems
Runtime dependencies:
  1. rubygem-google-protobuf>=3.22.3 : devel/rubygem-google-protobuf
  2. ruby31 : lang/ruby31
  3. gem : devel/ruby-gems
Patch dependencies:
  1. ruby31 : lang/ruby31
  2. gem : devel/ruby-gems
Extract dependencies:
  1. ruby31 : lang/ruby31
This port is required by:
for Build
  1. www/gitlab-ce
for Run
  1. www/gitlab-ce
Configuration Options:
No options to configure
Options name:
databases_rubygem-pg_query
USES:
gem
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://rubygems.org/downloads/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.2.1
08 Jul 2023 09:07:46
commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40 files touched by this commit		 Matthias Fechner (mfechner) search for other commits by this committer 
databases/rubygem-pg_query: update to 4.2.1

Required for gitlab-ce 16.1
Changelog:
https://github.com/pganalyze/pg_query/blob/main/CHANGELOG.md

Upstream was a fix committed which breaks the compilation:
https://github.com/pganalyze/pg_query/commit/684aa77a21eb46188de0ab9bfdabcef71f591614
this is undone with a patch included here.
I reported this upstream:
https://github.com/pganalyze/pg_query/issues/291
Till this is fixed, we can keep the patch that undo 684aa77a21

(cherry picked from commit 03804b40854e11e4749ec488783d7ebfeb5119e6)

Number of commits found: 1
Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
firefoxJun 05
firefoxJun 05
firefoxJun 05
firefoxJun 05
firefox-esrJun 05
firefox-esrJun 05
firefox-esrJun 05
firefox-esrJun 05
chromiumJun 04
electron34*Jun 04
electron35*Jun 04
electron36*Jun 04
roundcubeJun 03
gimpJun 02
gimpJun 02

30 vulnerabilities affecting 276 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-06-05 16:03:43 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33311
Broken 120
Deprecated 314
Ignore 239
Forbidden 1
Restricted 2
No CDROM 1
Vulnerable 33
Expired 31
Set to expire 258
Interactive 0
new 24 hours 1
new 48 hours8
new 7 days26
new fortnight48
new month133
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.