Infrastructure at your Service

enterprisedb Archives - Page 2 of 3 - Blog dbi services

Daniel Westermann

EDB Failover Manager 2.1, (two) new features

By | Database Administration & Monitoring | 3 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
Daniel Westermann

EDB Failover Manager 2.1, upgrading

By | Database Administration & Monitoring | 2 Comments

Some days ago EnterpriseDB released a new version of its EDB Failover Manager which brings one feature that really sounds great: “Controlled switchover and switchback for easier maintenance and disaster recovery tests”. This is exactly what you want when you are used to operate Oracle DataGuard. Switching back and forward as you like without caring much about the old master. The old master shall just be converted to a standby which follows the new master…

 
Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (3) – Witness node

By | Database Administration & Monitoring | 2 Comments

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance operations on the master as well as on the standby node in a failover cluster managed by EDB Failober Manager. What is still open is how to perform maintenance operations on the witness node. So, lets go.  

 
Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (2) – Primary node

By | Database Administration & Monitoring | 4 Comments

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I’ll look on how you can do maintenance on the primary node (better: the node where the primary instance currently runs on). This requires slightly more work and attention. Lets go.  

 
Read More
Daniel Westermann

Transactional DDL

By | Database Administration & Monitoring | No Comments

When you are working on Oracle you probably learned that each DDL does an implicit commit in the background. There is no way to have DDLs wrapped in a real transaction (with the exception of the “create schema” command which I blogged about a long time ago). If you take a look a the SQL:2008 standard (ISO/IEC 9075-1:2008) you can find this: “An SQL-transaction (transaction) is a sequence of executions of SQL-statements that is atomic…

 
Read More
Daniel Westermann

Install PL/JAVA in Postgres Plus Advanced Server 9.5

By | Database Administration & Monitoring | 28 Comments

While doing a project at a customer we came to a point where we needed to install pl/java into Postgres Plus Advanced Server 9.5. If you follow the official documentation you will probably fail and get stuck when trying to build pl/java with maven (at least I did fail several times). Unfortunately there is not much documentation around for solving the issues that popped up. As we have a very good communication channel into EnterpriseDB…

 
Read More
Daniel Westermann

The dbi services PostgreSQL reference architecture (1) – The commercial approach

By | Database Administration & Monitoring | No Comments

When it comes to designing a PostgreSQL architecture that fits your requirements there are a couple of things to think about: Do you need a HA setup? How shall backups and restores being done and how shall all of these components get monitored? Do you need vendor support for all the tools that make up the architecture? At dbi we have a reference architecture that we can apply to most of our projects. It is…

 
Read More
Daniel Westermann

EDB Postgres Advanced Server 9.5 new features – Profiles

By | Database Administration & Monitoring | No Comments

The just released version of EDB Postgres Advanced Server 9.5 introduces profiles very much the same as in Oracle. Lets have a look at it. As in Oracle there is a default profile: (enterprisedb@[local]:5445) [postgres] > \x Expanded display is on. (enterprisedb@[local]:5445) [postgres] > select * from edb_profile; -[ RECORD 1 ]———–+——– prfname | default prffailedloginattempts | -2 prfpasswordlocktime | -2 prfpasswordlifetime | -2 prfpasswordgracetime | -2 prfpasswordreusetime | -2 prfpasswordreusemax | -2 prfpasswordverifyfuncdb |…

 
Read More