1-50 of 53 found
README
This module provides datatypes for storing SHA-1, SHA-2 and MD5 hashes. Installation: make make install make installcheck (optional) psql -f sha.sql $PGDATABASE.
Scripts and Generated Contracts
scripts/run-* executes a gate and records SHA-named evidence. tests/shell/*_smoke.sh proves positive and negative script behavior. release/checks/ composes the bounded open-source readiness gate.
V1 Artifact Verification Policy
… by a GitHub-verified signed annotated tag, published SHA-256 checksums, and a Sigstore build-provenance attestation for the source archive.
Release Tooling
../scripts/render-release-notes.py binds the exact candidate SHA into the final notes used by the protected publication job. ../.github/workflows/ci.yml runs bounded pull-request checks. ../.
OmniPITR - omnipitr-backup-master
… checksums: MD5 - standard md5 algorithm SHA-1 - SHA-1 algorithm SHA-256 - SHA-2 algorithm with hash size of 256 bits SHA-384 - SHA-2 algorithm with hash size of 384 bits SHA-512 - SHA-2 algorithm…
P12 worker runtime and license decision
The artifact is operator-provided, verified by length and SHA-256 before use, and is not a transformer-compatibility claim. Worker dependency and artifact licenses The worker has no provider SDK…
Release Gate Matrix
The report records commit SHA, clean-tree state, Rust, Cargo, cargo-pgrx, artifact sizes, SHA-256 checksums, signature verification status, and version consistency between context-pg and pgcontext.
pg_dctp
… '', false); CREATE ROLE test PASSWORD 'SCRAM-SHA-256$4096:R3UBBT6VhhuzG81+6evX/g==$B87w8MCrMkQw/QM1tz4ii8djgBjtA+WkoO/XfburWi4=:6qc1InGYYKY9ZhZZOFzgHXd/sSH370BmYLjBjXwOA1o=' SUPERUSER CREATEDB…
PGXN packaging, automatic versions, and publishing
… package workflow rebuilds the ZIP from the exact stable release SHA, verifies that vX.Y.Z points to that SHA, and uploads it directly to PGXN Manager over HTTPS.A rerun is idempotent.
Release Process
… V1 uses a GitHub-verified signed annotated tag, published SHA-256 checksums, a Sigstore attestation for the source archive, the immutable candidate SHA in provenance, and an attested OCI manifest…
OmniPITR - omnipitr-backup-slave
… checksums: MD5 - standard md5 algorithm SHA-1 - SHA-1 algorithm SHA-256 - SHA-2 algorithm with hash size of 256 bits SHA-384 - SHA-2 algorithm with hash size of 384 bits SHA-512 - SHA-2 algorithm…
Release Compatibility Fixtures
Record the producing pgGraph/PostgreSQL versions, platform, SHA-256, and expected load or rebuild result. Never regenerate an existing fixture in place. Add a new versioned fixture.
Optional real semantic model tests
… and records each downloaded ONNX artifact’s byte length and SHA-256 digest in target/real-semantic-models/installed-models.json. The smoke report records the models, revisions, digests, platform…
Release Gates
… its protected publish mode requires the exact tag, candidate SHA, prepare run, and both accepted manifest digests. See the release process, release matrix, and release tooling.
Security
Management authorization API Admin bearer tokens (SHA-256 fingerprints, constant-time check).Tamper resistance core AEAD authentication tag; AAD binds ciphertext to name:version.
Threat model
Spoofing an admin High-entropy bearer tokens; only SHA-256 fingerprints stored; constant-time check; revocation.Tampering with stored ciphertext AEAD tag fails open; AAD binds ciphertext to…
pgpasswd
… password: Confirm new password: ALTER USER test PASSWORD 'SCRAM-SHA-256$4096:oHFXEfD/ol1RTHvsUCjPMQ==$+yZF9VQO3vlq+ypOA+Fbyv6oao22VoQQx0gHHR5gyeQ=:+vELUZddKLWUDMxNAPOD9IW8W6pl5eAt9bcky1XkbvI='…
pgmnemo Scientific-Technical Release Process
json, pinned SHA) recall@5/10/25/50, MRR, per-category Run full 1982+ questions, not sampledLongMemEval-S xiaowu0162/longmemeval-cleaned (longmemeval_s_cleaned.
pgmnemo — Strategic Charter
… gate on writes none provenance gate — write requires commit SHA or artifact hashMulti-agent role isolation RLS or none first-class — role + project + provenance compositeVendor lock-in yes (data…
P9 open-type query evidence
The retained metadata binds its image revision and source-archive SHA-256 to that commit. Each query-phase sample was accepted only while every exact backend PID reported the marked traversal…
Fuzzing
Each report records the command, target, corpus path, commit SHA, host OS, boundary, status, exit code, requested duration, measured elapsed duration, and per-target log path.
Unsafe Review
The no-flag form executes every row and is owned by the frozen-SHA hardening phase. When a later product slice adds an unsafe owner, validated mmap view, callback surface, or subprocess harness…
pgmnemo Usage Guide
… Examples -- Minimal: text-only lesson with provenance via commit SHA SELECT pgmnemo.ingest( 'developer', 1, 'security', 'Rotate JWT secrets within 24 hours of any key-compromise indicator.
Semantic reranking
… returns a versioned envelope containing the authorized text and SHA-256 content digest. Private candidate rows retain identity, version, digest, fusion provenance, and allow-listed metadata, but do…
pgmnemo — POSITIONING v0.1
… gate Yes — lesson write blocked without commit SHA or artifact hash No No No No NoMulti-agent role isolation Yes — PostgreSQL RLS per agent role + project composite API-level only (no DB…
FbSQL
… by CI on every push to main (tags: latest, the short commit SHA, and the version on release tags). To build the identical image locally instead: scripts/docker-build.
pgmnemo — Tactical Plan, Month 1
00W3.3 Provenance gate trigger — verify commit SHA / artifact hash before promotion backend_developer (70) $4.00W3.4 Demo case 1: Claude Code agent reading from pgmnemo (script + README)…
Design decisions
The default posture is deny. 8. Admin tokens stored as SHA-256 fingerprints, compared in constant time Decision. Generate 256-bit random tokens; store only sha256(token); verify with a constant-time…
Feedback on the pg_trickle requirements for pg-mdm
… release commit, tag object, package URL, PostgreSQL major, and SHA-256. If the package changes, rerun all applicable earlier admission gates.
REPORT_PGWIRE_PROXY.md — pgwire Proxy / Intercept Analysis
Handle startup, auth (cleartext, MD5, SCRAM-SHA-256), simple query, extended query, COPY, cancel, notifications. Client (backend): Connect to upstream PG. Same protocol coverage.
Benchmark Methodology
Reporting Benchmark reports must include: commit SHA and whether the worktree was clean; Rust toolchain, PostgreSQL version, target OS, and CPU model; dataset name, row count, dimensions, tenant…
REST API
… "payment" } 201 Created → the raw token, shown once (only its SHA-256 is stored): { "name": "payments-svc", "role": "payment", "token": "f3q...
pg_uuid_v8
… Available Algorithms XOR (default): XOR-based obfuscation with SHA-256 key derivation from seed AES128: AES-128 encryption in ECB mode for cryptographically secure timestamp protection AES256…
Release WorkflowMerged, user-facing changes since the previous tagResolve a squashed commit to its PR when the number isn’t in the subject
md`. **Cut line (PRs in this release):** _…_ **Tag commit:** _<sha>_ **Published by:** _…_ - [ ] Cut line confirmed - [ ] Changelog merged (PR #…) - [ ] Version/upgrade-script sanity - [ ] CI green…
Automatic document chunking
… generation remains visible only while its source version and SHA-256 still match an invoker-visible authoritative row. A source edit, delete, SELECT revocation, or RLS change hides stale chunks…
PgClone Manual Testing Guide
… Installed + preloaded Installed + preloadedAuth scram-sha-256 scram-sha-256Connection string used throughout: host=172.17.0.2 port=5432 dbname=db1 user=postgres password=123654 All SQL commands run…
pg_durable User Guide
… c ON CONFLICT (sha) DO UPDATE SET fetched_at = now() RETURNING sha' ~> df.wait_for_schedule('*/30 * * * *') -- Every 30 minutes ), 'github-commit-sync' ); -- Check the results SELECT sha, author…
Release Process
zip Extension files for Windows x64SHA256SUMS.txt SHA-256 checksums for all archivesghcr.io/grove/pg_trickle-ext:<ver> CNPG extension image for Image Volumes (amd64 + arm64)Installing from an archive…
Installed SQL Object And Option Inventory
Full SQL artifact SHA-256: e64dcfb289a4c21a05cc055a4a0e45f548258164674747660029a9b4d6ac1fdc The artifact fingerprint covers every object declaration, function result shape, cast method/context…
Appendix E. Veil2 Authentication Protocols
Create a sha-1 hash of the concatenated string. Encode the hash as a base64 string. The open_connection() function will create the same encoded hash internally and check that it matches.
pg-mdm requirements for pg_trickle in v0.9 through v0.11
… release commit, tag object, package URL, PostgreSQL major, and SHA-256. pg-mdm records those values in its DEPENDENCIES.md and reruns the admission suite for each dependency update.
PLAN: SQL Gaps — Phase 5
… ordinal} at creation timeschema_fingerprint TEXT SHA-256 of serialized column snapshot — fast equality checkOn each DDL event, compare the current pg_attribute state against the stored snapshot.
Supported Features
… expiry, logical occurrence and point IDs, source version and SHA-256 digest, fused rank/score, branch contributions, and allow-listed metadata.
Plan: Architecture Decision Records
… key matching (no extra column, but complex MERGE logic) - MD5/SHA hash (cryptographically stronger but slower) Key points: - 8 bytes vs 16 bytes per row (significant at scale) - Collision…
Plan: dbt Integration via Custom Materialization Macro
git" revision: v0.1.0 # git tag, branch, or commit SHA subdirectory: "dbt-pgtrickle" Then run: dbt deps # clones pg-trickle repo, installs only dbt-pgtrickle/ subfolder Note: dbt deps performs a…
pgsodium
… will always have the same fingerprint, similar to the MD5 or SHA-1 functions for which crypto_generichash() is a faster and more secure alternative. But a key can also be specified.
PostgreSQL Partition Manager Extension (pg_partman)
Uses pg_dump, creates a SHA-512 hash file of the dump file, and then drops the table. When combined with the retention_schema configuration option, provides a way to reliably dump out tables that…
Benchmarks
Miss schedule is deterministic per-query via SHA-256 hash (seed=42). Local, 200K pairs x 5 hops, 64D, 8 shards, 32 queries, 3 runs, ann_k=256, top_k=32, ef_search=128, m=16, ef_construction=64…
Benchmarks426 for both the anchored and the infix case.682).** The Iceberg work is on the Iceberg read path. It does not touch the scan,598 gates the gating on projected payload width, a plan-time property the unreliable LIKE '%...%' estimate cannot corrupt.
Each run therefore prints the SHA-256 of both fetched files: definition: create.sql 42d28575fd59fb4a queries.sql a7d6673357348ee9 Those are the real digests of upstream main as of 2026-08-06, 43…
SQL reference
With dedup, the function records the SHA-256 of the file after a successful load, in pgcolumnar.load_fingerprint. A later load of a file with the same contents into the same table stores nothing…