Infrastructure at your Service

Category

Database Administration & Monitoring

Marc Wagner

How to synchronize the appliance registry metadata on an ODA?

By | Database Administration & Monitoring, Oracle | No Comments

Databases administration on a Bare Metal ODA will be done as root user by running odacli commands : odacli create-database to create a database odacli upgrade-database to upgrade a database between major releases odacli move-database to move databases from one Oracle home to another of the same database version odacli update-dbhome to update a specific RDBMS home to the latest patch bundle version etc… The odacli commands will do the needful and at the end…

Read More
Karsten Lenz

Azure Database for PostgreSQL

By | Database Administration & Monitoring | No Comments

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where it is possible to find out the used OS on PostgreSQL Level. select version(); => PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bi show dynamic_shared_memory_type; => windows show archive_command; => c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f”…

Read More
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