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

短命女 2022-01-06 12:25 48阅读 0赞

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][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][pg_shard] \- PostgreSQL extension to scale out real-time reads and writes
 *  [PostGIS][] \- Spatial and Geographic objects for PostgreSQL
 *  [pg\_paxos][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] \- 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 ###

*  [rust-postgresql][] \- [Rust][]
 *  [DBD-Pg][] \- [Perl][]
 *  [PostgreSQL JDBC Driver][] \- [Java][]

### 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

### Blogs ###

*  [Planet PostgreSQL][] \- A blog aggregation service for PostgreSQL
 *  [Craig Kerstiens Postgres Posts][] \- A set of posts on Postgres cool features/tips/tricks

### Newsletters ###

*  [Postgres Weekly][] \- A weekly newsletter that contains articles, news, and repos relevant to Postgres

项目主页：[http://www.open-open.com/lib/view/home/1450226386125][http_www.open-open.com_lib_view_home_1450226386125]

### [dhamaniasad][] / [awesome-postgres][] ###

Watch [2675][]Fork [136][]

项目描述：A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql — [查看更多内容...][...]

[http://www.asad.pw/awesome-postgres/][http_www.asad.pw_awesome-postgres]

<table> 
 <tbody> 
  <tr> 
   <td colspan="2"><a href="https://github.com/dhamaniasad/awesome-postgres/issues" rel="nofollow">问题列表：</a></td> 
  </tr> 
  <tr> 
   <td>#94</td> 
   <td><a href="https://github.com/dhamaniasad/awesome-postgres/pull/94" rel="nofollow">add pgpool-II tool</a></td> 
   <td align="right">由&nbsp;<a href="https://github.com/olshevskiy87" rel="nofollow">olshevskiy87</a>&nbsp;&nbsp;2016-05-08</td> 
  </tr> 
  <tr> 
   <td>#93</td> 
   <td><a href="https://github.com/dhamaniasad/awesome-postgres/pull/93" rel="nofollow">add Telegraf A postgres metric recovery</a></td> 
   <td align="right">由&nbsp;<a href="https://github.com/arthtux" rel="nofollow">arthtux</a>&nbsp;&nbsp;2016-05-04</td> 
  </tr> 
  <tr> 
   <td>#74</td> 
   <td><a href="https://github.com/dhamaniasad/awesome-postgres/issues/74" rel="nofollow">Looking for maintainers</a></td> 
   <td align="right">由&nbsp;<a href="https://github.com/dhamaniasad" rel="nofollow">dhamaniasad</a>&nbsp;&nbsp;2016-03-12</td> 
  </tr> 
  <tr> 
   <td>#55</td> 
   <td><a href="https://github.com/dhamaniasad/awesome-postgres/pull/55" rel="nofollow">Update README.md</a></td> 
   <td align="right">由&nbsp;<a href="https://github.com/dva" rel="nofollow">dva</a>&nbsp;&nbsp;2016-03-10</td> 
  </tr> 
  <tr> 
   <td>#52</td> 
   <td><a href="https://github.com/dhamaniasad/awesome-postgres/pull/52" rel="nofollow">Add luapgsql, a Lua binding for PostgreSQL</a></td> 
   <td align="right">由&nbsp;<a href="https://github.com/mbalmer" rel="nofollow">mbalmer</a>&nbsp;&nbsp;2016-03-10</td> 
  </tr> 
 </tbody> 
</table>

*  [《PG技术沙龙ppt》][PG_ppt]

介绍：2013年4月PG技术沙龙PPT

*  [《PG9.1中文翻译文档》][PG9.1]

介绍：PG9.1中文翻译文档

*  [《PostgreSQL vs. MS SQL Server》][PostgreSQL vs. MS SQL Server]

介绍：PostgreSQL与 MS SQL Server的对比,[中文版][Link 1]

*  [《PostgreSQL 30天 培训视频》][PostgreSQL 30_]

介绍：作者从事pg截止目前大概有7-8年，长期活跃在国内的pg社区。这套PostgreSQL 30天 培训视频包含了SQL基础,备份恢复,HA,服务端编程,大数据,内核,应用案例等，非常适合新手

*  [《PostgreSQL爱好者的参考资料推荐》][PostgreSQL]

介绍：PostgreSQL爱好者的参考资料推荐

*  [《PostgreSQL Studio》][PostgreSQL Studio]

介绍：PostgreSQL Studio 是开源的 PostgreSQL 数据库的 Web 接口。可以让你直接在浏览器上编辑数据库代码，浏览数据库模型和运行 SQL 语句。这是一个数据库管理工具，侧重于开发。

*  [《PostgreSQL Query Cache》][PostgreSQL Query Cache]

介绍：PostgreSQL Query Cache 一个新的开源软件，用来极速提升 PostgreSQL 数据库的查询性能，通过缓存查询结果，可提升 10 ~ 100 倍。

*  [《py-postgresql》][py-postgresql]

介绍：Python的PostgreSQL驱动。

*  [《pgDesigner》][pgDesigner]

介绍：pgDesigner 是一个为PostgreSQL数据库设计的建模工具.仅支持Linux。

*  [《pgweb》][pgweb 1]

介绍：一个采用 Go 语言开发的基于 Web 的 PostgreSQL 管理系统。

*  [《pgwatch》][pgwatch]

介绍：一个简单易用的 PostgreSQL 的监控工具，支持 PostgreSQL 9.0 以及更新的版本。

*  [《pgpool-II》][pgpool-II]

介绍：pgpool-II 是运行于 PostgreSQL 数据库服务器和客户端之间的一个中间件，提供的功能包括：连接池、复制、负载均衡、客户端限制和并行查询等。

*  [《pgCluu》][pgCluu]

介绍：pgCluu 是一个对 PostgreSQL 集群性能进行完整审计的工具，该工具分为两部分： 1. collector 收集器用于从 PostgreSQL 集群中获取统计数据，使用 psql 和 sar 工具 2. grapher 关于生成 HTML 报表和图表 数据库服务器和客户端之间的一个中间件，提供的功能包括：连接池、复制、负载均衡、客户端限制和并行查询等。

*  [《cstore\_fdw》][cstore_fdw]

介绍：cstore\_fdw 实现了 PostgreSQL 数据库的柱状存储，用于对批量加载的数据进行分析的场景。

*  [《Barman for PostgreSQL》][Barman]

介绍：Barman (备份和恢复管理器) for PostgreSQL 是 PostgreSQL 数据库服务器的灾难恢复工具，允许远程备份多个服务器，帮助 DBA 在数据恢复阶段的关键工作。

*  [《pgFouine》][Barman]

介绍：pgFouine 是一个 PostgreSQL 的日志分析软件，可以让你对 PostgreSQL 数据库的运行状态有个清晰的了解，同时对一些慢查询、使用频率最高的查询、错误生成相应的报表和图表。

*  [《Substitute PostgreSQL for Your NoSQL Needs》][Substitute PostgreSQL for Your NoSQL Needs]

介绍：用PostgreSQL替换你的NoSQL。

*  [《Representing Trees in PostgreSQL》][Representing Trees in PostgreSQL]

介绍：Representing Trees in PostgreSQL

*  [《Michael Paquier》][Michael Paquier]

介绍：推荐一个博客，作者是一位日本的开发者。但是文章写的挺好的。是英文！！

*  [《Using Writeable CTEs to Improve Performance in PostgreSQL 》][Using Writeable CTEs to Improve Performance in PostgreSQL]

介绍：使用CTEs来提升你的数据库性能

*  [《Fast pagination on PostgreSQL》][Fast pagination on PostgreSQL]

介绍：PostgreSQL的快速分页

*  [《Upgrading your PostgreSQL cluster from 9.3 to 9.4 》][Upgrading your PostgreSQL cluster from 9.3 to 9.4]

介绍：把你的PostgreSQL集群从9.3升级到9.4.

*  [《Making PostgreSQL scale Hadoop-style: Benchmark numbers》][Making PostgreSQL scale Hadoop-style_ Benchmark numbers]

介绍：Making PostgreSQL scale Hadoop-style: Benchmark numbers

*  [《So You Want Another PostgreSQL Database？》][So You Want Another PostgreSQL Database]

介绍：还有[part2][]

*  [《PostgreSQL Rising》][PostgreSQL Rising]

介绍：PostgreSQL的成长

*  [《Simple API with Nginx and PostgreSQL》][Simple API with Nginx and PostgreSQL]

介绍：如何建一个简单的REST API 仅仅使用 Nginx 和 PostgreSQL.如果不理解REST API这里推荐[RESTful API 设计指南][RESTful API]、[理解RESTful架构][RESTful]

*  [《hypervault》][hypervault]

介绍：PostgreSQL connection manager for scalability freaks.

*  [《PostgreSQL as a benchmarking tool》][PostgreSQL as a benchmarking tool]

介绍：PostgreSQL as a benchmarking tool

*  [《2014年 PGcon会议paper》][2014_ PGcon_paper]

介绍：2014年 PGcon会议paper，进去之后你还可以发现往年的paper。

*  [《PSequel》][PSequel]

介绍： Mac OS X端的PostgreSQL图形管理工具

*  [《PostgreSQL’s Powerful New Join Type:LATERAL》][PostgreSQL_s Powerful New Join Type_LATERAL]

介绍： PostgreSQL’s Powerful New Join Type: LATERAL，这个类型是在9.3的版本中开始的。

*  [《PostgreSQL Hardware Performance Tuning》][PostgreSQL Hardware Performance Tuning]

介绍：PostgreSQL的硬件性能调优。

*  [《PostgreSQL: Introduction and Concepts Bruce Momjian》][PostgreSQL_ Introduction and Concepts Bruce Momjian]

介绍：入门型电子书籍,书有点老了2001年的了。此外这本书的作者还有一个[资源页][Link 2]，里面有很多的干货。作者是enterpriseDB的工程师。经典文章还有[Writing PostgreSQL Applications][].

*  [《Compiling PLV8 with Postgres Plus Advanced Server》][Compiling PLV8 with Postgres Plus Advanced Server]

介绍：[什么是PLV8？][PLV8],魅力就是:用js写SQL

*  [《fosdem 2014年PostgreSQL议题(含视频)》][fosdem 2014_PostgreSQL]

介绍:[fosdem][]是一个开源性组织,这个只是会议的一部分，从2001年开始到目前历经13年的[资料][Link 3]都被保存着，如果你有需要可以自己去翻阅。干货很多，另外2015年的议题已经开始筹备了[官方地址][Link 4]

\*[《PostgreSQL Now Has Logical Decoding》][PostgreSQL Now Has Logical Decoding]

介绍：PostgreSQL Now Has Logical Decoding,此外作者也是一位enterpriseDB的工程师，他的其他[博文][Link 5]也很精彩.

*  [《美国2014年pgconf paper》][2014_pgconf paper]

介绍：美国2014年pgconf paper。

*  [《mysql2postgres》][mysql2postgres]

介绍：把MySQL迁移至postgreSQL?不如试试这个工吧

*  [《What are the advantages and disadvantages of using PostgreSQL over MySQL?》][What are the advantages and disadvantages of using PostgreSQL over MySQL]

1,[Postgres 自动故障转移Manatee][Postgres _Manatee][https://github.com/joyent/manatee][https_github.com_joyent_manatee]

2,pgsql图片保存插件 [ https://github.com/drotiro/postpic][https_github.com_drotiro_postpic]

3,[Super-smack 是一个强大的广受赞誉的压力测试工具，支持MySQL和PostgreSQL][Super-smack _MySQL_PostgreSQL]

4,经典sql测试工具 [https://sourceforge.net/projects/benchmarksql/][https_sourceforge.net_projects_benchmarksql]

*5,postgresql负载监控工具 [http://dalibo.github.io/powa/][http_dalibo.github.io_powa]*

*6,postgresql地理多主复制 https://github.com/2ndQuadrant/bdr*

*7，https://github.com/postgres-x2/postgres-x2 多主复制集群*

*8, yoke [https://github.com/nanopack/yoke][yoke]*

*来自：[https://github.com/ty4z2008/Qix/blob/master/pg.md][https_github.com_ty4z2008_Qix_blob_master_pg.md]*

转自: [http://www.open-open.com/lib/view/open1450226386125.html][http_www.open-open.com_lib_view_open1450226386125.html]

转载于:https://www.cnblogs.com/fangyuan303687320/p/5493445.html

[wal-e]: https://github.com/wal-e/wal-e
[Barman]: http://www.pgbarman.org/
[pgAdmin]: http://pgadmin.org/
[phpPgAdmin]: https://github.com/phppgadmin/phppgadmin
[pgweb]: https://github.com/sosedoff/pgweb
[Postico]: https://eggerapps.at/postico/
[Postgres.app]: http://postgresapp.com/
[pgcli]: https://github.com/dbcli/pgcli
[psql2csv]: https://github.com/fphilipe/psql2csv
[Postgres-XL]: http://www.postgres-xl.org/
[Check_postgres]: https://github.com/bucardo/check_postgres
[PGStrom]: https://wiki.postgresql.org/wiki/PGStrom
[pg_shard]: https://github.com/citusdata/pg_shard
[PostGIS]: http://postgis.net/
[pg_paxos]: https://github.com/citusdata/pg_paxos/
[PgHero]: https://github.com/ankane/pghero
[pgtune]: https://github.com/gregs1104/pgtune/
[PostgREST]: https://github.com/begriffs/postgrest
[mysql-postgresql-converter]: https://github.com/lanyrd/mysql-postgresql-converter
[postgresql-metrics]: https://github.com/spotify/postgresql-metrics
[pgloader]: https://github.com/dimitri/pgloader
[pgbadger]: https://github.com/dalibo/pgbadger
[pg_activity]: https://github.com/julmon/pg_activity
[pgfutter]: https://github.com/lukasmartinelli/pgfutter
[pganalyze]: https://pganalyze.com/
[yoke]: https://github.com/nanopack/yoke
[rust-postgresql]: https://github.com/sfackler/rust-postgres
[Rust]: http://www.rust-lang.org/
[DBD-Pg]: http://search.cpan.org/~rudy/DBD-Pg/Pg.pm
[Perl]: https://www.perl.org/
[PostgreSQL JDBC Driver]: https://jdbc.postgresql.org/
[Java]: https://www.java.com/
[tutorialspoint PostgreSQL tutorial]: http://www.tutorialspoint.com/postgresql/
[Postgres Guide]: http://postgresguide.com/
[Backup and recover a Postgres DB using wal-e]: https://coderwall.com/p/cwe2_a/backup-and-recover-a-postgres-db-using-wal-e
[PostgreSQL Exercises]: http://pgexercises.com/
[Planet PostgreSQL]: https://planet.postgresql.org/
[Craig Kerstiens Postgres Posts]: http://www.craigkerstiens.com/categories/postgres/
[Postgres Weekly]: http://www.postgresweekly.com/
[http_www.open-open.com_lib_view_home_1450226386125]: http://www.open-open.com/lib/view/home/1450226386125
[dhamaniasad]: https://github.com/dhamaniasad
[awesome-postgres]: https://github.com/dhamaniasad/awesome-postgres
[2675]: https://github.com/dhamaniasad/awesome-postgres/watchers
[136]: https://github.com/dhamaniasad/awesome-postgres/network
[...]: https://github.com/dhamaniasad/awesome-postgres#readme
[http_www.asad.pw_awesome-postgres]: http://www.asad.pw/awesome-postgres/
[PG_ppt]: http://wenku.it168.com/org/145
[PG9.1]: https://wiki.postgresql.org/wiki/9.1%E6%96%87%E6%A1%A3%E7%BF%BB%E8%AF%91%E9%A1%B9%E7%9B%AE
[PostgreSQL vs. MS SQL Server]: http://www.pg-versus-ms.com/
[Link 1]: http://www.oschina.net/translate/postgresql-vs-ms-sql-server
[PostgreSQL 30_]: http://blog.163.com/digoal@126/blog/static/16387704020141229159715/
[PostgreSQL]: http://blog.163.com/digoal@126/blog/static/163877040201172183022203/
[PostgreSQL Studio]: http://www.postgresqlstudio.org/
[PostgreSQL Query Cache]: http://code.google.com/p/pqc/
[py-postgresql]: http://python.projects.pgfoundry.org/
[pgDesigner]: http://sourceforge.net/projects/pgdesigner/
[pgweb 1]: https://github.com/sosedoff/pgweb/
[pgwatch]: http://www.cybertec.at/postgresql_produkte/pgwatch-cybertec-enterprise-postgresql-monitor/
[pgpool-II]: http://www.pgpool.net/mediawiki/index.php/Main_Page
[pgCluu]: http://pgcluu.darold.net/
[cstore_fdw]: https://github.com/citusdata/cstore_fdw
[Substitute PostgreSQL for Your NoSQL Needs]: http://news.dice.com/2014/11/24/substitute-postgresql-nosql-needs/
[Representing Trees in PostgreSQL]: http://woss.name/articles/representing-trees-in-postgresql/
[Michael Paquier]: http://michael.otacoo.com/
[Using Writeable CTEs to Improve Performance in PostgreSQL]: http://omniti.com/seeds/writable-ctes-improve-performance
[Fast pagination on PostgreSQL]: http://chrisdone.com/posts/postgresql-pagination
[Upgrading your PostgreSQL cluster from 9.3 to 9.4]: https://www.florian-schlachter.de/post/upgrading-postgres-9-3-9-4/
[Making PostgreSQL scale Hadoop-style_ Benchmark numbers]: http://www.citusdata.com/blog/86-making-postgresql-scale-hadoop-style
[So You Want Another PostgreSQL Database]: http://engineroom.trackmaven.com/blog/so-you-want-another-postgresql-database-part-1
[part2]: http://engineroom.trackmaven.com/blog/so-you-want-another-postgresql-database-part-2/
[PostgreSQL Rising]: http://rob.conery.io/2012/07/19/postgresql-rising/
[Simple API with Nginx and PostgreSQL]: http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-nginx-and-postgresql.html
[RESTful API]: http://www.ruanyifeng.com/blog/2014/05/restful_api.html
[RESTful]: http://www.ruanyifeng.com/blog/2011/09/restful.html
[hypervault]: https://github.com/tetsuo/hypervault
[PostgreSQL as a benchmarking tool]: https://www.pgcon.org/2014/schedule/attachments/309_PG_as_bench_mark.pdf
[2014_ PGcon_paper]: http://www.pgcon.org/2014/schedule/index.en.html
[PSequel]: http://www.psequel.com/
[PostgreSQL_s Powerful New Join Type_LATERAL]: http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/
[PostgreSQL Hardware Performance Tuning]: http://momjian.us/main/writings/pgsql/hw_performance/
[PostgreSQL_ Introduction and Concepts Bruce Momjian]: http://momjian.us/main/writings/pgsql/aw_pgsql_book/
[Link 2]: http://momjian.us/main/writings/pgsql/
[Writing PostgreSQL Applications]: http://momjian.us/main/writings/pgsql/writing_apps.pdf
[Compiling PLV8 with Postgres Plus Advanced Server]: http://blogs.enterprisedb.com/2014/12/03/compiling-plv8-with-postgres-plus-advanced-server-2/
[PLV8]: https://code.google.com/p/plv8js/wiki/PLV8
[fosdem 2014_PostgreSQL]: https://archive.fosdem.org/2014/schedule/track/postgresql/
[fosdem]: http://en.wikipedia.org/wiki/FOSDEM
[Link 3]: https://archive.fosdem.org/
[Link 4]: https://fosdem.org/2015/
[PostgreSQL Now Has Logical Decoding]: http://rhaas.blogspot.jp/2014/03/postgresql-now-has-logical-decoding.html
[Link 5]: http://rhaas.blogspot.jp/
[2014_pgconf paper]: http://www.pgconf.us/2014/schedule/
[mysql2postgres]: https://github.com/maxlapshin/mysql2postgres
[What are the advantages and disadvantages of using PostgreSQL over MySQL]: https://www.quora.com/What-are-the-advantages-and-disadvantages-of-using-PostgreSQL-over-MySQL
[Postgres _Manatee]: http://www.oschina.net/p/manatee
[https_github.com_joyent_manatee]: https://github.com/joyent/manatee
[https_github.com_drotiro_postpic]: https://github.com/drotiro/postpic
[Super-smack _MySQL_PostgreSQL]: http://vegan.net/tony/supersmack/super-smack-1.3.tar.gz
[https_sourceforge.net_projects_benchmarksql]: https://sourceforge.net/projects/benchmarksql/
[http_dalibo.github.io_powa]: http://dalibo.github.io/powa/
[https_github.com_ty4z2008_Qix_blob_master_pg.md]: https://github.com/ty4z2008/Qix/blob/master/pg.md
[http_www.open-open.com_lib_view_open1450226386125.html]: http://www.open-open.com/lib/view/open1450226386125.html