Database Administration & Monitoring

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

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

Monitoring tools for PostgreSQL – POWA

The last posts introduced the logging system, pg_stat_statements, pg_activity and pgcluu. This post will look at POWA: PostgreSQL Workload Analyzer. For getting the most out of POWA the following extension(…)

Monitoring tools for PostgreSQL – pgcluu

The last posts introduced the logging system, pg_stat_statements and pg_activity. All of these can be used to monitor sql statements the PostgreSQL server is executing. In this post I’ll look into pgcluu:(…)

SQL Monitoring in PostgreSQL (3) – pg_activity

The last posts looked at how the logging system and the pg_stat_statements extension can be used to monitor sql statements in PostgreSQL. This post will introduce pg_activity which is very similar to(…)