Postgres extension list - ghdrako/doc_snipets GitHub Wiki

PostgreSQL extension repositories available (PGXN, dbdev, Trunk), and pgxman.

• Extension list
• Framwork to build extension
• https://www.postgresql.org/download/products/6-postgresql-extensions/
• https://wiki.postgresql.org/wiki/PL_Matrix

pg_vector

https://jkatz05.com/post/postgres/pgvector-overview-0.5.0/

pg_analitics

• https://github.com/paradedb/paradedb/tree/dev/pg_analytics

• https://github.com/cpursley/walex

pg_crash Chaos Monkey

• https://github.com/cybertec-postgresql/pg_crash

https://github.com/hapostgres/pg_auto_failover

pgsql http - HTTP client for PostgreSQL, retrieve a web page from inside the database.

• https://github.com/pramsey/pgsql-http/

pginspect - low-level inspection of database pages

• https://www.postgresql.org/docs/current/pageinspect.html

pgbuffercache

• https://www.postgresql.org/docs/current/pgbuffercache.html
• auth_delay extension - causes the server to pause briefly before reporting authentication failure, to make brute-force attacks on database passwords more difficult.
  • https://www.postgresql.org/docs/current/auth-delay.html

pgstattuple — obtain tuple-level statistics

• https://www.postgresql.org/docs/current/pgstattuple.html

pg_failover_slots

• https://github.com/EnterpriseDB/pg_failover_slots

pg_checksum (Postgres 12+)

• https://www.crunchydata.com/blog/fun-with-pg_checksums
• https://www.postgresql.org/docs/current/app-pgchecksums.html
• https://www.cybertec-postgresql.com/en/postgresql-creating-checksums-for-tables/

Only checksum the actual table and index data files used by Postgres, but there are other parts of the system that are not checked. Not the system catalogs, nor things like the free space map - only the data itself.

Enablechecksum when creating a new Postgres cluster.

When you invoke the initdb program, add the --data‑checksums flag (or -k if you prefer obscure arguments), and your shiny new Postgres cluster will have data checksums enabled.

Enable checksum on existing luster using pg_checksum

Data checksums are a mechanism to ensure the integrity of data stored in PostgreSQL. When enabled, PostgreSQL calculates and stores checksums for each block of data in the database. During reads, the checksums are recalculated, and any discrepancy indicates possible data corruption. This helps in early detection of issues, providing a higher level of data reliability. Enabling data checksums is especially valuable in critical production environments where data integrity is paramount, offering an additional layer of protection against silent data corruption.

The tool is able to do three modes now in total:

• check, the default if nothing is specified and what pg_verify_checksums was already able to do. This mode scans all the relation file blocks, reporting any mismatch.

• enable, which enables data checksums. This rewrites all the relation file blocks, and finishes the operation by updating the control file. Note that this can be take time depending on the size of the instance, and that the tool has no parallel mode.

• disables which disables data checksums by only updating the control file.

• verify if is instaled

$ psql -Axtc 'show data_checksums'
data_checksums|off

$ pg_controldata | grep -E 'state|checksum'
Database cluster state: in production
Data page checksum version: 0

systemctl stop postgresql-15      
pg_checksums --check -D /path/to/data_directory
systemctl start postgresql-15

Or

SHOW data_checksums;

• Enable data checksums

systemctl stop postgresql-15 # or pg_ctl stop --mode=fast
pg_checksums --enable -D /var/lib/pgsql/15/data/  
# to report progres use
$ pg_checksums --enable --progress
systemctl start postgresql-15. # pg_ctl start

• Once checksums are enabled, subsequent calls to pg_checksums --check can successfully verify the integrity of data pages. The cluster musy be shut down

• Disable data checksum

time pg_checksums --disable