Infrastructure at your Service

Morgan Patou

Encryption of shell scripts

By | Application integration & Middleware | No Comments
 

 In this blog, I will talk about the encryption of files and in particular the encryption of a shell script because that was my use case. Before starting, some people may say/think that you shouldn’t encrypt any scripts and I globally agree with that BUT I still think that there might be some exceptions. I will not debate this further but I found the encryption subject very interesting so I thought I would write a…

Read More
Morgan Patou

Documentum – Unable to install xCP 2.3 on a CS 7.3

By | Entreprise content management | No Comments
 

 Beginning of this year, we were doing our first silent installations of the new Documentum stack. I already created a few blogs to talk about some issues with CS 7.3 and xPlore 1.6. This time, I will talk about xCP 2.3 and in particular the installation on a CS 7.3. The Patch of xCP as well as the patch for the CS 7.3 doesn’t matter since all versions are affected. Please just note that the…

Read More
Morgan Patou

Documentum – Using DA with Self-Signed SSL Certificate

By | Entreprise content management | No Comments
 

 A few years ago, I was working on a Documentum project and one of the tasks was to setup all components in SSL. I already published a lot of blogs on this subject but there is one I wanted to do but never really took the time to publish it. In this blog, I will therefore talk about Documentum Administrator in SSL using a Self-Sign SSL Certificate. Recently, a colleague of mine had the same…

Read More
Daniel Westermann

Developer GUI tools for PostgreSQL

By | Database Administration & Monitoring | No Comments
 

 There was a recent thread on the PostgreSQL general mailing list asking for GUI tools for PostgreSQL. This is question we get asked often at customers so I though it might be good idea to summarize some of them in a blog post. When you know other tools than the ones listed here which look promising, let me know so I can add them. There is a list of tools in the PostgreSQL Wiki as…

Read More
Daniel Westermann

A wonderful PostgreSQL feature: default privileges

By | Database Administration & Monitoring | No Comments
 

 Imagine this scenario (which is not so uncommon): You have a lot of objects in a user schema and you want to grant another user access to that tables. You can easily do this by granting select on the tables to the user and you’re fine. Really? Maybe now, but what will happen when the user which owns the objects creates new objects? Then you will need to grant those to the second user as…

Read More
Franck Pachot

Postgres vs. Oracle access paths II – IndexOnlyScan

By | Oracle, Postgres | No Comments
 

 In the previous post I’ve explained a sequential scan by accident: my query needed only one column which was indexed, and I expected to read the index rather than the table. And I had to hint the Oracle example to get the same because the Oracle optimizer chooses the index scan over the table scan in that case. Here is where I learned a big difference between Postgres and Oracle. They both use MVCC to…

Read More
Franck Pachot

Oracle Cloud: script to stop all PaaS services

By | Cloud, Oracle | No Comments
 

 With metered cloud services, keeping all your instances running may become expensive. The goal is to start them only when you need them. Here is a script that stops all instances you have on the Oracle Cloud Service PaaS. You can schedule it for example to stop them at the end of the business day, or when they are not active for a long time. The scripts use the REST API called with curl, JSON…

Read More
Franck Pachot

Postgres vs. Oracle access paths I – Seq Scan

By | Oracle, Postgres | 5 Comments
 

 Here is the first test I’ve done for my Postgres vs. Oracle access paths series and the first query did a sequential scan. It illustrates the first constant you find in the documentation for the query planner: seq_page_cost (floating point) Sets the planner’s estimate of the cost of a disk page fetch that is part of a series of sequential fetches. The default is 1.0.

Read More
Franck Pachot

Postgres unique constraint

By | Postgres | No Comments
 

 I’ll start a series on Postgres vs. Oracle access paths because I know Oracle and I learn Postgres. While preparing it, I came upon some surprises because I’m so used to Oracle that I take some behavior as granted for any SQL databases. I recently posted a tweet about one of them, comparing latest Postgres version to earliest Oracle version I have on my laptop. The goal of the tweet was exactly what I said…

Read More