All articles

Re-assigning all objects from on role to another in PostgreSQL

From time to time it might be required to move objects (tables, indexes, whatever) from one user to another user in a database system. You could do that by dumping all the objects with pg_dump and then(…)

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

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

Documentum – Change password – 7 – DB – Schema Owner

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

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

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

Setting up default parameters for roles in PostgreSQL

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

Alfresco 5.2 our DMS of choice!

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.

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

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

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

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

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

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

Documentum – Change password – 3 – CS – Installation Owner

In this blog, I will describe the few steps needed to change the Documentum Installation Owner’s password. As you all know, the Installation Owner is (one of) the most important password in Documentum and it is probably the first you(…)