Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 53 Minuten

Hubert 'depesz' Lubaczewski: How to limit rows to at most N per category – fix

8. Januar 2021 - 5:17
A bit ago I wrote a blog post that was supposed to show how to keep number of rows in table to N per some category. Unfortunately, I overlooked a problem related to concurrency. As Mikhail wrote, we will get problems if we'd do operations from multiple connections, at once-ish. Let's see it: CREATE TABLE … Continue reading "How to limit rows to at most N per category – fix"

Doug Hunley: Announcing the Crunchy Data PostgreSQL Security Technical Implementation Guide

7. Januar 2021 - 13:25

Crunchy Data is pleased to announce the publication of the  Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) by the United States Defense Information Systems Agency (DISA).

Devrim GÜNDÜZ: Announcing PostgreSQL RPM repository for RHEL 8 - ppc64le

7. Januar 2021 - 11:43
I added RHEL 8 - ppc64le support to PostgreSQL YUM repo for all the supported PostgreSQL versions as of today.

To use the repo and install PostgreSQL on this platform, please follow these steps: Continue reading "Announcing PostgreSQL RPM repository for RHEL 8 - ppc64le"

Hubert 'depesz' Lubaczewski: Fixes on

7. Januar 2021 - 8:54
In case you're not familiar with this site, shows you aggregated changelog between any two releases, with optionally searching for some keywords. Yesterday azeem on irc pointed me towards a problem on Specifically, when displaying changes from 9.5.24 to 13.1 site showed 30 security fixes. But in reality there should be only 10. … Continue reading "Fixes on"

Steven Pousty: Using R in Postgres for Logistic Regression Modeling

6. Januar 2021 - 15:28

Greetings friends! We have finally come to the point in the Postgres for Data Science series where we are not doing data preparation. Today we are going to do modeling and prediction of fire occurrence given weather parameters… IN OUR DATABASE!

Ibrar Ahmed: PostgreSQL Database Security: What You Need To Know

4. Januar 2021 - 17:23

When we are talking about database security, it encompasses different modules of different areas. It is a very vast topic because, with databases, we need need to secure the whole ecosystem, not just the database node. The figure below shows the major breakdown of the “parts” which need to be secure. It is clearly evident that the database itself is just the 1/6th part of that. You need to secure your (1) Network (2) Network Node (3) Data (4) Database (5) Users and (6) Application. A secure database means it is secure by all means.


Andreas 'ads' Scherbaum: Amit Langote

4. Januar 2021 - 15:00
PostgreSQL Person of the Week Interview with Amit Langote: Originally from India, I now live in Tokyo, Japan and have for the last few years. I am married and have a toddler daughter. I joined EDB earlier this year and before that I worked at NTT OSS Center since arriving in Tokyo. I have mostly worked on PostgreSQL in my professional life and most of it with the folks of the open source community developing it.

Ryan Lambert: Improved OpenStreetMap data structure in PostGIS

3. Januar 2021 - 4:30

It was nearly a decade ago when I first loaded OpenStreetMap data to PostGIS. Over the years my fingers have typed osm2pgsql --slim --drop ... countless times and I do not see an end to that trend anytime soon. One thing that is changing is that getting high quality OpenStreetMap data into PostGIS is easier than ever!

Luca Ferrari: Single User Mode and -P flag

3. Januar 2021 - 1:00

How to allow corrupted catalogs repair.

Kat Batuigas: Loading Data into PostGIS: An Overview

31. Dezember 2020 - 20:16

There are a lot of ways to load data into a PostgreSQL/PostGIS database and it's no different with spatial data. If you're new to PostGIS, you've come to the right place. In this blog post, I'll outline a few free, open source tools you can use for your spatial data import needs. 

Greg Smith: PostgreSQL 13 Benchmark: Memory Speed vs. TPS

30. Dezember 2020 - 16:13

Some guys are obsessed with sports or cars. I follow computer hardware. The PC industry has overclocking instead of nitrous, plexi cases instead of chrome, and RGB lighting as its spinning wheels.

Laurenz Albe: The shibboleth of PostgreSQL

30. Dezember 2020 - 11:00

© Laurenz Albe 2020

After all the technical articles I have written, I thought it would be nice to write about PostgreSQL sociology for a change.

Language and community

A community like PostgreSQL has no clearly defined borders. There is no membership certificate; you belong to it if you feel that you belong. That said, you can only get that feeling if you feel accepted.

Bo Peng: Query Load Balancing in Pgpool-II

30. Dezember 2020 - 6:25
Pgpool-II is a PostgreSQL cluster management tool. The major features of Pgpool-II are:

Asif Rehman: Checkpoints In PostgreSQL

29. Dezember 2020 - 18:52

PostgreSQL database writes all changes happening in the database to a log file before it writes them to the actual data files. These log files are called WAL (Write-Ahead Log). Until these changes are flushed to the disk, they are kept in memory and is returned from the memory when it’s asked for. Writing to the data files directly is a costly operation for several reasons and is performed periodically.

Hubert 'depesz' Lubaczewski: How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2

29. Dezember 2020 - 14:30
In previous post I showed how I'd install PostgreSQL for developer. But that's not all. Now we need to add some configuration. What, how, where? First let's talk about where can we put configuration. Initially the place for PostgreSQL config is postgresql.conf, which is in /etc/postgresql/13/main/postgresql.conf.

Robins Tharakan: What Postgres SQL causes a Table Rewrite?

29. Dezember 2020 - 8:54

While developing SQL based applications, it is commonplace to stumble on these 2 questions:

  1. What DDLs would block concurrent workload?
  2. Whether a DDL is going to rewrite the table (and in some cases may need ~ 2x disk space)?

Although completely answering Question 1 is beyond the scope of this post, one of the important pieces that helps answering both of these questions is whether a DDL is going to cause a relfilenode change..

Devrim GÜNDÜZ: RPM repository for unsupported PostgreSQL releases / distros

28. Dezember 2020 - 14:10
PostgreSQL RPM repository has been out for quite a long time, and we've been building packages since PostgreSQL 7.3. If you are using an unsupported PostgreSQL version or Red Hat / CentOS / Scientific Linux / Oracle Linux release for some reason and need RPMs of those releases, we have archives of them.
Continue reading "RPM repository for unsupported PostgreSQL releases / distros"

Raghavendra Rao: AFTER LOGON(Oracle) trigger in PostgreSQL with extension – login_hook

25. Dezember 2020 - 20:00
Before going into the details, thanks to the author of ‘login hook’ extension for developing and maintaining it. Many times, in Oracle to Postgres migration exercise, I have seen the use of Oracle Database Event trigger – AFTER LOGON ON. Its one type of Oracle database/user event trigger(LOGON) that fires when a user connects to...

Devrim GÜNDÜZ: LLVM issues with PostgreSQL YUM repository on CentOS 8

25. Dezember 2020 - 12:00
In the latest 3 minor releases of Red Hat Enterprise Linux 8, Red Hat have broken LLVM compatibility with the previous minor releases (like introducing LLVM 8 with RHEL 8.1, LLVM 9 with RHEL 8.2, and LLVM 10 with RHEL 8.3). Continue reading "LLVM issues with PostgreSQL YUM repository on CentOS 8"