Git Filters
Cybertec Blog
by Christoph Berg
3d ago
Nowadays, most Debian packages are maintained in Git repositories, with the majority hosted on Debian's GitLab instance at salsa.debian.org.Debian is running a "vcswatch" service that keeps track of the status of all packaging repositories that have a Vcs-Git (and other VCSes) header set. This status is stored in a PostgreSQL database, which is then utilized by Debian's package maintenance infrastructure for various purposes. One such application is to identify repositories that may require a package upload to release pending changes. Naturally, this amount of Git data required several expansi ..read more
Visit website
Patroni Contributors Meeting 2024 in Munich
Cybertec Blog
by Julian Markwort
3w ago
The day before pgconf.de 2024 in Munich, a few of the Patroni project's contributors met to discuss the past, present and future of this framework for PostgreSQL HA. Various people and companies support and benefit from Patroni. Ants Aasma and I attended the meeting on behalf of CYBERTEC. Patroni is one of the leading solutions for enabling highly available PostgreSQL database clusters, can be used in both simple and complex architectures, with small or large databases, on various operating systems. While Patroni was initially created at online retailer Zalando, the project is now developed i ..read more
Visit website
Open source key areas for digital autonomy
Cybertec Blog
by Jan Karremans
3w ago
How PostgreSQL is destined to make a difference at a European level Why And not just “Why”, but also how. How do you bring free and open source initiatives and something as regulated as the European Union? Both of these questions triggered me to accept the invitation to travel to Brussels and participate in this day of workshops. As part of a larger “tribute to open source” that is traditionally happening in this great city, with FOSDEM, a growing interest from the European Union is becoming apparent. After the keynote address that my CEO Hans-Jürgen Schönig gave at PGConf.EU, just 2 months a ..read more
Visit website
PGconf.de 2024 in Munich
Cybertec Blog
by Christoph Berg
1M ago
As the two talks I had submitted did not get picked for this year´s PGconf.de, my prep for the conference was all about booking train tickets from Düsseldorf to Munich. Being an early bird definitely paid off – Bernd Helmle and I enjoyed first class luxury, while our procrastinating colleagues ended up paying more for second-class seats. The Thursday journey was pretty smooth, with the conductor proudly announcing our punctual arrival – surprised it didn’t make it to the news with Deutsche Bahn’s track record. I even managed to get a good amount of work done, working on CYBERTEC’s PostgreSQL E ..read more
Visit website
Performance tuning: MAX and GROUP BY
Cybertec Blog
by Hans-Jürgen Schönig
1M ago
These days everybody is talking about time series, time series analysis and alike for performance tuning. Analyzing time series data in PostgreSQL can provide valuable insights, help in making informed decisions and understanding data more deeply. By utilizing PostgreSQL’s powerful features, we can efficiently query all types of measurement data to track trends, patterns, and anomalies over time. However, often there is a tiny little requirement, people are struggling to understand. Consider the following data: CREATE TABLE t_sample ( tstamp timestamptz, sensor_id ..read more
Visit website
Recovering Deleted Data From PostgreSQL Tables
Cybertec Blog
by Christoph Berg
1M ago
PostgreSQL is very good at keeping your data safe so it doesn’t disappear by itself. Unfortunately, the same holds in reverse–if data has been deleted, it stays unrecoverable. In this article, we’ll explore options for recovering deleted data from PostgreSQL tables. Option 1: cautious people use transactions If you never make any mistakes when working with data, there won’t be any need for emergency procedures. But since we are all human, things like this happen: -- remove an entry from our contact list db=> DELETE FROM addressbook WHERE name = 'Heinz Schmidt'; DELETE 3 -- PANIC: WHY WERE ..read more
Visit website
Enforcing join orders in PostgreSQL
Cybertec Blog
by Hans-Jürgen Schönig
2M ago
After the pgconfeu23 in Prague – which has been an excellent event – I decided to share some of the things I presented as a blog post to maybe shed some light on some of those topics. One of those ideas presented was the way PostgreSQL handles joins and especially join orders. Internally the PostgreSQL does a good job to optimize queries but how does it really work? Let us create some tables first: plan=# SELECT 'CREATE TABLE x' || id || ' (id int)' FROM generate_series(1, 5) AS id; ?column? -------------------------- CREATE TABLE x1 (id int) CREATE TABLE x2 (id i ..read more
Visit website
TDE: A dive into encrypted data
Cybertec Blog
by Andreas Kretschmer
2M ago
How to check if TDE works? Some days ago a customer asked me how to check if TDE works and files on disk are encrypted. So I installed a new virtual machine with Ubuntu and installed our PGEE-Demo on it. After installation, the new created cluster is unencrypted. So we can try to create a new table and insert one record on it with a short text. To make sure that the record is saved into the table file I called a checkpoint. To hexdump the table file I need to know the data directory and filepath, you can see all commands here: postgres@ubuntupgee:~$ psql psql (16.1 EE 1.3.1 (Ubuntu 16.1ee1.3 ..read more
Visit website
PostgreSQL to Microsoft Excel via Npgsql
Cybertec Blog
by Florian Nadler
3M ago
This article is dedicated to all the Excel heroes out there who want to integrate and use data stored in PostgreSQL. This time we’ll cover all the steps needed to do so by utilizing Npgsql, which is an open source ADO.NET Data Provider for PostgreSQL. To learn more about this versatile driver, check out its main project page or directly jump into the code base. Requirements Let me begin with the needed requirements to follow up on this quick tutorial accordingly. Apart from an accessible PostgreSQL server, an appropriate Excel version or license is required to connect to PostgreSQL via Npgsql ..read more
Visit website
The four quadrants of an Oracle migration
Cybertec Blog
by Jan Karremans
3M ago
The missing piece When you think about migration from Oracle to Postgres, most people just say that it is easy. And if you consult the various sources of information, nothing tells you differently. And it might not even be untrue. Most databases we create, manage, and run are easy to migrate. If you look at the characteristics of these databases, the large bulk of these: Small in size (some tens of GB’s) It is not super important, as they can be down for hours to days without having a great impact on your business No super complex applications, that use the database Not too busy databases, wi ..read more
Visit website

Follow Cybertec Blog on FeedSpot

Continue with Google
Continue with Apple
OR