Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

PostgreSQL on Amazon RDS – Setting up the beast

By | Database Administration & Monitoring | No Comments

Today I had a look at PostgreSQL in Amazon RDS. Once you have an Amazon AWS account (this requires a valid credit card for verification) setup bringing up a PostgreSQL instance is pretty easy. The first 12 months are free but be sure to read about the restrictions and what is terminated by default and what is not. Once your AWS account is ready you can login to the management console which lists all the…

Read More
Franck Pachot

PDB snapshot copy for continuous integration testing

By | Database Administration & Monitoring | 5 Comments

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is not optimized for DDL. Restoring the database takes too long. Even if you data is small, there is those SYSTEM, SYSAUX tablespaces. Flashback database can help, but it still takes time because it requires to…

Read More
Daniel Westermann

How fast can you setup a standby database with PostgreSQL?

By | Database Administration & Monitoring | No Comments

While setting up a PostgreSQL infrastructure at customer today my colleague Pierre Sicot and I discussed on how time consuming it is to setup standby databases if you compare different vendors. Lets make a challenge out of this. This is the baseline: Install the product from scratch Create a master database Create a hot standby database (on the same host) The standby database needs to be open read only Create a table containing one record…

Read More
Daniel Westermann

Watching sql statements in PostgreSQL

By | Database Administration & Monitoring | No Comments

Back in 2012 I wrote a small blog post about watching the results of commands in Linux. Well, the same can be done in psql: ([email protected][local]:4448) [postgres] > create table t1 ( a int ); CREATE TABLE ([email protected][local]:4448) [postgres] > insert into t1 values ( generate_series ( 1, 10)); INSERT 0 10 ([email protected][local]:4448) [postgres] > select count(*) from t1; count ——- 10 (1 row) ([email protected][local]:4448) [postgres] > \watch Watch every 2s Mon Dec 21 07:34:35…

Read More
Franck Pachot

OCM 12c preparation: RAT in multitenant

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I have several customers that have cases where Real Application Testing can be interesting, but they don’t use it because it’s an expensive option. Which is why it’s probably the topic listed for OCM 12c exam where I’ve the less experience. And I don’t even know at which level (CDB or PDB) it has to be run in multitenant. So I’ve tested it and came to a surprise.

Read More