PostgreSQL,通常只是Postgres,是一个对象关系数据库(ORDBMS)。PostgreSQL是符合ACID和事务性的。(见更多:维基百科:PostgreSQL,PostgreSQL.org)
- 令人惊叹的 postgresql
- 资源
- BDR - 双向复制 - PostgreSQL的多主机复制系统
- Patroni - 带有ZooKeeper或etcd的PostgreSQL HA模板。
- Stolon - PostgreSQL HA基于Consul或etcd,与Kubernetes集成。
- pglookout - 复制监视和故障转移守护程序。
- repmgr - 用于管理PostgreSQL服务器集群中的复制和故障转移的开源工具套件。
- Slony-I - 具有级联和故障转移功能的“Master to multiple slaves”复制系统。
- PAF - PostgreSQL自动故障转移:Postgres的高可用性,基于Pacemaker和Corosync。
- SkyTools - 复制工具,包括排队系统PgQ和Londiste,这是一个比Slony管理起来更简单的复制系统。
- Barman - 2ndQuadrant的PostgreSQL备份和恢复管理器。
- OmniPITR - PostgreSQL的高级WAL文件管理工具。
- pg_probackup – 由@PostgresPro改进的pg_arman的分支,支持增量备份,从副本备份,多线程备份和还原,以及无归档命令的匿名备份。
- pgBackRest - 可靠的PostgreSQL备份和恢复。
- pg_back - pg_back是一个简单的备份脚本
- pghoard - 云对象存储的备份和恢复工具(AWS S3,Azure,Google Cloud,OpenStack Swift)。
- wal-e - Heroku将PostgreSQL简单连续存档到S3,Azure或Swift。
- wal-g - 在Go中重写的WAL-E的继承者。目前仅支持S3。
- pitrery - pitrery是一组用于管理PostgreSQL的即时恢复(PITR)备份的Bash脚本。
- Adminer - 用PHP编写的全功能数据库管理工具。
- OmniDB - 数据库管理的开源协作环境
- DataGrip - 具有高级工具集和良好的跨平台经验的IDE(商业软件)。
- Datazenit - 基于Web的PostgreSQL GUI(商业软件)。
- DBeaver - 通用数据库管理器,对PostgreSQL提供出色的支持。
- dbglass - PostgreSQL的跨平台桌面客户端,使用Electron构建。
- Holistics - 具有强大PostgreSQL支持的在线跨平台数据库管理工具和SQL查询报告GUI(商业软件)。
- JackDB - 基于Web的SQL查询界面(商业软件)。
- Metabase - PostgreSQL的简单仪表板,图表和查询工具。
- Numeracy - 带有PostgreSQL(商业软件)图表和仪表板的快速SQL编辑器。
- pgAdmin - PostgreSQL管理和管理GUI。
- pgModeler - pgModeler是一个开源的PostgreSQL数据库建模器。
- pgweb - 用Go编写的基于Web的PostgreSQL数据库浏览器。
- phpPgAdmin - PostgreSQL的Premier Web管理工具。
- Postbird - 用于macOS的PostgreSQL客户端。
- Postico - 用于macOS的现代PostgreSQL客户端(商业软件)。
- PSequel - 简洁的界面,可快速执行常见的PostgreSQL任务(商业软件)。
- SQL Tabs - 用JS编写的PostgreSQL跨平台桌面客户端。
- SQLPro for Postgres - 用于macOS(商业软件)的简单,强大的PostgreSQL管理器。
- temBoard - 基于Web的PostgreSQL GUI和监控。
- TablePlus - 允许您编辑数据库和结构的Native App。确保高端安全性(商业软件)。
- TeamSQL - 跨平台SQL客户端:简单,轻松,可扩展。
- Valentina Studio - 跨平台数据库管理工具(免费/商业)
- PostgresCompare - 跨平台数据库比较和部署工具(商业软件)。
- Postgres.app - 在macOS上开始使用PostgreSQL的最简单方法。
- PostgreSql.Binaries.Lite - PostgreSQL数据库的最小Windows二进制文件集。也通过NuGet提供。
- Postgres-XL - 基于PostgreSQL的可扩展开源数据库集群。
- AgensGraph - 基于PostgreSQL的强大图形数据库。
- Greenplum Database - 用于大数据量的PostgreSQL的开源分支。
- check_pgactivity - check_pgactivity旨在监控Nagios中的PostgreSQL集群。它提供了许多选项来衡量和监控有用的性能指标。
- Check_postgres - 用于检查PostgreSQL数据库状态的Nagios check_postgres插件。
- Instrumental - 实时性能监控,包括易于设置的pre-made graphs (商业软件)
- libzbxpgsql - Zabbix的综合PostgreSQL监控模块。
- Pome - Pome代表PostgreSQL指标。Pome是一个PostgreSQL指标仪表板,用于跟踪数据库的运行状况。
- pg_view - 开源命令行工具,显示全局系统统计信息,每个分区信息,内存统计信息和其他信息。
- pgwatch2 - 灵活且易于上手的PostgreSQL指标监控重点关注Grafana仪表板。
- pgbench - 在PostgreSQL上运行基准测试。
- opm.io - Open PostgreSQL Monitoring是一个免费软件套件,旨在帮助您管理PostgreSQL服务器。它可以收集统计信息,显示仪表板并在出现问题时发送警告。
- Citus - 可扩展的PostgreSQL集群,用于实时工作负载。
- cstore_fdw - 使用PostgreSQL进行分析的列式存储。
- cyanaudit - Cyan Audit以逐列为基础提供所有DML活动的数据库内日志记录。
- pglogical - 提供逻辑流复制的扩展。
- pg_partman - PostgreSQL的分区管理扩展。
- pg_paxos - PostgreSQL节点集群的Paxos和基于Paxos的表复制的基本实现。
- pg_shard - 扩展以扩展实时读写。
- PGStrom - 将CPU密集型工作负载卸载到GPU的扩展。
- pgxn PostgreSQL Extension Network - PostgreSQL扩展网络 - 许多开源PostgreSQL扩展的中心分发点
- PipelineDB - PostgreSQL扩展,在流上连续运行SQL查询,逐步将结果存储在表中。
- plpgsql_check - 允许检查plpgsql源代码的扩展。
- PostGIS - PostgreSQL的空间和地理对象。
- PG_Themis - Postgres绑定作为加密库Themis的扩展,在PgSQL方面提供各种安全服务。
- zomboDB - 通过使用Elasticsearch支持的索引实现高效全文搜索的扩展。
- pgMemento - 使用PL / pgSQL编写的触发器和服务器端函数为PostgreSQL数据库内的数据提供审计跟踪。
- Timescale - 与Postgres完全兼容的开源时间序列数据库,作为扩展分发
- pgTAP - Postgres的数据库测试框架
- HypoPG - HypoPG提供假设/虚拟索引功能。
- pgRouting - pgRouting扩展了PostGIS / PostgreSQL地理空间数据库,以提供地理空间路由和其他网络分析功能。
- PgHero - PostgreSQL insights made easy.
- pgtune - PostgreSQL configuration wizard.
- pgtune - Online version of PostgreSQL configuration wizard.
- pgconfig.org - PostgreSQL Online Configuration Tool (also based on pgtune).
- PoWA - PostgreSQL Workload Analyzer gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.
- pg_web_stats - Web UI to view pg_stat_statements.
- apgdiff - Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one.
- ERAlchemy - ERAlchemy generates Entity Relation (ER) diagram from databases.
- ldap2pg - Synchronize roles and privileges from YML and LDAP.
- mysql-postgresql-converter - Lanyrd's MySQL to PostgreSQL conversion script.
- ora2pg - Perl module to export an Oracle database schema to a PostgreSQL compatible schema.
- pg_activity - top like application for PostgreSQL server activity monitoring.
- pg-formatter - A PostgreSQL SQL syntax beautifier (Node.js).
- pganalyze - PostgreSQL Performance Monitoring (Commercial Software).
- pgbadger - Fast PostgreSQL Log Analyzer.
- PgBouncer - Lightweight connection pooler for PostgreSQL.
- pgCenter - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.
- pg_chameleon - Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.
- pgclimb - Export data from PostgreSQL into different data formats.
- pgfutter - Import CSV and JSON into PostgreSQL the easy way.
- PGInsight - CLI tool to easily dig deep inside your PostgreSQL database.
- pgloader - Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.
- pgMustard - A modern user interface
for
EXPLAIN ANALYSE
, that also provides performance tips (Commercial Software). - pgpool-II - Middleware that provides connection pooling, replication, load balancing and limiting exceeding connections.
- pgsync - Tool to sync PostgreSQL data to your local machine.
- PGXN client - Command line tool to interact with the PostgreSQL Extension Network
- postgresql-metrics - Tool that extracts and provides metrics for your PostgreSQL database.
- PostgREST - Serves a fully RESTful API from any existing PostgreSQL database.
- pREST - Serve a RESTful API from any PostgreSQL database (Golang)
- PostGraphile - Instant GraphQL API or GraphQL schema for your PostgreSQL database
- yoke - PostgreSQL high-availability cluster with auto-failover and automated cluster recovery.
- pglistend - A lightweight PostgresSQL
LISTEN
/NOTIFY
daemon built on top ofnode-postgres
. - ZSON - PostgreSQL extension for transparent JSONB compression
- pg_bulkload - It's a high speed data loading utility for PostgreSQL.
- pg_migrate - Manage PostgreSQL codebases and make VCS simple.
- sqitch - Tool for managing versioned schema deployment
- pgmigrate - CLI tool to evolve schema migrations, developed by Yandex.
- pgcmp - Tool to compare database schemas, with capability to accept some persistent differences
- graphql-engine - Get Instant Realtime GraphQL APIs over PostgreSQL.
- sqlcheck - Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.
- Common Lisp: Postmodern
- Clojure: clj-postgresql
- Elixir: postgrex
- Go: pgx
- Haskell: postgresql-simple
- Java: PostgreSQL JDBC Driver
- .Net/.Net Core: Npgsql
- Node: node-postgres, pg-promise, pogi
- Perl: DBD-Pg
- PHP: Pomm, pecl/pq
- Python: psycopg2
- Ruby: pg
- Rust: rust-postgresql
- Lua: luapgsql
- Aiven PostgreSQL - PostgreSQL as a service in AWS, Azure, DigitalOcean, Google Cloud and UpCloud; plans range from $19/month single node instances to large highly-available setups, free trial for two weeks.
- Amazon RDS for PostgreSQL - Amazon Relational Database Service (RDS) for PostgreSQL
- Azure Database for PostgreSQL - Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service. It provides builtin HA, elastic scaling and native integration with Azure ecosystem.
- Citus Cloud - Production grade scaled out PostgreSQL as a service enabling real-time workloads and sharding your multi-tenant apps.
- Compose - PostgreSQL as a service in AWS, Google Cloud Platform, and IBM Cloud; plans range from $17.5/month for 1GB storage and scale at $12/GB beyond that. Free trial for 30 days available.
- Database Labs - Get a production-ready cloud PostgreSQL server in minutes, from $20 a month Backups, monitoring, patches, and 24/7 tech support all included.
- DigitalOcean Managed Databases - Fully managed PostgreSQL databases. No free plan. Starting at $15/mo. Daily backups with point-in-time recovery. Standby nodes with auto-failover.
- ElephantSQL - Offers databases ranging from shared servers for smaller projects and proof of concepts, up to enterprise grade multi server setups. Has free plan for up to 5 DBs, 20 MB each.
- Google Cloud SQL for PostgreSQL - Fully-managed database service that makes it easy to set up, maintain, manage, and administer your PostgreSQL relational databases on Google Cloud Platform. (Beta)
- Heroku Postgres - Plans from free to huge, operated by PostgreSQL experts. Does not require running your app on Heroku. Free plan includes 10,000 rows, 20 connections, up to two backups, and has PostGIS support.
- citusdata/citus - Citus official images with citus extensions. Based on the official Postgres container.
- mdillon/postgis - PostGIS 2.3 on Postgres 9. Based on the official Postgres container.
- postgres - Official postgres container (from Docker)
- Backup and recover a PostgreSQL DB using wal-e - Tutorial about setting up continuous archiving in PostgreSQL using wal-e.
- PG Casts - Free weekly PostgreSQL screencasts by Hashrocket.
- Postgres Guide - Guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within PostgreSQL.
- PostgreSQL Exercises - Site to make it easy to learn PostgreSQL by doing exercises.
- tutorialspoint PostgreSQL tutorial - Very extensive collection of tutorials on PostgreSQL
- postgresDBSamples - A collection of sample postgres schemas
- PostgreSQL Primer for Busy People - A collection of the most common commands used in PostgreSQL
- pg-utils - Useful DBA tools by Data Egret
- Planet PostgreSQL - Blog aggregation service for PostgreSQL.
- Andrew Dunstan's PostgreSQL and Technical blog
- Bruce Momjian's PostgreSQL blog
- Craig Kerstiens PostgreSQL posts - Set of posts on PostgreSQL cool features, tips and tricks.
- Database Soup - Josh Berkus' blog.
- Michael Paquier's blog
- Robert Haas' blog
- select * from depesz; - Hubert Lubaczewski's blog.
- What PostgreSQL has over other open source SQL databases: Part I
- Debugging PostgreSQL performance, the hard way
- Why use Postgres?
- Superfast CSV imports using PostgreSQL's COPY command
- Wiki - user documentation, how-tos, and tips 'n' tricks
- Postgres Weekly - Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL.
- Citus Data Youtube channel - Citus related videos
- EnterpriseDB Youtube channel - EnterpriseDB related videos
- PGConf US Youtube channel - Conference videos
- Mailing lists - Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community.
- Slack - Slack channel for Postgres with close to 5000 users
- #postgresql on Freenode - The most popular IRC channel about Postgres on Freenode with close to 1000 users
- Reddit - A reddit community for PostgreSQL users with close to 10000 users