Infrastructure at your Service

Tag

enterprisedb Archives - Blog dbi services

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

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 EFM is supposed to do exactly that and b) without that we would need to implement something on…

Read More
Daniel Westermann

2017.pgconf.eu started, and look who is there …

By | Database Administration & Monitoring | No Comments

So, finally 2017.pgconf.eu started today and while checking the schedule I noticed something that I could not even imagine some years ago. There is a session from Microsoft: Latest update on Azure managed service for PostgreSQL. Personally I really like to see that Microsoft is more and more present at Open Source conferences and starts engaging in the community. But, of course this is not the only session that will be interesting. There is an…

Read More
Daniel Westermann

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

By | Database Administration & Monitoring | One Comment

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