--- title: "An intro to making Postgres high availability on Kubernetes" publication: "Postgres Weekly" issue: 351 published_at: "2020-04-15" canonical_url: "https://postgresweekly.com/issues/351" --- This week's Postgres news, views, and tools. #351 — April 15, 2020 [Read on the Web](https://postgresweekly.com/issues/351) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1586948216/dbwzd1noi0n9a81gprvg.jpg)](https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/) [A Detailed Look at `pg_show_plans`](https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/) — A few issues ago we linked to [a basic introduction to pg_show_plans](https://www.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/) – this goes a little further. pg_show_plans lets you look at the execution plans of slow queries in real time as they’re being executed which can help you when troubleshooting. Kaarel Moppel [Intersecting GPS Tracks to Identify Infected Individuals](https://www.cybertec-postgresql.com/en/intersecting-gps-tracks-to-identify-infected-individuals/) — I’m not a huge fan of COVID-19 related content, but this is a pretty interesting technique with numerous use cases. Essentially it uses PostGIS to identify overlapping paths. Florian Nadler [![\](https://copm.s3.amazonaws.com/3dd3859c.png)](https://www.2ndquadrant.com/en/online-training-postgresql-dba) [Online Training: Learn PostgreSQL from Home](https://www.2ndquadrant.com/en/online-training-postgresql-dba) — The remote PostgreSQL Database Administration training course is available at a discounted rate & will be conducted in two different timezones. The course covers day-to-day DBA operations, monitoring, server configurations, and more. 2ndQuadrant PostgreSQL Training sponsor [PostgreSQL's 'Related Projects'](https://www.postgresql.org/developer/related-projects/) — Thanks to Andreas Scherbaum for [pointing out](https://andreas.scherbaum.la/blog/archives/1023-Related-Projects.html) a new page on the Postgres site dedicated to projects _related_ to Postgres like the code that runs the Postgres web site, mailing list, build farm, package management system, etc. PostgreSQL Global Development Group [Authentication Configuration in Postgres (and CockroachDB)](https://dr-knz.net/authentication-in-postgresql-and-cockroachdb.html) — In Postgres, client authentication can be controlled via a ‘HBA’ (host-based authentication) file. It’s not something we see covered very often, so you might find this interesting, particularly as it compares things against CockroachDB. Raphael ‘kena’ Poss ▶[Easy And Correct High Availability Postgres with Kubernetes](https://www.youtube.com/watch?v=p0WVyHDWsgA) — A 50 minute talk from PostgresOpen 2019 that goes all the way ‘from containers up’ until actually doing stuff with Postgres. Steven Pousty [How To Set Up an Express API Backend Project With Postgres](https://www.smashingmagazine.com/2020/04/express-api-backend-project-postgresql/) — A pretty extensive walkthrough of creating an HTTP API using Express with Node.js and Postgres on the backend, then deploying it all on Heroku. Chidi Orji [A Beginners Guide to Basic Indexing in Postgres](https://bannister.me/blog/a-beginners-guide-to-basic-indexing/) James Bannister [eBook: The Most Important Events to Monitor in Your Postgres Logs](https://pganalyze.com/ebooks/monitoring-postgres-logs?utm_source=PostgresWeeklySecondary04152020) — In this eBook, we are looking at the Top 6 Postgres log events for monitoring query performance and preventing downtime. pganalyze sponsor [Documenting the Citus Extension to Postgres: An Interview with Joe Nelson](https://www.citusdata.com/blog/2020/04/09/documenting-citus-extension-begriffs-interview/) — Joe, a.k.a. `begriffs`, talks about why he works on documentation, why the multi-tenant and real-time analytics tutorials matter, the `INSERT..SELECT` with repartitioning feature, and what development platform Citus uses for docs. Citus Data (Microsoft) [Procedural vs Query Approaches for Finding Packages](https://news.freshports.org/2020/04/14/procedural-vs-query-approaches/) — Explorations of a query that can be used to display which packages are available for a given FreeBSD port. Get your head around the [data model](https://news.freshports.org/2020/04/14/packages-how-is-this-data-stored/) and the ideas here apply to all sorts of situations. Dan Langille 🗓**Upcoming Events** All in-person events we had listed are cancelled or postponed due to the COVID outbreak, so we're now linking to webinars, livestreams, and similar online events. If you have any, just hit reply and if it's Postgres related (and either free or not too expensive) we'll include it in a future issue. Just one this week: - 🔐 [Date/Timestamp types in PostgreSQL](https://resources.2ndquadrant.com/webinar-date/timestamp-types-in-postgresql) with Andrew Dunstan and 2ndQuardrant on April 22 at 4pm UTC. 🔐 – requires e-mail address or registration 💵 – costs money to participate 🐦**Seen on Twitter** Saw this tweet and thought it was a pretty neat reminder of the sorts of things we can do with Postgres. Justin kindly let us include it: [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1586877899/dh7xfkhjqbdhmwghawno.png)](https://twitter.com/searls/status/1248639132756332546) Click through to [the original tweet](https://twitter.com/searls/status/1248639132756332546) if you want to see the code better. Neat use for a generated column! Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), 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