PostgreSQL相关的库、工具、资源列表

admin 9年前

PostgreSQL相关的软件,库,工具和资源集合。

备份

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

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)

Distributions

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

CLI

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

Server

  • Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

Monitoring

  • Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases

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

Optimization

  • PgHero - Postgres insights made easy
  • pgtune - PostgreSQL configuration wizard

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

Language bindings

Tutorials

Blogs

Newsletters

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

项目主页:http://www.open-open.com/lib/view/home/1450226386125