planet.postgresql.org planet.postgresql.org

Ryan Lambert: PostGIS Trajectory: Space plus Time

A few months ago I started experimenting with a few project ideas involving data over space and time. Naturally, I want to use Postgres and PostGIS as the main workhorse for these projects, the challenge was working out exactly how to pull it all together. After a couple false starts I had to put those projects aside for other priorities. In my free time I have continued working through some related reading on the topic. I found why...

planet.postgresql.org planet.postgresql.org

Michał Mackiewicz: Setting up PostgreSQL for Debezium

Debezium is a popular Open Source change data capture (CDC) solution. It’s based on a set of well-established components (Kafka, Kafka Connect, ZooKeeper) and used successfully in production by companies like Dehlivery or BlaBlaCar. However, the setup is not as straightforward as one may think, and you may encounter some obstacles. In this post, I will share some tips originating from hooking up Debezium to a quite big and busy OLTP...

planet.postgresql.org planet.postgresql.org

Stefan Fercot: Combining pgBackRest dedicated repository host and Streaming Replication

pgBackRest is a well-known powerful backup and restore tool. It offers a lot of possibilities. In this post, we’ll see how to setup a dedicated repository host to backup a PostgreSQL 3-nodes cluster. The repository host will be called backup-srv and the 3 PostgreSQL nodes in Streaming Replication: pg1-srv, pg2-srv, pg3-srv. All the nodes will be running on CentOS 7. If you’re familiar with Vagrant, here’s a simple Vagrantfile...

planet.postgresql.org planet.postgresql.org

Stefan Fercot: Combining pgBackRest dedicated repository host and Streaming Replication

pgBackRest is a well-known powerful backup and restore tool. It offers a lot of possibilities. In this post, we’ll see how to setup a dedicated repository host to backup a PostgreSQL 3-nodes cluster. The repository host will be called backup-srv and the 3 PostgreSQL nodes in Streaming Replication: pg1-srv, pg2-srv, pg3-srv. All the nodes will be running on CentOS 7. If you’re familiar with Vagrant, here’s a simple Vagrantfile...

planet.postgresql.org planet.postgresql.org

Egor Rogov: MVCC in PostgreSQL — 3. Row Versions

Well, we've already discussed isolation and made a digression regarding the low-level data structure. And we've finally reached the most fascinating thing, that is, row versions (tuples). Tuple header As already mentioned, several versions of each row can be simultaneously available in the database. And we need to somehow distinguish one version from another one. To this end, each version is labeled with its effective "time"...

planet.postgresql.org planet.postgresql.org

Joshua Drake: IS OF

I am on the phone with Eric Ridge of ZomboDB and PGX fame. We chat often on the People, Postgres, Data Discord server (yes you should join) and we have unofficial “we are human so we get on the phone” calls about twice a month. The calls are generally about PostgreSQL and the awesome Open Source projects he is building around our famed database. However, on this call I got a question I don’t normally get: how good is your SQL?Now...

planet.postgresql.org planet.postgresql.org

Dave Page: macOS Big Sur upgrade breaking PostgreSQL installations

Some of the readers of my blog may be aware that I'm responsible for the PostgreSQL Installers produced by EDB for the PostgreSQL Community. This includes both the Windows and macOS installers, and the now-deprecated Linux installers (use RPMs/DEBs instead)!Over the weekend I upgraded my laptop to the new Big Sur release from Apple, a.k.a. macOS 11.0. Everything went just fine until I tried to connect to my PostgreSQL 13 development...