Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

PostgreSQL 13: Trusted extensions

By | Database Administration & Monitoring | No Comments

PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or you need to implement something like this (please also note the comment from Hans at the bottom of the blog). This is where this new feature helps: If extensions are marked as “trusted” you do…

Read More
Daniel Westermann

Using PostgreSQL’s adminpack extension to write files

By | Database Administration & Monitoring | No Comments

In PostgreSQL you have several ways of working with files and you can find quite some examples here on our blog, e.g. Modifying pg_hba.conf from inside PostgreSQL, Can I do it with PostgreSQL? – 4 – External tables or Working with files on the filesystem in PostgreSQL. There is also copy which allows you to load or unload tables and there is the adminpack extension which is the topic of this post.

Read More
Nabil Saoual

VirtualBox issue E_FAIL (0x80004005)

By | Database Administration & Monitoring | No Comments

Hi everybody, I get an issue on my VM today , so that I can’t open it anymore. When trying a  system restore I get the same state. I was really embarrassed to fail to restore my VM (as a huge work was done on it) Below we will see how to fix this issue Issue description Investigations I have checked the VM folders , still got the snapshots but can’t even load them :/…

Read More
Mouhamadou Diaw

Duplicate Database on ODA X4

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was just to validate that the backups done by Netback can be used to restore if needed. So the backup teams restored the backups…

Read More
Burgert Daniel

Increase your PostgreSQL databases security by checking a few settings Part 2

By | Database Administration & Monitoring, Postgres, Security | No Comments

Continuing from my first blog we will check some more access and authentication configurations. Focusing on removing unnecessary database privileges. After that we will configure the backend parameters correctly to have more robust PostgreSQL server/client sessions. And at last SSL encryption for these sessions will be configured.

Read More
Julia Gugel

PostgreSQL 13 and Patroni 2.0 – when parameters change

By | Database Administration & Monitoring | No Comments

Starting with PostgreSQL 13 there is a name and value change of one of the parameters used for the streaming replication of a replica server. Some may already know which parameter I am talking about. Until Postgres 12 it was called “wal_keep_segments” but with PostgreSQL 13 it will become “wal_keep_size”. In this small post I will explain, what changed and which nice new feature Patroni 2.0 offers us to not get in trouble using old…

Read More
Mouhamadou Diaw

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

By | Database Administration & Monitoring, Database management, Oracle | One Comment

In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile: fsfo.dat -The fast-start failover callout scripts (new feature in Oracle 20c) Before Oracle 20c, there was no default location for these files. Starting with Oracle 20c, now we can define a default location for all these files by setting an environment…

Read More
Julia Gugel

Patroni 2.0: New features – Patroni on pure Raft

By | Database Administration & Monitoring | No Comments

Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It’s possible to run Patroni without 3rd party dependencies. So no Etcd, Consul or Zookeeper is needed anymore. Great improvement! In this blog we will have a look at the setup and try an failover as well.

Read More
Saïd Mendi

Installing MariaDB Columnstore 1.5 on CentOS 8

By | Database Administration & Monitoring, Database management | No Comments

In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of MariaDB but rather a pluggable storage engine.  This allows to move easily data from InnoDB to ColumnStore and it is also the first version to be released as a plugin for the community Server.

Read More