Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Setting your cluster name in PostgreSQL 9.5

By | Database Administration & Monitoring | 2 Comments

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 this might look like this: [email protected]:/home/postgres/ [PG6] ps -ef | grep “postgres:” postgres 2325 2324 0 14:01 ? 00:00:00 postgres: logger process postgres 2327 2324 0 14:01 ? 00:00:00 postgres: checkpointer process postgres 2328 2324 0 14:01 ?…

Read More
Franck Pachot

OCM 12c preparation: Data Guard with OEM

By | Database Administration & Monitoring | One Comment

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 I write the commands in the documentation and then copy to execute them so that I’m sure about the documentation). But for OCM 12c preparation, I want to be sure I can do it from…

Read More
Franck Pachot

OCM 12c preparation: Transportable Tablespaces

By | Database Administration & Monitoring, Oracle | No Comments

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 you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Create a plugged-in tablespace by using the transportable tablespace feature. this is the TTS feature…

Read More
Daniel Westermann

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

By | Database Administration & Monitoring, Database management | No Comments

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 PPAS installation to dump or dumpall a community version of PostgreSQL you probably get this: pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo The solution is quite easy but you…

Read More
Daniel Westermann

Parallel sequential scans are coming to PostgreSQL

By | Database Administration & Monitoring | No Comments

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 maximum degree of parallelism for an individual parallel operation. parallel_tuple_cost: Sets the planner’s estimate of the cost of transferring a tuple from a parallel worker process to another process. The default is 0.1 parallel_setup_cost: Sets the planner’s estimate…

Read More
David Schmitt

UKOUG 2015 Day 3: Security, RMAN, Upgrade, Latches and Mutexes

By | Database Administration & Monitoring | No Comments

UKOUG 2015 … Day 3 (Wednesday): Ref: Oracle Security, RMAN, 12c Upgrade, Latches and Mutexes. Here a litle overview of the last day in the Oracle UKOUG 2015 … Two Oracle Security sessions: – The first one about “Database Password Security” by Pete Finnigan. In this session we explored all of the ideas and issues related to database passwords. We also had a look on what is the strongest algorithms for a password and the…

Read More
David Schmitt

UKOUG 2015 Day 2: Oracle Enterprise Manager Mistake and HA, Active DG and GDS, Multitenant upgrade and AWR reports.

By | Database Administration & Monitoring | No Comments

UKOUG 2015 … Day 2 (Tuesday): Ref: Oracle Enterprise Manager Mistake and HA, Active DG and GDS, Multitenant upgrade and AWR reports. For the second day in the Oracle UKOUG 2015, I attented some very good topics and presentation. Here an overview … Two OEM presentation: – In the Morning, first presentation was about “Common mistakes when implementing 12c OEM” by Philipp Brown. A good overview on what to take care when you install and…

Read More
Daniel Westermann

Monitoring tools for PostgreSQL – POWA

By | Database Administration & Monitoring, Database management | No Comments

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 should be installed in the PostgreSQL instance you want to monitor: pg_stat_statements (see last post) pg_stat_kcache: gathers statistics about reads and writes done by the file system layer pg_qualstats: gathers statistics of predicates found in where statements and join clauses btree_gist: provides GiST index operator…

Read More