pg-textsearch
pg_textsearch
pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.
Follow the quick start to set up extension-update email
alerts first, then use the CronJob to install and refresh the catalog. These
examples inherit image references and runtime settings from the catalog. The Cluster YAML
is an excerpt: replace imageCatalogRef: ... with your catalog reference and
keep your existing instance and storage settings.
Usage
1. Add the pg-textsearch extension image to your Cluster
Define the pg-textsearch extension under the postgresql.extensions section of
your Cluster resource. For example:
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: cluster-pg-textsearch
spec:
imageCatalogRef: ...
postgresql:
shared_preload_libraries:
- pg_textsearch
parameters:
hot_standby_feedback: "on"
extensions:
- name: pg-textsearch
2. Enable the extension in a database
Once the extension's files are available in the cluster, you can install it in a database in either of two ways:
- Declaratively, using a CloudNativePG
Databaseresource. - Through SQL, by running
CREATE EXTENSION pg_textsearch;in the target database.
Platform teams may make extension containers available across their clusters without installing every extension in every database. Install only the extensions a database uses; letting users enable them through SQL alongside the rest of their DDL schema management code can be a convenient approach.
For extensions that normally require superuser privileges, platform teams can use pgextwlist to allow non-superusers to install an administrator-approved selection of extensions.
For declarative installation, use:
apiVersion: postgresql.cnpg.io/v1
kind: Database
metadata:
name: cluster-pg-textsearch-app
spec:
name: app
owner: app
cluster:
name: cluster-pg-textsearch
extensions:
- name: pg_textsearch
3. Verify installation
Once the database is ready, connect to it with psql and run:
\dx pg_textsearch
You should see pg_textsearch listed with its installed SQL version. The extension must be
included in shared_preload_libraries; the Cluster example above supplies this
setting explicitly because preloads are not inherited from the catalog.
4. Create and query an index
CREATE TABLE documents (id bigint PRIMARY KEY, content text);
INSERT INTO documents VALUES
(1, 'PostgreSQL database search'),
(2, 'BM25 relevance ranking');
CREATE INDEX documents_bm25 ON documents USING bm25(content)
WITH (text_config = 'english');
SELECT id, content FROM documents
ORDER BY content <@> 'database search'
LIMIT 5;
Lower (negative) scores rank first. Inspect the plan with EXPLAIN; PostgreSQL
may choose a sequential scan for small tables.
Optional managed background compaction
This image does not bundle pg_durable. The default inline compaction mode does
not require it. Managed background mode is an upstream preview feature and
requires pg_durable 0.2.8 or later in the same database.
To use our separate pg-durable image, add
pg-durable to postgresql.extensions, add pg_durable to
shared_preload_libraries, and set pg_durable.database in
postgresql.parameters to the target database (for example, app). Install
both extensions there. The index owner must have LOGIN and pg_durable usage
privileges, granted by an administrator with SELECT df.grant_usage('app');
when the owner is app. Superuser-owned workflows require an additional
pg_durable setting; the tested configuration uses a non-superuser owner.
Configure authentication for pg_durable's management and index-owner connections before enabling background mode; see its authentication caveats. As the index owner, enable it on an existing index with:
ALTER INDEX documents_bm25 SET (compaction = 'background');
Return to explicit maintenance with compaction = 'manual', or to foreground
compaction with compaction = 'inline'. See the
upstream background-compaction documentation
for scheduling and workflow lifecycle details.
With our pg_durable 0.2.9 container, managed compaction cleared existing and new spill backlogs before and after planned switchover and automatic failover, retaining the same workflow ID. These local tests used PostgreSQL 18.7, CNPG 1.30.1, and AMD64 Bookworm and Trixie. Worker authentication used a disposable loopback-only trust rule; production credential-based authentication and a crash deliberately timed inside a merge were not validated.
Replication and recovery
Keep hot_standby_feedback = on when replicas serve search queries. Upstream
requires this so active replica snapshots delay index page reuse on the primary.
The Cluster example supplies it explicitly. The index is WAL-logged; its
shared-memory cache is rebuilt from persisted index data.
See the versioned upstream documentation.
Local tests of pg_textsearch 1.5.1 with PostgreSQL 18.7 and CNPG 1.30.1 passed on AMD64 Bookworm and Trixie: live index creation and replica searches, committed and rolled-back index updates, primary and standby crash recovery, planned switchover, and automatic failover to a different pod. Search results and new writes remained correct on the promoted primary, and the former primary rejoined successfully. Clients must reconnect when CNPG closes connections during a role change. These checks do not cover PITR, backup restores, native ARM64 execution, or other versions.
Licenses and Copyright
pg_textsearch is distributed under the PostgreSQL license. Extension and dependency licenses and copyright notices are bundled in
/licenses/ in the image.
Overview
pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.
Package details
- Extension version
- 1.5.1
- Image built
- Publisher
- cnpg-extensions
- Build
- Debian
- Platform
- PG 18 · Trixie · amd64
Project links
- Debian source package ↗tracker.debian.org/pkg/pg-textsearch
- Upstream homepage ↗github.com/timescale/pg_textsearch
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_textsearch;- SQL version
1.5.1
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_textsearch' |
hot_standby_feedback | on |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-Workflow10
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no dangerous workflow patterns detected
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-ProtectionUnknown
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
Code-Review2
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 8/30 approved changesets -- score normalized to 2
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Token-Permissions0
Determines if the project's workflows follow the principle of least privilege.
Reasoning: detected GitHub workflow tokens with excessive permissions
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
- Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
- Warn: no topLevel permission defined: .github/workflows/ci.yml:1
- Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
- Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
- Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
- Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
- Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
- Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
- Info: no jobLevel write permissions found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-Dependencies0
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: dependency not pinned by hash detected -- score normalized to 0
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
- Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
- Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
- Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 36 third-party GitHubAction dependencies pinned
- Info: 0 out of 8 pipCommand dependencies pinned
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 30 are checked with a SAST tool
Security-Policy10
Determines if the project has published a security policy.
Reasoning: security policy file detected
- Info: security policy file detected: SECURITY.md:1
- Info: Found linked content: SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
- Info: Found text in security policy: SECURITY.md:1
CI-Tests9
Determines if the project runs tests before pull requests are merged.
Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors10
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 6 contributing companies or organizations
- Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro
License10
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0
Overview
pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.
Package details
- Extension version
- 1.5.1
- Image built
- Publisher
- cnpg-extensions
- Build
- Debian
- Platform
- PG 18 · Trixie · arm64
Project links
- Debian source package ↗tracker.debian.org/pkg/pg-textsearch
- Upstream homepage ↗github.com/timescale/pg_textsearch
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_textsearch;- SQL version
1.5.1
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_textsearch' |
hot_standby_feedback | on |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-Workflow10
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no dangerous workflow patterns detected
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-ProtectionUnknown
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
Code-Review2
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 8/30 approved changesets -- score normalized to 2
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Token-Permissions0
Determines if the project's workflows follow the principle of least privilege.
Reasoning: detected GitHub workflow tokens with excessive permissions
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
- Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
- Warn: no topLevel permission defined: .github/workflows/ci.yml:1
- Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
- Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
- Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
- Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
- Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
- Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
- Info: no jobLevel write permissions found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-Dependencies0
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: dependency not pinned by hash detected -- score normalized to 0
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
- Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
- Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
- Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 36 third-party GitHubAction dependencies pinned
- Info: 0 out of 8 pipCommand dependencies pinned
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 30 are checked with a SAST tool
Security-Policy10
Determines if the project has published a security policy.
Reasoning: security policy file detected
- Info: security policy file detected: SECURITY.md:1
- Info: Found linked content: SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
- Info: Found text in security policy: SECURITY.md:1
CI-Tests9
Determines if the project runs tests before pull requests are merged.
Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors10
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 6 contributing companies or organizations
- Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro
License10
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0
Overview
pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.
Package details
- Extension version
- 1.5.1
- Image built
- Publisher
- cnpg-extensions
- Build
- Debian
- Platform
- PG 18 · Bookworm · amd64
Project links
- Debian source package ↗tracker.debian.org/pkg/pg-textsearch
- Upstream homepage ↗github.com/timescale/pg_textsearch
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_textsearch;- SQL version
1.5.1
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_textsearch' |
hot_standby_feedback | on |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-Workflow10
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no dangerous workflow patterns detected
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-ProtectionUnknown
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
Code-Review2
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 8/30 approved changesets -- score normalized to 2
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Token-Permissions0
Determines if the project's workflows follow the principle of least privilege.
Reasoning: detected GitHub workflow tokens with excessive permissions
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
- Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
- Warn: no topLevel permission defined: .github/workflows/ci.yml:1
- Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
- Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
- Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
- Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
- Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
- Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
- Info: no jobLevel write permissions found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-Dependencies0
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: dependency not pinned by hash detected -- score normalized to 0
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
- Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
- Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
- Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 36 third-party GitHubAction dependencies pinned
- Info: 0 out of 8 pipCommand dependencies pinned
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 30 are checked with a SAST tool
Security-Policy10
Determines if the project has published a security policy.
Reasoning: security policy file detected
- Info: security policy file detected: SECURITY.md:1
- Info: Found linked content: SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
- Info: Found text in security policy: SECURITY.md:1
CI-Tests9
Determines if the project runs tests before pull requests are merged.
Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors10
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 6 contributing companies or organizations
- Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro
License10
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0
Overview
pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.
Package details
- Extension version
- 1.5.1
- Image built
- Publisher
- cnpg-extensions
- Build
- Debian
- Platform
- PG 18 · Bookworm · arm64
Project links
- Debian source package ↗tracker.debian.org/pkg/pg-textsearch
- Upstream homepage ↗github.com/timescale/pg_textsearch
Links from package metadata, recipe update rules, or reviewed upstream mappings.
Database setup
- Required extensions
- None specified
- SQL installation
CREATE EXTENSION pg_textsearch;- SQL version
1.5.1
PostgreSQL parameters
| Parameter | Value |
|---|---|
shared_preload_libraries | 'pg_textsearch' |
hot_standby_feedback | on |
These recipe settings are used in automated smoke tests.
OpenSSF scorecard
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.
View information about checks. Automated results are informational only; some categories may not apply to this project.
Scanned · Download cached scan ↓
Dangerous-Workflow10
Determines if the project's GitHub Action workflows avoid dangerous patterns.
Reasoning: no dangerous workflow patterns detected
Binary-Artifacts10
Determines if the project has generated executable (binary) artifacts in the source repository.
Reasoning: no binaries found in the repo
Branch-ProtectionUnknown
Determines if the default and release branches are protected with GitHub's branch protection settings.
Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
Code-Review2
Determines if the project requires human code review before pull requests (aka merge requests) are merged.
Reasoning: Found 8/30 approved changesets -- score normalized to 2
Dependency-Update-Tool0
Determines if the project uses a dependency update tool.
Reasoning: no update tool detected
- Warn: no dependency update tool configurations found
Maintained10
Determines if the project is "actively maintained".
Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Token-Permissions0
Determines if the project's workflows follow the principle of least privilege.
Reasoning: detected GitHub workflow tokens with excessive permissions
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
- Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
- Warn: no topLevel permission defined: .github/workflows/ci.yml:1
- Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
- Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
- Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
- Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
- Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
- Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
- Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
- Info: no jobLevel write permissions found
Vulnerabilities10
Determines if the project has open, known unfixed vulnerabilities.
Reasoning: 0 existing vulnerabilities detected
Fuzzing0
Determines if the project uses fuzzing.
Reasoning: project is not fuzzed
- Warn: no fuzzer integrations found
Pinned-Dependencies0
Determines if the project has declared and pinned the dependencies of its build process.
Reasoning: dependency not pinned by hash detected -- score normalized to 0
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
- Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
- Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
- Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
- Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
- Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 36 third-party GitHubAction dependencies pinned
- Info: 0 out of 8 pipCommand dependencies pinned
SAST0
Determines if the project uses static code analysis.
Reasoning: SAST tool is not run on all commits -- score normalized to 0
- Warn: 0 commits out of 30 are checked with a SAST tool
Security-Policy10
Determines if the project has published a security policy.
Reasoning: security policy file detected
- Info: security policy file detected: SECURITY.md:1
- Info: Found linked content: SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
- Info: Found text in security policy: SECURITY.md:1
CI-Tests9
Determines if the project runs tests before pull requests are merged.
Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9
CII-Best-Practices0
Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.
Reasoning: no effort to earn an OpenSSF best practices badge detected
Contributors10
Determines if the project has a set of contributors from multiple organizations (e.g., companies).
Reasoning: project has 6 contributing companies or organizations
- Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro
License10
Determines if the project has defined a license.
Reasoning: license file detected
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0
Dependencies
Packages shipped in this image, including the extension itself.
1 packages · Scanned
| Package / installed version | License evidence | Advisories |
|---|---|---|
postgresql-18-pg-textsearch ↗ 1.5.1-3.pgdg13+2 | PostgreSQL | No ↗ |
No packages match these filters. Try a different name or license, or clear the filters.
Dependencies
Packages shipped in this image, including the extension itself.
1 packages · Scanned
| Package / installed version | License evidence | Advisories |
|---|---|---|
postgresql-18-pg-textsearch ↗ 1.5.1-3.pgdg13+2 | PostgreSQL | No ↗ |
No packages match these filters. Try a different name or license, or clear the filters.
Dependencies
Packages shipped in this image, including the extension itself.
1 packages · Scanned
| Package / installed version | License evidence | Advisories |
|---|---|---|
postgresql-18-pg-textsearch ↗ 1.5.1-3.pgdg12+2 | PostgreSQL | No ↗ |
No packages match these filters. Try a different name or license, or clear the filters.
Dependencies
Packages shipped in this image, including the extension itself.
1 packages · Scanned
| Package / installed version | License evidence | Advisories |
|---|---|---|
postgresql-18-pg-textsearch ↗ 1.5.1-3.pgdg12+2 | PostgreSQL | No ↗ |
No packages match these filters. Try a different name or license, or clear the filters.
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-textsearch/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ Upstream-Name: pg-textsearch Source: https://github.com/timescale/pg_textsearch Files: * Copyright: 2025-2026 Tiger Data, Inc. (formerly known as Timescale) License: PostgreSQL License: PostgreSQL Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. . IN NO EVENT SHALL TIGER DATA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF TIGER DATA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. . TIGER DATA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND TIGER DATA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
SHA256: 2acee3f295001684418bb454edd4623cee8b417f4dbf1a969c210b0be056955c
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-textsearch/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ Upstream-Name: pg-textsearch Source: https://github.com/timescale/pg_textsearch Files: * Copyright: 2025-2026 Tiger Data, Inc. (formerly known as Timescale) License: PostgreSQL License: PostgreSQL Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. . IN NO EVENT SHALL TIGER DATA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF TIGER DATA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. . TIGER DATA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND TIGER DATA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
SHA256: 2acee3f295001684418bb454edd4623cee8b417f4dbf1a969c210b0be056955c
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-textsearch/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ Upstream-Name: pg-textsearch Source: https://github.com/timescale/pg_textsearch Files: * Copyright: 2025-2026 Tiger Data, Inc. (formerly known as Timescale) License: PostgreSQL License: PostgreSQL Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. . IN NO EVENT SHALL TIGER DATA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF TIGER DATA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. . TIGER DATA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND TIGER DATA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
SHA256: 2acee3f295001684418bb454edd4623cee8b417f4dbf1a969c210b0be056955c
Licenses
Original license files shipped in the selected container image.
1 file read directly from /licenses.
/licenses/postgresql-18-pg-textsearch/copyrightRead notice
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ Upstream-Name: pg-textsearch Source: https://github.com/timescale/pg_textsearch Files: * Copyright: 2025-2026 Tiger Data, Inc. (formerly known as Timescale) License: PostgreSQL License: PostgreSQL Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. . IN NO EVENT SHALL TIGER DATA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF TIGER DATA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. . TIGER DATA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND TIGER DATA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
SHA256: 2acee3f295001684418bb454edd4623cee8b417f4dbf1a969c210b0be056955c
Versions
Extension versions and the images built from them.
Tagged GHCR builds fetched .
