PostgreSQL PostgreSQL on Cygwin 01.08.2017 by Oracle Team By Franck Pachot . 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(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths VII – Bitmap Index Scan 31.07.2017 by Oracle Team By Franck Pachot . In the previous post we have seen the Index Scan, where a where clause condition uses the index structure to find rows and then fetches remaining columns from the table. The case(…)
Database Administration & Monitoring Re-assigning all objects from on role to another in PostgreSQL 31.07.2017 by Daniel Westermann 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(…)
Enterprise content management Documentum – Change password – 8 – FT – Dsearch & xDB 29.07.2017 by Morgan Patou 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(…)
Enterprise content management Documentum – Change password – 7 – DB – Schema Owner 29.07.2017 by Morgan Patou 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(…)
Enterprise content management Documentum – Change password – 6 – CS/FT – JKS 29.07.2017 by Morgan Patou 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(…)
Database Administration & Monitoring Setting up default parameters for roles in PostgreSQL 28.07.2017 by Daniel Westermann 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(…)
Enterprise content management Alfresco 5.2 our DMS of choice! 27.07.2017 by Yann Neuhaus 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.
Database Administration & Monitoring Can I do it with PostgreSQL? – 17 – Identifying a blocking session 25.07.2017 by Daniel Westermann 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(…)
Enterprise content management Documentum – Change password – 5 – CS/FT – JBoss Admin 22.07.2017 by Morgan Patou 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(…)