credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
Category: PostgreSQL®
04 January 2018
The Processor as a Security Vulnerability
At the beginning of 2018, issues with memory management and Intel processors became public. According to these reports, it is apparently possible to read arbitrary areas of the kernel and userspace memory regions and thus potentially gain access to sensitive areas. Over the past few days, there have been rumors and speculations about the direction […]
12 May 2017
PostgreSQL® Auditing Extension on Debian/Ubuntu
The pgAudit extension allows for fine-grained auditing of access to a PostgreSQL® database. Among other things, it is an important component of the recently published PostgreSQL® STIG (“Security Technical Implementation Guide”) by the US Department of Defense. Debian packages created by us as part of the pkg-postgresql project are now available in the official PostgreSQL® […]
06 December 2016
[Howto] Centralized and Semantic Logging for PostgreSQL®
Introduction Today, there is no need to argue why centralized logging is useful or even necessary. Most medium-sized companies now have centralized logging or are currently implementing it. Once the infrastructure is in place, it is important to use it effectively and efficiently! Especially as an infrastructure operator or service provider, the goal is to […]
15 June 2016
Quality Assurance in PostgreSQL® with SQLsmith
An interesting tool for quality assurance of C compilers is Csmith, a generator of random C programs. I had come to appreciate it during the development of an optimization phase for a C compiler. This compiler features extensive regression tests, and the correctness of the translated programs is also tested using standardized benchmarks. The latter, […]
05 August 2014
Informix Foreign Data Wrapper for PostgreSQL®
Since PostgreSQL® 9.1, PostgreSQL® has implemented an interface for accessing external data sources. The interface defined in the SQL Standard (SQL/MED) allows transparent access to and manipulation of external data sources in the same manner as with PostgreSQL®-native tables. External data sources appear as tables in the respective database and can be used without restriction […]
