#245 — February 28, 2018 |
Postgres Weekly |
Why Upgrade PostgreSQL? Here's Why — A helpful tool to shed light on the real benefits of upgrading from any given version of Postgres. For example: Upgrading from 9.3.2 to 10.2? This site will tell you all the benefits. Hubert depesz Lubaczewski |
When Postgres Blocks: 7 Tips for Dealing with Locks — Highlights common mistakes developers face dealing with Postgres locks and what you can do about them. Marco Slot |
PostgresConf US 2018: People, Postgres, Data — PostgresConf focuses 100% on People, Postgres, and Data through growth of the community and open source industry. All proceeds go back into the community through support of local events, meetups, webinars, and training. Join us April 16 - 20. PostgresConf.org sponsor |
PostgreSQL Replication Slots — How to make WAL archiving and streaming replication more efficient with a feature added in Postgres 9.4. OpsDash |
Upgrading to Postgres Version 10: What You Should Know — A short summary of how you can perform an upgrade to version 10, including what method to choose, how to prepare and what to check for after the upgrade is complete. Vladimir Svedov |
▶ The State of Postgres Replication in 2018 — A long-standing knock against Postgres has been it doesn’t have replication. The reality is a bit different, this talk from FOSDEM walks through the state of it as of 2018. (Note: Poor audio.) Magnus Hagander video |
PostgreSQL 10 Now Supported on Amazon RDS Amazon Web Services |
Three Approaches to PostgreSQL Replication and Backup Ozgun Erdogan |
Postgres Backups with Continuous Archiving — A look at how Postgres backups done via an approach called ‘continuous archiving’ work, including how to set it up and how to restore. Michael Malis |
Think Your Postgres Backups and Disaster Recovery Are Safe? Percona sponsor |
PostgreSQL Backup and Recovery Orchestration — Postgres has two types of backups logical and physical. This quick guide gives you a tour of the mechanism of physical backups in PostgreSQL. Michal Zimmermann |
Kube-Native Postgres — A talk about efforts to make Postgres (in Patroni form) work more naturally in a Kubernetes environment. Josh Berkus, RedHat |
|