Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

PostgreSQL on the beach, PGIBZ, recap

By | Database Administration & Monitoring | No Comments

So, finally, PostgreSQL on the beach is over. During discussions it was mentioned that some companies had issues to justify sending people to a conference to Ibiza. It was not really clear if they wanted to avoid the impression of making holidays while going to a conference or if it was just about the location. I am not judging this at all but what I can tell: It was a great, very relaxed and very…

Read More
Saïd Mendi

In-person event (June 11,2019) Ansible Automates – Bern

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I found in my inbox an invitation from Red Hat concerning an event organized in Bern about Ansible. I heard a lot about Automation but did not really know what can or could be automated. Infrastructure?, Application deployment?, networks?, containers,clouds? All of them? So I wanted to learn more about Ansible and decided to participate. This “Ansible Automates” was a full-day event taking place in the KURSAAL hotel, located in…

Read More
Daniel Westermann

PostgreSQL partitioning (8): Sub-partitioning

By | Database Administration & Monitoring | No Comments

We are slowly coming to the end of this little series about partitioning in PostgreSQL. In the last post we had a look at indexing and constraints and today we will have a look at sub partitioning. Sub partitioning means you go one step further and partition the partitions as well. Although it is not required to read all the posts of this series to follow this one: If you want, here they are: PostgreSQL…

Read More
Jérôme Dubar

Why ODA reimaging doesn’t work on the first try?

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

Introduction Reimaging an ODA is a good practice for a lot of reasons. To make your ODA cleaner if it’s running for many years and if you patch regularly. To simplify patching because if you’re late you could have to apply multiple intermediate patches to reach the target version. Or simply because you need to change the configuration (for example network configuration) and you want to make things clean, and be sure that future patches…

Read More
Daniel Westermann

PostgreSQL partitioning (7): Indexing and constraints

By | Database Administration & Monitoring | No Comments

Yesterday we talked about attaching and detaching of partitions. Today we will look at indexing and constraints when it comes to partitioned tables. If you missed the last posts, again, here they are: PostgreSQL partitioning (1): Preparing the data set PostgreSQL partitioning (2): Range partitioning PostgreSQL partitioning (3): List partitioning PostgreSQL partitioning (4) : Hash partitioning PostgreSQL partitioning (5): Partition pruning PostgreSQL partitioning (6): Attaching and detaching partitions

Read More
Pierre Sicot

Discover target database 18c with EM12c

By | Database Administration & Monitoring | No Comments

Working on Enterprise Manager 12.1.0.4 version at a client’s site, we would like to know if oracle database target in 18c version could be discovered and monitored, even if Enterprise Manager 12.1.0.4 does not support Oracle 18c database targets. Installing the agent 12c on the target host did not cause any problem, the oracle database 18c discovery ran successfully, but the database was seen as down in the Enterprise Manager 12.1.0.4 console. We tried several…

Read More
Daniel Westermann

PostgreSQL partitioning (6): Attaching and detaching partitions

By | Database Administration & Monitoring | No Comments

Having talked about partitioning strategies and partition pruning this time we will have a look on how you can attach and detach partitions to and from an existing partitioned table. If you missed the last posts about partitioning in PostgreSQL here they are: PostgreSQL partitioning (1): Preparing the data set PostgreSQL partitioning (2): Range partitioning PostgreSQL partitioning (3): List partitioning PostgreSQL partitioning (4) : Hash partitioning PostgreSQL partitioning (5): Partition pruning

Read More
Daniel Westermann

PostgreSQL partitioning (5): Partition pruning

By | Database Administration & Monitoring | No Comments

This is the next post in the PostgreSQL partitioning series. If you missed the previous ones here they are: PostgreSQL partitioning (1): Preparing the data set PostgreSQL partitioning (2): Range partitioning PostgreSQL partitioning (3): List partitioning PostgreSQL partitioning (4): Hash partitioning This time we will have a look at partition pruning. Never heard of that? Don’t worry, hopefully it will be clear at the end of this blog post.

Read More
Daniel Westermann

PostgreSQL partitioning (4): Hash partitioning

By | Database Administration & Monitoring | No Comments

The last partitioning strategy we will look at is: hash partitioning. If you missed the first posts in this series here they are: PostgreSQL partitioning (1): Preparing the data set PostgreSQL partitioning (2): Range partitioning PostgreSQL partitioning (3): List partitioning Usually hash partitioning is used when you do not have a natural way of partitioning your data or you want to evenly distribute the data based on hash.

Read More