A tool to set up and manage logical replication for PostgreSQL databases

Use LDAP permissions in PostgreSQL

pg_meta gem

PostgreSQL Metrics

Simple migration tool focused on Postgresql

This tool provides a set of Rake tasks to apply changes on different Postgres environments.

Rake migration tasks which utilities pure SQL files

Connects to PostgreSQL and retrieves few statistics such as index stats and table bloats.

A tool to move postgres databases b/w clusters using bucardo

Process notifies about postgresql notifications.

PostgreSQL partitioning assistant for Rails

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

ActiveRecord extensions for PostgreSQL. Provides useful tools for schema, foreign_key, index, comment and extensios manipulations in migrations.

Shows the top queries running on your server using pg_stat_statements

pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.

Some experimentations with LISTEN/NOTIFY for background jobs

Web interface for pgq gem. Inspect pgq and londiste queues

Rails goodies.

Easily use randomized keys instead of sequential values for your record surrogate ids.

Postgres replication protocol