---
title: "#252: Backup Tools for Postgres "
publication: "Postgres Weekly"
issue: 252
published_at: "2018-04-18"
canonical_url: "https://postgresweekly.com/issues/252"
---

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

#252 — April 18, 2018 

[Read on the Web](https://postgresweekly.com/issues/252)   

Postgres Weekly  

[Postgres's High-Volume Processing Developments](https://blog.anayrat.info/en/2018/04/16/postgresqls-developments-for-high-volumes-processing/) — 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](https://severalnines.com/blog/top-backup-tools-postgresql) — A look at some backup methods you can use including Barman, BART and pgBackRest. 

Viorel Tabara   [![\](https://copm.s3.amazonaws.com/be43ac5b.png)](https://www.2ndquadrant.com/en/resources/bdr/?utm_source=cp&utm_medium=pgweekly&utm_campaign=bdrcppgweekly) 

[AlwaysOn Multi-Master Replication for Distributed PostgreSQL](https://www.2ndquadrant.com/en/resources/bdr/?utm_source=cp&utm_medium=pgweekly&utm_campaign=bdrcppgweekly) — 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](http://paquier.xyz/postgresql-2/postgres-11-covering-indexes/) — 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](https://severalnines.com/blog/ten-tips-going-production-postgresql) — 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](https://www.pgadmin.org/) — The popular open source management and admin tool gains a variety of usability improvements. 

PostgreSQL   

[Postgres 11 Partition Pruning Performance](https://blog.2ndquadrant.com/partition-elimination-postgresql-11/) — 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)](http://www.pgconf.uk/) — The UK’s dedicated Postgres annual user conference returns soon. 

2ndQuadrant   

[PostgreSQL Data Types: Date and Time Processing](https://tapoueh.org/blog/2018/04/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](https://severalnines.com/blog/guide-pgpool-postgresql-part-one) — Pgpool is a useful tool for connection pooling and load balancing. 

Vladimir Svedov   

[Index Maintenance: Get Rid of Your Unused Indexes](https://www.cybertec-postgresql.com/en/get-rid-of-your-unused-indexes/) — Why unused indexes are a hinderance, and how to find them. 

Laurenz Albe   

[PostgreSQL Data Types: Network Addresses](https://tapoueh.org/blog/2018/04/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](http://postgresvision.com/) 

Postgres Vision 2018 sponsor   

[Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 Released](https://www.postgresql.org/about/news/1847/) — Bug fixes.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom