Infrastructure at your Service

Tag

enterprisedb Archives - Blog dbi services

Julia Gugel

Installing EDB Advanced Server without EDB Repository

By | Database Administration & Monitoring | No Comments

Almost all of us, who already installed Enterprise DB Tools on a Linux server know the procedure. You need to add the EDB Repository to your server or your Red Hat Satellite configuration and after that you can easily install the tools you need. But what happens, if you are not able to add the repository? The answer is really simple: Download the rpms and install them directly on the server.

Read More
Daniel Westermann

The EDB filter log extension

By | Database Administration & Monitoring | No Comments

This is another post dedicated to EnterpriseDB Postgres. Sometimes you may want to get specific messages not getting logged to the server’s logfile or audit records. That might be specific error codes or, even more important, passwords you specify when you create users. EDB comes with a solution for that by providing an extension which is called EDB Filter Log. Lets see how you can install, and even more important, how to use that extension.

Read More
Daniel Westermann

Auditing with EDB Postgres Enterprise

By | Database Administration & Monitoring | 7 Comments

It might be that there is a requirement to audit operations in the database. Maybe because of legal requirements, maybe because of security requirements or whatever. I’ve already written a post in the past describing what you can do in community PostgreSQL, this post is specific to EDB Postgres. The auditting features come be default in EDB Postgres and you do not need to install any extension such as pgaudit.

Read More
Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

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

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More
Daniel Westermann

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In the last post we had a look at the basic configuration of EDB EFM and confirmed that we can do manual switchovers for maintenance operations. Being able to do a switchover and switchback is fine but what really is important are automatic failovers. Without an automatic failover this setup would be somehow useless as a) EDB…

Read More
Daniel Westermann

EDB Failover Manager in EDB containers in Minishift/OpenShift

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In the last three posts we deployed an EDB database container and two pgpool instances, scaled that up to include a read only replica and finally customized the PostgreSQL instance with ConfigMaps. In this post will we look at how the EDB Failover Manager is configured in the database containers.

Read More
Daniel Westermann

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then scaled that up to include a read only replica. In this post will use a ConfigMap to adjust parameters in postgresql.conf as you will probably need to do that when you start using the EDB containers in your environment.

Read More
Daniel Westermann

Deploying EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | 10 Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In this post we’ll look at how we can deploy EnterpriseDB containers in MiniShift. When you need to setup MiniShift have a look here. In this post we’ll do the setup with the MiniShift console, in a next post we’ll do the same by using the command line tools.

Read More