PostgreSQL相關的庫、工具、資源列表

PostgreSQL相關的軟件，庫，工具和資源集合。

備份

• wal-e - Simple Continuous Archiving for Postgres to S3, Azure, or Swift by Heroku
• Barman - Backup and Recovery Manager for Postgres by 2ndQuadrant
</ul>

GUI

• pgAdmin - Postgres Administration and Management GUI
• phpPgAdmin - The Premier Web Based Administration Tool for Postgres
• pgweb - Web-based PostgreSQL database browser written in Go
• Postico - A Modern PostgreSQL Client for OS X (Commercial Software)
</ul>

Distributions

• Postgres.app - The Easiest Way to Get Started with PostgreSQL on the Mac
</ul>

CLI

• pgcli - Postgres CLI with autocompletion and syntax highlighting
• psql2csv - Run a query in psql and output the result as CSV
</ul>

Server

• Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster
</ul>

Monitoring

• Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases
</ul>

Extensions

• PGStrom - Postgres extension to offload CPU intensive workloads to GPU
• pg_shard - PostgreSQL extension to scale out real-time reads and writes
• PostGIS - Spatial and Geographic objects for PostgreSQL
• pg_paxos - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes
</ul>

Optimization

• PgHero - Postgres insights made easy
• pgtune - PostgreSQL configuration wizard
</ul>

Utilities

• PostgREST - PostgREST serves a fully RESTful API from any existing PostgreSQL database
• mysql-postgresql-converter - Lanyrd's MySQL to PostgreSQL conversion script
• postgresql-metrics - Tool that extracts and provides metrics on your PostgreSQL database
• pgloader - Pgloader loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data
• pgbadger - a fast PostgreSQL Log Analyzer
• pg_activity - pg_activity is a top like application for PostgreSQL server activity monitoring
• pgfutter - Import CSV and JSON into PostgreSQL the easy way
• pganalyze - PostgreSQL Performance Monitoring (Commercial Software)
• yoke - Postgres high-availability cluster with auto-failover and automated cluster recovery
</ul>

Language bindings

• rust-postgresql - Rust
• DBD-Pg - Perl
• PostgreSQL JDBC Driver - Java
</ul>

Tutorials

• tutorialspoint PostgreSQL tutorial - A very extensive collection of tutorials on PostgreSQL
• Postgres Guide - A guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres
• Backup and recover a Postgres DB using wal-e - A tutorial about setting up continuous archiving in PostgreSQL using wal-e
• PostgreSQL Exercises - A site to make it easy to learn PostgreSQL by doing
</ul>

Blogs

• Planet PostgreSQL - A blog aggregation service for PostgreSQL
• Craig Kerstiens Postgres Posts - A set of posts on Postgres cool features/tips/tricks
</ul>

Newsletters

• Postgres Weekly - A weekly newsletter that contains articles, news, and repos relevant to Postgres
</ul>

項目主頁：http://www.baiduhome.net/lib/view/home/1450226386125