#252: Backup Tools for Postgres

The latest Postgres news, articles, tools, and projects.

#252 — April 18, 2018 Read on the Web Postgres Weekly Postgres's High-Volume Processing Developments — A great run down of the major performance improvements in recent Postgres releases (9.5 through 10, plus speculation about Postgres 11) and what each means. Adrien Nayrat Top Backup Tools for Postgres — A look at some backup methods you can use including Barman, BART and pgBackRest. Viorel Tabara AlwaysOn Multi-Master Replication for Distributed PostgreSQL — Postgres-BDR from 2ndQuadrant presents true high availability with point-in-time recovery. BDR provides rolling upgrades, with zero downtime, for geographically distributed PostgreSQL databases. 2ndQuadrant PostgreSQL Products sponsor 'Covering Indexes' Coming to Postgres 11 — You'll be able to include extra, non-key columns into indexes as a way to allow more queries to benefit from index-only scans. Michael Paquier Ten Tips for Going into Production with Postgres — A variety of tips and tricks (be aware that a few lean heavily on Severalnine's ClusterControl tool) for going into production including testing with pgbench, moving your WAL to a new disk, and using HAProxy for load balancing. Achilleas Mantzios pgAdmin 4 v3.0 Released — The popular open source management and admin tool gains a variety of usability improvements. PostgreSQL Postgres 11 Partition Pruning Performance — Two new patches have landed to improve the performance and usability of the declarative table partitioning feature introduced in Postgres 10. David Rowley PGConf UK 2018 (London, July 3) — The UK's dedicated Postgres annual user conference returns soon. 2ndQuadrant PostgreSQL Data Types: Date and Time Processing — A dive into a set of examples to help you get started with time based processing in Postgres. Dimitri Fontaine A Guide to Pgpool for Postgres: Part One — Pgpool is a useful tool for connection pooling and load balancing. Vladimir Svedov Index Maintenance: Get Rid of Your Unused Indexes — Why unused indexes are a hinderance, and how to find them. Laurenz Albe PostgreSQL Data Types: Network Addresses — Postgres includes support for cidr, inet, and macaddr data types. Here's how to use them. Dimitri Fontaine Training Day Announced: DBA Skill Builder at Postgres Vision Postgres Vision 2018 sponsor Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 Released — Bug fixes.

Curated by Cooperpress and Craig Kerstiens Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom