Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 56 Minuten

Haroon .: RESTful CRUD API using PostgreSQL and Spring Boot – Part one

8. Juni 2020 - 16:58
Overview Spring Boot is a framework that is used to build stand-alone Java applications following the Spring framework but with less hassle and minimal configuration. Learning by practical examples is always great; therefore, this article will walk you through the creation of a RESTful CRUD (create-read-update-delete) application using Spring Boot and its connectivity with PostgreSQL. […]

Craig Ringer: Failover slots for PostgreSQL

8. Juni 2020 - 16:44
Logical decoding and logical replication is getting more attention in the PostgreSQL world. This means we need it working well alongside production HA systems – and it turns out there’s a problem there. Replication slots are not themselves synced to physical replicas so you can’t continue to use a slot after a master failure results […]

Bruce Momjian: Safety Systems Can Decrease Safety

8. Juni 2020 - 16:15

What is the purpose of safety systems? To make things safer? To make them appear safer? To satisfy some external requirement? The purpose of safety systems is not always clear, but even for safety systems whose sole purpose is to increase safety — do they always succeed in increasing safety? The simple answer is "no". Here are three examples:

Andreas 'ads' Scherbaum: Oleksii Kliukin

8. Juni 2020 - 16:00
PostgreSQL Person of the Week Interview with Oleksii Kliukin: Hi, my name is Oleksii (people also call me Alex). I work as a Database Engineer at, improving their PostgreSQL infrastructure. Before that, I worked on Patroni and the Postgres Operator at Zalando. I’m originally from Simferopol, Ukraine. I moved to Germany around 7 years ago. I live in Berlin with my wife and two sons, three years old and 7 months old. When I have time, I enjoy spending it outdoors, hiking, cycling, or running.

Kirk Roybal: Oracle to PostgreSQL: START WITH/CONNECT BY

8. Juni 2020 - 15:53
And now we arrive at the second article in our migration from Oracle to PostgreSQL series. This time we’ll be taking a look at the START WITH/CONNECT BY construct. In Oracle, START WITH/CONNECT BY is used to create a singly linked list structure starting at a given sentinel row. The linked list may take the form of a tree, and has no balancing […]

Hubert 'depesz' Lubaczewski: Changes on

8. Juni 2020 - 13:01
Just pushed some new changes to and it's underlying parsing library. The changes are: If you upload plan in JSON/YAML/XML format, and then you'll look at “TEXT" tab, you will see explain in text format, generated using data from JSON. This explain had slight error in number formatting (3 decimal digits for estimated costs, … Continue reading "Changes on"

Luca Ferrari: Locating the PostgreSQL configuration file

8. Juni 2020 - 2:00

How to find the PostgreSQL configuration file on an unknown system?

Locating the PostgreSQL configuration file

Sometimes you get to manage a PostgreSQL instance on an unknown system, and this means you don’t know how to locate the PostgreSQL configuration file.
An example could be when you are running PostgreSQL on a Docker container:

Ibrar Ahmed: 10 Common PostgreSQL Errors

5. Juni 2020 - 16:27

Sometimes PostgreSQL users get errors and warnings and they are unable to understand why. To cater to these situations, this blog will cover some common errors and warnings in PostgreSQL. In some cases, it is a user setting problem or query error, but in other cases, it can be a PostgreSQL bug. But, it is quite rare to be a PostgreSQL bug, and therefore it is really important to differentiate between user error and PostgreSQL bug. Here is a list of some common PostgreSQL errors, with symptoms and solutions.

Paul Ramsey: Spatial Constraints with PostGIS in PostgreSQL- Part 3

5. Juni 2020 - 14:11

In our last installment, we covered the use of a constraint trigger to enforce data quality by looking at geometry spatial relationships.

Laurenz Albe: Deduplication in PostgreSQL v13 B-tree indexes

4. Juni 2020 - 9:30

© Laurenz Albe 2020

A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, will feature index entry deduplication as an even more impressive improvement. So I thought it was time for a follow-up.

Bruce Momjian: When Does a Commit Happen?

3. Juni 2020 - 23:00

Most people who deal with relational databases think of transaction commits as binary operations — the query is running and not yet committed, then it is completed and committed. However, internally, there are many stages to a commit:

Paul Ramsey: Spatial Constraints with PostGIS in PostgreSQL- Part 2

3. Juni 2020 - 17:43

If constraints in general have caught your interest, our interactive learning portal has a whole section on the use of non-spatial constraints, even a video walkthrough!