All articles

About OCR backup

By Mouhamadou Diaw Last day Franck and me were discussing about OCR backup Let’s take a 2 nodes RAC. We can see that OCR backup is automatically done by oracle in only one node on local (with a certain frequency(…)

EDB Postgres Advanced Server 9.5 new features – Profiles

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(…)

Introduction to MongoDB

MongoDB is an open source NoSQL database management system document-oriented. MongoDB allows the manipulation of structured and unstructured data. It is schema-less and can be used to store a large data volume. This blog is explaining the main principle of(…)

DBI Tail v1.2 now released !

Dear IT colleagues, We regularly have to read log file contents either to understand software functioning or for debugging purpose. Most of the time we access same log files located in same servers. It is very painful to login every(…)

Windows failover cluster 2016 : new site awareness feature

After my first two blogs about cloud witness and domain-less dependencies features shipped with Windows Server 2016, it’s time to talk about another pretty cool feature of the WSFC : site awareness that will also benefit to our(…)

Installing EDB Postgres Advanced Server 9.5

Some days ago EnterpriseDB released EDB Postgres Advanced Server 9.5. As usual this release contains all new features that have been introduced with PostgreSQL 9.5 plus the additions that are documented in the release notes.

The Postgres Plus® Cloud Database

In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud(…)

awrrpt and spreport in multitenant

By Franck Pachot . Yesterday I was giving my 'Interpreting AWR Reports' Prezi at Oracle Midlands. There is a point where I explain that I always check the 'Captured SQL account for ...% of Total DB Time (s)' in order(…)

Avoiding access to the public schema in PostgreSQL

In PostgreSQL every database contains the public schema by default. Every user that gets created and can login is able to create objects there. Here is a little demo: I’ll create a new user named u1 which is allowed to(…)

Using the official PostgreSQL yum repositories

Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and(…)