Infrastructure at your Service

enterprisedb Archives - Blog dbi services

Daniel Westermann

A first look at EDB Postgres Enterprise Manager 7 beta – Connecting a PostgreSQL instance

By | Database Administration & Monitoring | No Comments

In the last post we did a click/click/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance running (192.168.22.249 in my case, which runs PostgreSQL 10 Beta1). Lets go …  

 
Read More
Daniel Westermann

Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup

By | Database Administration & Monitoring | No Comments

When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this which is called EDB Replication Server. As soon as you have one subscription from EnterpriseDB this tool is included and can be used to offload from Oracle to PostgreSQL. Lets do a simple replication setup and see how it…

 
Read More
Daniel Westermann

EDB BART 2.0 – How to upgrade and block level incremental backups

By | Database Administration & Monitoring | No Comments

We already have some posts on how you can use EDB BART to backup and restore your PostgreSQL instances from one central server (EnterpriseDB Backup and Recovery Tool (BART), getting started with postgres plus advanced server (2) – setting up a backup and recovery server). The current version you can download from the EnterpriseDB website is 1.1 but version 2.0 is in beta and can be tested already. The main new feature is that BART…

 
Read More
Daniel Westermann

2016 is over and it was great, 2017 will be even more exciting in the open source area

By | Database Administration & Monitoring | No Comments

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our Open Infrastructure division. We’ll start with a few figures then look at the events we did and some of the projects we completed in 2016. Here we go …  

 
Read More
Mouhamadou Diaw

EnterpriseDB Backup and Recovery Tool (BART)

By | Database Administration & Monitoring | No Comments

Many tools are proposed for backup and recovery operation of a PostgreSQL database. EnterpriseDB has developed a product named BART (Backup and Recovery Tool). Use of this product needs a subscription but you can download a trial version for test purpose. In this blog we are using BART with PostgreSQL 9.6.1. BART allows backing up over the net and can centralize backups of many PostgreSQL servers. We are using the following configuration: Bart Host: pgserver.localdomain…

 
Read More
Daniel Westermann

How to patch Postgres Plus Advanced Server in a Standby configuration

By | Database Administration & Monitoring | No Comments

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn’t it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled switchover and finally patch the old master? In case this is a configuration with EDB Failover Manager the only downtime which would happen is the relocation of the VIP from one node to another (if you use a…

 
Read More
Daniel Westermann

How to patch Postgres Plus Advanced Server

By | Database Administration & Monitoring | No Comments

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This is pretty much the same as with My Oracle Support where you need a customer support identifier mapped to your account…

 
Read More
Daniel Westermann

EDB Failover Manager 2.1, (two) new features

By | Database Administration & Monitoring | 2 Comments

In the last post we upgraded EDB EFM from version 2.0 to 2.1. In this post we’ll look at the new features. Actually we’ll look only at two of the new features in this post: Failover Manager now simplifies cluster startup with the auto.allow.hosts property efm promote now includes a -switchover option; the -switchover option instructs Failover Manager to perform a failover, promoting a Standby to Master, and then, return the Master node to the…

 
Read More