---
title: "#223: Postgres Backups, Logical vs. Physical"
publication: "Postgres Weekly"
issue: 223
published_at: "2017-09-06"
canonical_url: "https://postgresweekly.com/issues/223"
---

Postgres Weekly 223   . 

[Read this on the Web](http://postgresweekly.com/issues/223) 

[Postgres Weekly](http://postgresweekly.com) Issue 223 — September 6, 2017     

[Postgres Backups: Logical vs. Physical](http://www.craigkerstiens.com/2017/09/03/postgres-backups-physical-vs-logical/?utm_source=postgresweekly&utm_medium=email)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](https://www.citusdata.com/blog/2017/08/31/databases-and-distributed-deadlocks-a-faq/?utm_source=postgresweekly&utm_medium=email)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](https://blog.patricktriest.com/game-of-thrones-map-node-postgres-redis/?utm_source=postgresweekly&utm_medium=email)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](https://selectstar.io/blog/3-strategies-improve-postgresql-performance-replication/)See how SelectStar can expertly monitor replication in your Postgres database. Start your free trial today. SelectStar#sponsored[![\](https://copm.s3.amazonaws.com/543651dd.png)](https://selectstar.io/blog/3-strategies-improve-postgresql-performance-replication/) [PostgreSQL 10 Beta 4 Released](https://www.postgresql.org/about/news/1776/?utm_source=postgresweekly&utm_medium=email)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](https://www.postgresql.org/about/news/1777/?utm_source=postgresweekly&utm_medium=email)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](https://medium.freecodecamp.org/stop-calling-postgrest-magic-8f3e1d5e5dd1?utm_source=postgresweekly&utm_medium=email)A contributor to the [PostgREST project](https://github.com/begriffs/postgrest) (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](https://auth0.com/blog/integrating-spring-data-jpa-postgresql-liquibase/?utm_source=postgresweekly&utm_medium=email)..to manage the persistence layer of a Spring Boot application. Bruno Krebs [Superfast CSV Imports using Postgres's COPY Command](https://infinum.co/the-capsized-eight/superfast-csv-imports-using-postgresqls-copy?utm_source=postgresweekly&utm_medium=email)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. Petar Ćurković [An Interview with 2ndQuadrant's Simon Riggs: What's New and What's Coming in Postgres](https://2017.postgresopen.org/blog-2ndq/?utm_source=postgresweekly&utm_medium=email) PostgresOpen Silicon Valley [Linux cloud hosting starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. Linode Cloud Hosting#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/223) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK