Database Administration & Monitoring

Getting started with Exasol – Backup and restore (1)

Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure(…)

Getting started with Exasol – Installation from ISO

Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described(…)

Getting started with Exasol – Sessions and auditing

This is the fourth post in the series about Exasol and this time it is about sessions and auditing. If you are interested in the previous posts you can find them here: Getting started with Exasol(…)

Getting started with Exasol – Some words about indexes and transactions

If you followed Getting started with Exasol – Setting up an environment and Getting started with Exasol – Loading data from PostgreSQL you should have an Exasol test system up and running(…)

Oracle ADB from a Jupyter Notebook

By Franck Pachot . My first attempt to connect to an Oracle database from a Jupyter Notebook on Google Colab was about one year ago: https://medium.com/@FranckPachot/a-jupyter-notebook-on-google-collab-to-connect-to-the-oracle-cloud-atp-5e88b12282b0 I’m currently preparing a notebook as a handout(…)

Getting started with Exasol – Loading data from PostgreSQL

In the first post of this series we brought up an Exasol test system to have something to play with. Because playing without data is a bit boring this post is about loading data from PostgreSQL(…)

Getting started with Exasol – Setting up an environment

Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019(…)

How to synchronize the appliance registry metadata on an ODA?

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(…)

Azure Database for PostgreSQL

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(…)

PostgreSQL 13: Trusted extensions

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(…)