Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
1. Introduction In the world of PostgreSQL database management, ensuring robust backup strategies is mandatory. This week I discovered on postgresql.org latest news one useful tool that streamlines this process: pg_back. pg_back serves as a dedicated dumping tool designed for PostgreSQL. Its primary objective is to facilitate the comprehensive dumping of either all or specific databases, along with global entities,…
The PostgreSQL Community just made a significant leap forward in database security :Postgresql is now a CVE Numbering Authority (CNA). Here is the original announcement about PostgreSQL being added as a CNA on the CVE website. This move marks a pivotal moment for PostgreSQL administrators and users. The Root CVE for Postgresql is RedHat. This last one has only been…
In the last posts about the new incremental backup feature we’ve looked at the following topics: In this post we’ll look into the final topic for this feature: In addition to what was described in the previous posts, there is also a new utility which made it into PostgreSQL: pg_walsummary. As the name implies this can be used to get…
Another great feature just got committed for PostgreSQL 17 and hopefully will not be reverted until the final release later this year. You probably already know copy. Whenever you want to load something into or unload something out of PostgreSQL, this is the tool to use. When loading into PostgreSQL there is something to consider up to PostgreSQL 16 which…
In the first post about incremental backups we’ve looked at how you can do incremental backups in general starting with PostgreSQL 17, probably, if it does not get reverted for some reason until PostgreSQL 17 is released. In the second post about incremental backups we’ve looked at backup chains and the choices you have for combining backups to create a…
In the last post about the introduction of incremental backups for PostgreSQL 17 we’ve looked at the basic concepts of that feature and how you can use it. In the meantime Robert Haas has written a blog post describing some uses cases for the feature. This blog post is the inspiration for this one, and this is all about backups…
I’m currently working on a customer project, where we have 2 old Lenovo Servers, one ODA X7-2M and another ODA X8-2M. In the new project, we are replacing the 2 old Lenovo Servers by 2 new ODA X9-2L. The production database, let’s call it DB01, is a Standard Edition database with dbvisit Standby as Disaster Recovery solution. During each project,…
After having recently deployed a new customer system running Oracle SE2 databases in Disaster Recovery environment using dbvisit StandbyMP v11.4.1 on Oracle Linux 8.8, I did some final test running a switchover. The switchover failed with following error: Problem description Running switchover command was failing: oracle@srv01:~/ [MYDB] /u01/app/dbvisit/standbymp/oracle/dbvctl -d MYDB -o switchover ============================================================= Dbvisit Standby Database Technology (11.4.1) (pid 9997)…
I recently deployed a new installation at one customer with 2 linux servers and 2 Oracle SE2 databases with dbvisit StandbyMP v11 disaster recovery solution. I prepared the standby database using RMAN duplication method, and then just wanted to create the dbvisit DDC configuration using CLI command. I had to troubleshoot one error, and wanted to share quickly the solution…
When it comes to backing up and and restoring a PostgreSQL cluster, most of our customers rely either on pgBackRest or Barman. The reason for this is pretty clear: Both of those tools provide you with a backup repository, full and incremental backups, tons of other features and both automate most of the tasks you expect from a backup solution.…
I am thrilled to share that I had the opportunity to attend the 13th Annual PostgreSQL Conference Europe in Prague which took place between the 12th and the 15th of December. It was my first participation at the PGConf.eu and even at any conference, and it was an enriching experience beyond expectations. My first surprise was the number of people…
Last week was the week of the European PostgreSQL Conference in Prague which I was allowed to join once more. An amazing location was waiting for all the participants and once I entered the hotel, I already felt warmly welcomed in the PostgreSQL Community world. Besides the very interesting program the committee prepared this year, there was of course a…
