Database Administration & Monitoring

Upgrade EM 13.2 to EM 13.3

As the last Enterprise Manager Cloud Control 13.3 is out since a few days, I decided to test the upgrade procedure from the Enterprise Manager Cloud Control 13.2 You have to follow some pre-requisites: First you copy the emkey :(…)

Licensable targets and Management Packs with EM13c

When you add a new target in Enterprise Manager 13c , the management packs are enabled by default. This could be a problem in case of a LMS control, and to avoid any problem, you have to  manually disable those(…)

Using the managed PostgreSQL service in Azure

In the last post we had a look on how you can bring up a customized PostgreSQL instance in the Azure cloud. Now I want to check what you can do with the managed service. For(…)

ORACLE_HOME with symbolic link and postupgrade_fixups

By Franck Pachot . Here is a quick post you may google into if you got the following error when running postupgrade_fixups.sql after an upgrade: ERROR - Cannot open the preupgrade_messages.properties file from the directory object preupgrade_dir DECLARE * ERROR(…)

Bringing up your customized PostgreSQL instance on Azure

The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully(…)

TRANSPORT_CONNECT_TIMEOUT and RETRY_COUNT

By Franck Pachot . When you have a Data Guard configuration, you want the application to connect to the right server, where the primary is, without taking too much time. The default TCP timeout is 1 minute which is too(…)

Using Oratcptest

By Mouhamadou Diaw Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show(…)

Backing up and restoring EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. The last blogs in the series are already some days old: Setting up MiniShift,(…)

Catching interface state changes with Network Manager

Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As(…)

When does PostgreSQL create the table and index files on disk?

A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The(…)