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
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
There is a known issue with processing of security/vuxml data. As a results, the "Lastest Vulnerabilities" box is out of date and new entries after 2025-Sep-02 are not shown.
Port details on branch 2025Q3
rubygem-pg_query Parses SQL queries using a copy of the PostgreSQL server query parser
6.1.0 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 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: 2021-01-25 11:57:29
Last Update: 2025-04-18 08:34:22
Commit Hash: fd30a3b
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
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

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-6.1.0/catalog.mk
  2. /usr/local/share/licenses/rubygem-pg_query-6.1.0/LICENSE
  3. /usr/local/share/licenses/rubygem-pg_query-6.1.0/BSD3CLAUSE
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
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 = 1744780556 SHA256 (rubygem/pg_query-6.1.0.gem) = 8b005229e209f12c5887c34c60d0eb2a241953b9475b53a9840d24578532481e SIZE (rubygem/pg_query-6.1.0.gem) = 2448896
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.1.06.1.04.2.34.2.34.2.3
FreeBSD:14:latest6.1.06.1.02.2.06.1.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:latest-6.1.0n/a6.1.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. ruby32 : lang/ruby32
  3. gem : devel/ruby-gems
Runtime dependencies:
  1. rubygem-google-protobuf>=3.25.3 : devel/rubygem-google-protobuf
  2. ruby32 : lang/ruby32
  3. gem : devel/ruby-gems
Patch dependencies:
  1. ruby32 : lang/ruby32
  2. gem : devel/ruby-gems
Extract dependencies:
  1. ruby32 : lang/ruby32
This port is required by:
for Build
  1. www/gitlab

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. www/gitlab-ce*
  2. Collapse this list of deleted ports.
for Run
  1. devel/rubygem-gitlab-labkit
  2. www/gitlab

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. www/gitlab-ce*
  2. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...
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.

There are no commits on branch 2025Q3 for this port
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
exiv2Sep 04
exiv2Sep 04
py-django42Sep 04
py-django51Sep 04
py-django52Sep 04
linux-viebSep 03
shibboleth-spSep 03
gitlabAug 29
qt6-baseAug 28
qt6-pdfAug 28
qt6-webengineAug 28
keaAug 27
kea-develAug 27
linux-c7-sqlite3Aug 27
sqlite3Aug 27

11 vulnerabilities affecting 82 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-09-05 14:49:12 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33579
Broken 127
Deprecated 183
Ignore 244
Forbidden 0
Restricted 2
No CDROM 1
Vulnerable 36
Expired 14
Set to expire 123
Interactive 0
new 24 hours 5
new 48 hours9
new 7 days36
new fortnight72
new month122
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.