credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
Category: PostgreSQL®
04 May 2020
Apt.Postgresql.Org with Support for Arm64 and Ubuntu Focal
The apt.postgresql.org repository originally started with the two architectures amd64 and i386 (64- and 32-bit x64). In September 2016, ppc64el (POWER) was added. Over time, there have been repeated requests as to whether we might also support “arm”, which usually meant Raspberry Pi. However, these are mostly only 32-bit, and the widespread “armhf” Raspbian port […]
16 April 2020
Recover Data from Corrupt Tables in PostgreSQL®
PostgreSQL® is an extremely robust database, to which most of our clients also entrust their data. However, if errors do occur, they are usually due to the storage system, where individual bits or bytes flip, or entire blocks become corrupted. We demonstrate how to recover data from corrupt tables. In case of an error, the […]
14 January 2020
Debian integration of Patroni and vip-manager
Patroni is a clustering solution for PostgreSQL® that is getting more and more popular in the cloud and Kubernetes sector due to its operator pattern and integration with Etcd or Consul. Some time ago we wrote a blog post about the integration of Patroni into Debian. Recently, the vip-manager project which is closely related to […]
07 October 2019
PostgreSQL® 12 released
The PostgreSQL® Global Development Group (PGDG) has released version 12 of the popular, free database PostgreSQL®. As our Beta 4 article already suggested, a multitude of new features, improvements, and optimizations have been incorporated into the release. These include: Optimized storage utilization and speed for btree indexes btree indexes, the standard index type in PostgreSQL®, […]
12 September 2019
PostgreSQL® 12 Beta 4 released
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, which was previously only possible with new indexes. WITH queries are now embedded in […]