pgexperts Goto Github PK

accidentaldba

Files for the Accidental DBA tutorial

add-pgdg-apt-repo

Simpel shell script to add the pgdg apt.postgresql.org APT repository to a host

barman-cleanup

caching_benchmark_scripts

Tools used to benchmark various cache implementations vs going direct to a remote postgresql DB

cpnewfiles

Copy files from a source directory to a destination directory and keep track of the last copied file's timestamp. Next run, only copy new files.

django

The Web framework for perfectionists with deadlines.

exercise_unlogged_tables

find-bad-toast

Find rows in a PostgreSQL table that have corrupted TOAST records.

flexible-freeze

Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.

governor

Runners to orchestrate a high-availability PostgreSQL

handyrep

High-availability replication manager for PostgreSQL

json_build

Functions to help build JSON objects in PostgreSQL

jsonbx

jsonbx extension for PostgreSQL 9.4

jsquery

JsQuery – json query language with GIN indexing support

ldap_fdw

A LDAP Foreign Data Wrapper for PostgreSQL

librec

Fake public library database as an example database for teaching PostgreSQL.

libusual

Modern C Environment

micro_instrumentation

Instrument pieces of functions

noisewords

A quick-n-easy random data generator to test PG installations

parse_wal_dump

A simple script to parse pg_waldump output, and insert it into a database

patroni

Runners to orchestrate a high-availability PostgreSQL

patroni-cluster-guide

patroni-compose

docker-compose based test environment for patroni

pg-rolldump

Time-based rolling PostgreSQL cluster backups

pgaudit

PostgreSQL Audit Extension

pgbackup

pgbouncer-dev

PgBouncer dev tree

pgbouncer_bench

Basic script to benchmark pgbouncer vs direct connection

pgbouncer_gmetric

Queries a PgBouncer admin database and publishes statistics to Ganglia using gmetric

pgconnparms

Create command-line parameters from a postgres: URI