Infrastructure at your Service

Franck Pachot

Postgres vs. Oracle access paths – intro

By | Oracle, Postgres | 2 Comments
 

 This is the start of a series on PostgreSQL execution plans, access path, join methods, hints and execution statistics. The approach will compare Postgres and Oracle. It is not a comparison to see which one is better, but rather to see what is similar and where the approaches diverge. I have a long experience of reading Oracle execution plans and no experience at all on Postgres. This is my way to learn and share what…

Read More
Franck Pachot

PostgreSQL on Cygwin

By | Postgres | No Comments
 

 I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install PosgreSQL and rather than installing it in a Linux VM, or as a Windows program, I installed the Cygwin version of it. Here is how.

Read More
Morgan Patou

Documentum – Change password – 8 – FT – Dsearch & xDB

By | Entreprise content management | No Comments
 

 Here we are, already, at the end of my series of blogs about the “Change Password”. This blog will, as already mentioned in a previous one, talk about the Dsearch and xDB passwords. I could have created a lot more blogs in this series but I already presented the most important and most interesting ones so this blog will be the last one – at least for now ;).   Please note that below, I…

Read More
Morgan Patou

Documentum – Change password – 7 – DB – Schema Owner

By | Entreprise content management | No Comments
 

 In this serie, I completed the passwords I wanted to talk about on the Content Server. Therefore in this blog, I will talk about the only Database Account that is relevant for Documentum: the Database Schema Owner. Since there are a few steps to be done on the Content Server, I’m just doing everything from there… In this blog, I will assume there is one Global Registry (GR_DOCBASE) and one normal Repository (DocBase1). Each docbase…

Read More
Morgan Patou

Documentum – Change password – 6 – CS/FT – JKS

By | Entreprise content management | No Comments
 

 Just like for the JBoss Admin password (here), this blog will be for both Content Servers and Full Text Servers. I will provide commands below to change the passwords of the Java KeyStore for the Java Method Server (JMS) and Full Text Servers (Dsearch/IndexAgent). Again, JKS aren’t only used in the scope of Documentum so if you are here for the JKS and not for Documentum, that’s fine too ;).   The steps are exactly…

Read More
Daniel Westermann

Setting up default parameters for roles in PostgreSQL

By | Database Administration & Monitoring | No Comments
 

 As you might know you can set various parameters on the session level in PostgreSQL by using the “set” command: postgres=# \h set Command: SET Description: change a run-time parameter Syntax: SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | ‘value’ | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT } This allows a session to adjust parameters at runtime and…

Read More
Yann Neuhaus

Alfresco 5.2 our DMS of choice!

By | Entreprise content management | No Comments
 

 Introduction Nowadays companies have to deal with lots of electronic documents, some of them being mission critical. Insurances, Banks and Pharma industries are good candidates for ECM/DMS solutions since they produce and deal with lots of documentations, contracts and receipts. Usually the largest ECM/DMS infrastructures can be found at those customers which initiate large digitalization processes. However even for smaller businesses, managing e-documents like sales quotations, offers, answers to RFIs and RFPs becomes mission critical….

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 17 – Identifying a blocking session

By | Database Administration & Monitoring | No Comments
 

 One single blocking session in a database can completely halt your application so identifying which session is blocking other sessions is a task you must be able to perform quickly. In Oracle you can query v$session for getting that information (blocking_session, final_blocking_session). Can you do the same in PostgreSQL? Yes, you definitely can, lets go.

Read More
Morgan Patou

Documentum – Change password – 5 – CS/FT – JBoss Admin

By | Entreprise content management | One Comment
 

 The next password I wanted to blog about is the JBoss Admin password. As you know, there are several JBoss Application Servers in Documentum. The most used being the ones for the Java Method Server (JMS) and for the Full Text Servers (Dsearch/IndexAgent). In this blog, I will only talk about the JBoss Admin password of the JMS and IndexAgents simply because I will include the Dsearch JBoss instance in another blog which will talk…

Read More
Morgan Patou

Documentum – Change password – 4 – CS – Presets & Preferences

By | Entreprise content management | No Comments
 

 In a previous blog (see this one), I already provided the steps to change the BOF password and I mentioned that this was more or less the only important account in the Global Registry. Well in this blog, I will show you how to change the passwords for the two other important accounts: the Presets and Preferences accounts.   These two accounts can actually be created in a dedicated repository for performance reasons but by…

Read More