All articles

Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication?

When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details(…)

Quick history on database growth

By Franck Pachot . AWR collects segment statistics, and this can be used to quickly understand an abnormal database growth. Here is a script I use to get, from the AWR history, the segments that have grown by more than(…)

Are large objects supported in PostgreSQL 10 logical replication?

Another interesting topic that popped up last week during pgconfeu: Are large objects supported with logical replication in PostgreSQL 10? The only truth is a test, isn't it? Lets go...

Pass Summit 2017

Today starts the Pass Summit 2017 taking place in Seattle. After a small fly over the Ocean, more than 10 hours… yesterday, and a nice jet lag which avoid me to sleep later than 4AM this morning, I arrived(…)

PASS SUMMIT 2017 – SQL Server Security

Today is the first day of the PASS SUMMIT 2017 in Seattle (WA). The weather is cloudy and we have only 11°C… but where is the problem? Everything happens inside! (at the Convention(…)

Enable Trusted Content Services (TCS) license in Documentum Content Server

The Trusted Content Services is a pack of features that you can enable/purchase to gain more security for your Content Server. The main key features are listed in this documentation: https://www.emc.com/collateral/software/data-sheet/h3138-security-ds.pdf In our case,(…)

Dbvisit replicate – SQL Developer chart

By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours(…)

Are temporary tables auto vacuumed in PostgreSQL?

While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question(…)

Configuring Fusion Middleware 12C Reports Server with Single Sign On and External LDAP server

Most of the time when the Reports Server is configured with an Single Sign On Server, it uses the same external LDAP server as the Single Sign On Server. In our case, we used an Oracle Access Manager as(…)

New installed Fusion Middleware 12C Reports or Forms WebLogic Servers fails to start after configuring SSL

We installed a Fusion Middleware report and Forms 12.2.1.2.0 on a Linux Server. This was a single node Reports and Forms servers. After disabling the Non SSL Listen Port, we get below error in logs while starting the(…)