credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
Category: PostgreSQL®
06 January 2022
PostgreSQL and Undelete
pg_dirtyread I recently updated pg_dirtyread to work with PostgreSQL 14. pg_dirtyread is a PostgreSQL extension that allows reading “dead” rows from tables, i.e., rows that have already been deleted or updated. Of course, this only works if the table has not yet been cleaned by a VACUUM command or autovacuum, PostgreSQL’s garbage collection. Here is […]
17 November 2021
Debian 11 "Bullseye" Released
Congratulations to the Debian Community The Debian Project just released version 11 (aka “bullseye”) of their free operating system. In total, over 6,208 contributors worked on this release and were indispensable in making this launch happen. We would like to thank everyone involved for their combined efforts, hard work, and many hours pent in recent […]
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 PostgreSQL® database. As our article for Beta 4 has already indicated, a number of new features, improvements and optimizations have been incorporated into the release. These include among others: Optimized disk space utilization and speed for btree indexes btree-Indexes, the default […]