Web Design: #223: Postgres Backups, Logical vs. Physical

Wednesday, September 6, 2017

#223: Postgres Backups, Logical vs. Physical

Issue 223 — September 6, 2017

Within Postgres there are two forms of backups and understanding them is a useful foundation for anyone working with Postgres.

Craig Kerstiens

Databases and Distributed Deadlocks: An FAQ

A look at what happens if a transaction needs to update data spread across multiple machines, which can be a concern with Citus’s extensions to Postgres.

Marco Slot

Building An Interactive Game of Thrones Map

A fun guide to building a Node.js API to serve a geospatial ‘Game of Thrones’ map, leaning heavily on Postgres (with PostGIS) and Redis.

Patrick Triest

Work Smarter with SelectStar

See how SelectStar can expertly monitor replication in your Postgres database. Start your free trial today.

SelectStar #sponsored

PostgreSQL 10 Beta 4 Released

PostgreSQL 10 Beta 4 is here, the likely last beta before we have an RC. If you’re interested to explore the parallelism improvements, logical replication advancements, or more go ahead and kick the tires on it.

PostgreSQL.org #news

PostgreSQL 9.6.5, 9.5.9, 9.4.14, 9.3.19 and 9.2.23 Released

This release includes fixes that prevent a crash in pg_restore when using parallel mode.

PostgreSQL.org #news

Stop Calling PostgREST 'Magic': How It Works

A contributor to the PostgREST project (which turns your Postgres DB into a RESTful API) explains how it works, removing any illusion of magic.

Ruslan Talpă

How to Integrate Spring Data JPA, PostgreSQL, and Liquibase

..to manage the persistence layer of a Spring Boot application.

Bruno Krebs

Superfast CSV Imports using Postgres's COPY Command

A Rails-oriented look at the options for importing large CSV files, how slow it is via an ORM, and how the COPY command can help.