Database Administration & Monitoring Getting started with Exasol – Backup and restore (1) 09.10.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring Getting started with Exasol – Installation from ISO 08.10.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring Getting started with Exasol – Sessions and auditing 05.10.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring Getting started with Exasol – Some words about indexes and transactions 01.10.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring, Database management Getting started with Exasol – Loading data from PostgreSQL 30.09.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring Getting started with Exasol – Setting up an environment 29.09.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring PostgreSQL 13: Trusted extensions 23.09.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring Using PostgreSQL’s adminpack extension to write files 23.09.2020 by Daniel Westermann 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(…)
Database Administration & Monitoring The EDB tool-set integration into PEM – EDB EFM 21.08.2020 by Daniel Westermann In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console.
Database Administration & Monitoring The EDB tool-set integration into PEM – EDB BART 20.08.2020 by Daniel Westermann When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a(…)