1-12 of 12 found

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.

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…

Contributing to Citus

… the commit that you want to backport git cherry-pick -x <sha> (the -x is important) Push the branch git push Wait for tests to pass If the cherry-pick required non-trivial merge conflicts, create a…

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.

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…

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.

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.

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…

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…

SQL Reference

… at creation timeschema_fingerprint text SHA-256 fingerprint of column snapshot for fast equality checkscdc_mode text Current CDC mode: TRIGGER, TRANSITIONING, or WALslot_name text Replication slot…

CHANGELOG-pre-5.0.0

… dump any tables found in a given schema using pg_dump, create a SHA-512 hash of the dumped file and then drop the table from the database.