All articles

Setting your cluster name in PostgreSQL 9.5

PostgreSQL 9.5 introduces a new parameter which is called: cluster_name. So, what is this good for? Imagine you have two (or even more) PostgreSQL clusters running on the same host. When looking at the operating system processes(…)

OCM 12c preparation: Data Guard with OEM

By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It's not that I don't like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually(…)

OCM 12c preparation: documentation

By Franck Pachot . The OCM exam advice says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. I've checked that I can find quickly the documentation related with each topic listed. Here(…)

OCM 12c preparation: Explain fast refresh

By Franck Pachot . There are some rules to be able to fast refresh a materialized view (which means, refresh it so that it is not stale, and without running the whole query). Documentation is in the Datawarehouse Guide, but(…)

OCM 12c preparation: Transportable Tablespaces

By Franck Pachot . I use transportable tablespaces a lot since 8i, here are just a few examples. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what(…)

pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist

As I could not find any information about this error when I faced it this is just a short hint: If you try to use pg_dump or pg_dumpall out of a(…)

SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS

In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)

Windows Server 2016: Containers

One of the new feature which will come with Windows Server 2016 is the Containers. Microsoft made available its fourth technical preview of his Windows Server 2016 platform  some days ago. This new Technical Preview brings with it and for(…)

Parallel sequential scans are coming to PostgreSQL

It didn’t made it into the upcoming PostgreSQL 9.5 release but it will probably be coming in 9.6: Parallel sequential scans. If you take a look at the development documentation some new parameters showed up: max_parallel_degree: The(…)

Mail mit Format und Priorität aus Linux

Ausgangslage Ein Kunde hat mit kürzlich danach gefragt, wie ich den Output eines Scripts auf einer Linuxplattform per Mail sauber formatiert versenden kann. Als Beispiel nehmen wir folgendes: ____________________________________________________________________________________________________________________ File System free space on fed22v1.localdomain ____________________________________________________________________________________________________________________ | | | Mb-Total(…)