Contact
Offices

PostgreSQL

Michael Banck
Version 1.0 of pg_checksums has been released. pg_checksums verifies, activates or deactivates data checksums in PostgreSQL instances. It is based on the pg_checksums utility in PostgreSQL 12, with the following additions: 1. Online verification of checksums The pg_checksums utility in PostgreSQL...
Christoph Berg
Yesterday, the fourth beta of the upcoming PostgreSQL major version 12 was released. Compared to its predecessor PostgreSQL 11, there are many new features: Performance improvements for indexes: btree indexes now manage space more efficiently. The REINDEX command now also supports CONCURRENTLY,...
Alexander Sosna
Today it is no longer necessary to argue why central logging makes sense or is even necessary. Most medium-sized companies now have a central logging system or are just introducing it. Once the infrastructure has been created, it must be used sensibly and efficiently! Especially as an...
Carsten Meskes
Lately, with the rise of extensive container orchestration and microservices, Kubernetes has been getting more and more exposure and has become the de facto standard for orchestration in these environments. In this context, orchestration of PostgreSQL clusters with the help of Kubernetes has been a...
Michael Banck
Patroni is a PostgreSQL high availability solution with a focus on containers and Kubernetes. Until recently, the available Debian packages had to be configured manually and did not integrate well with the rest of the distribution. For the upcoming Debian 10 "Buster" release, the Patroni packages...
Alexander Sosna
Many users are required to run virus scanners on all of their IT systems due to vendor requirements or working instructions. This general requirement can lead to problems for IT systems that are neither desktops nor simple file servers. Usual interpretations of baseline security requirements demand...
Christoph Berg
This week version 1.3 of our PostgreSQL appliance Elephant Shed was released. The highlight of the new version is support for Red Hat Enterprise Linux 7 and CentOS 7. As is already the case for Debian, the appliance heavily relies on the postgresql-common infrastructure which was previously ported...
Christoph Berg
Today PostgreSQL version 11 was released. The new release brings improvements in many areas. Since version 9.6 query plans can be executed on multiple CPU cores in parallel, this is now supported for other plan types, especially the creation of B-tree indexes. Sequential scans and UNION queries...
Carsten Meskes
From mid to late June credativ attended 3 consecutive conferences in Asia. The Open Source Summit Japan , the LC3 China and the PG Open China . Open Source Summit Japan As in the previous year, the Open Source Summit Japan was held again at the Ariake Conference Center on Odaiba, in the Bay of...
Michael Banck
The second beta release of PostgreSQL 11 (which is now feature frozen) has been released recently. Time to look at some of the improvements that credativ has contributed in the area of checksums and backups. Checksum verification during base backups Since version 9.3 it is possible to enable...