PostgreSQL Experts™

...because your data is your business

 
May 19, 2021, 8:37 a.m.

pgx_scripts

Description: A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.


Created by: pgexperts
April 23, 2021, 11:32 a.m.

pgconnparms

Description: Create command-line parameters from a postgres: URI


Created by: pgexperts
Feb. 18, 2021, 11:53 a.m.

flexible-freeze

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


Created by: pgexperts
Jan. 22, 2019, noon

json_build

Description: Functions to help build JSON objects in PostgreSQL


Created by: pgexperts
May 17, 2018, 8:33 a.m.

pg_merge_table

Description: Command-line script to merge a table from one PostgreSQL database to another


Created by: pgexperts
March 26, 2018, 1:06 p.m.

pgtap

Description: PostgreSQL Unit Testing Suite


Created by: pgexperts
Oct. 23, 2017, 10:23 p.m.

find-bad-toast

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


Created by: pgexperts
May 30, 2016, 9:41 a.m.

django

Description: The Web framework for perfectionists with deadlines.


Created by: pgexperts
April 12, 2016, 7:12 p.m.

ldap_fdw

Description: A LDAP Foreign Data Wrapper for PostgreSQL


Created by: pgexperts
Jan. 12, 2016, 11:19 a.m.

patroni

Description: Runners to orchestrate a high-availability PostgreSQL


Created by: pgexperts
Jan. 8, 2016, 7:17 p.m.

patroni-compose

Description: docker-compose based test environment for patroni


Created by: pgexperts
Dec. 4, 2015, 3:05 p.m.

pgbouncer_gmetric

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


Created by: pgexperts
Nov. 10, 2015, 3:50 a.m.

accidentalDBA

Description: Files for the Accidental DBA tutorial


Created by: pgexperts
Sept. 17, 2015, 12:17 p.m.

micro_instrumentation

Description: Instrument pieces of functions


Created by: pgexperts
Aug. 24, 2015, 9:32 p.m.

governor

Description: Runners to orchestrate a high-availability PostgreSQL


Created by: pgexperts
June 26, 2015, 6:37 p.m.

jsonbx

Description: jsonbx extension for PostgreSQL 9.4


Created by: pgexperts
June 26, 2015, 5:52 p.m.

jsquery

Description: JsQuery – json query language with GIN indexing support


Created by: pgexperts
June 17, 2015, 12:45 p.m.

handyrep

Description: High-availability replication manager for PostgreSQL


Created by: pgexperts
May 31, 2015, 5:46 a.m.

redis_fdw-dev

Description: development branch of redis_fdw for writable tables


Created by: pgexperts
May 8, 2015, 3:01 p.m.

pg_plan_filter

Description: filter statements by their execution plans.


Created by: pgexperts
March 12, 2015, 4:14 p.m.

pgbouncer_bench

Description: Basic script to benchmark pgbouncer vs direct connection


Created by: pgexperts
March 10, 2015, 1:44 p.m.

pgbouncer-dev

Description: PgBouncer dev tree


Created by: pgexperts
April 15, 2014, 7:13 a.m.

libusual

Description: Modern C Environment


Created by: pgexperts
Dec. 25, 2013, 5:28 p.m.

explanation

Description: Turn an explain plan into a table organized as a proximity tree


Created by: pgexperts
Dec. 18, 2013, 5:09 p.m.

saltstack-talk-examples

Description: Some examples to use with my Saltstack talk


Created by: pgexperts
Oct. 28, 2013, 10:17 a.m.

stream-scaling

Description: Automate memory bandwidth testing with STREAM using varying core counts


Created by: pgexperts
Oct. 17, 2013, 4:12 p.m.

pg_partman

Description: Partition management extention for PostgreSQL


Created by: pgexperts
Oct. 2, 2013, 11:04 a.m.

resource-agents

Description: Combined repository of OCF agents from the RHCS and Linux-HA projects


Created by: pgexperts
Aug. 19, 2013, 2:33 p.m.

barman-cleanup

Description: None


Created by: pgexperts
Aug. 5, 2013, 3:42 p.m.

wal-e

Description: A S3 based WAL-shipping disaster recovery and standby toolkit


Created by: pgexperts
July 22, 2013, 7:22 p.m.

salt

Description: Central system and configuration manager


Created by: pgexperts
May 25, 2013, 9:17 a.m.

librec

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


Created by: pgexperts
April 17, 2013, 4:28 p.m.

caching_benchmark_scripts

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


Created by: pgexperts
March 6, 2013, 4:38 p.m.

postgrestesting

Description: Repository for the postgrestesting project, which aims to make more of PostgreSQL automatically testable and tested.


Created by: pgexperts
Feb. 27, 2013, 5:53 p.m.

pgbackup

Description: None


Created by: pgexperts
Feb. 27, 2013, 5:48 p.m.

upstart-scripts

Description: Upstart scripts for various services


Created by: pgexperts
Feb. 27, 2013, 5:41 p.m.

cpnewfiles

Description: 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.


Created by: pgexperts
Feb. 27, 2013, 5:41 p.m.

pg_find_bad_utf8

Description: Python script that takes a SQL pg_dump as input and outputs COPY commands containing the bad utf8 rows.


Created by: pgexperts
Feb. 27, 2013, 5:32 p.m.

add-pgdg-apt-repo

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


Created by: pgexperts
Nov. 16, 2012, 2:58 p.m.

schemanager

Description: Python and YAML based schema management tool.


Created by: pgexperts
Nov. 12, 2012, 12:54 p.m.

oracleism-hunter

Description: Perl scripts to find Oracleisms in your PostgreSQL log files


Created by: pgexperts
May 10, 2012, 6:08 p.m.

exercise_unlogged_tables

Description: None


Created by: pgexperts
March 28, 2012, 7:34 p.m.

noisewords

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


Created by: pgexperts
Sept. 22, 2011, 9:35 p.m.

pg-rolldump

Description: Time-based rolling PostgreSQL cluster backups


Created by: pgexperts
May 31, 2011, 10:04 a.m.

ts_count

Description: count tsvector positions for tsquery terms


Created by: pgexperts

Our Repos

Github Accounts