credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
Category: PostgreSQL®
05 May 2022
Moodle PostgreSQL load balancing with HAProxy and Patroni
Moodle is a popular Open Source online learning platform. Especially since the beginning of the COVID-19 pandemic the importance of Moodle for schools and universities has further increased. In some states in Germany all schools had to switch to Moodle and other platforms like BigBlueButton in the course of a few days. This leads to […]
08 March 2022
SQLreduce: Reduce verbose SQL queries to minimal examples
SQLreduce: Reduce verbose SQL queries to minimal examples Developers often face very large SQL queries that raise some errors. SQLreduce is a tool to reduce that complexity to a minimal query. SQLsmith generates random SQL queries SQLsmith is a tool that generates random SQL queries and runs them against a PostgreSQL server (and other DBMS […]
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 […]
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 […]