Database Administration & Monitoring Can I do it with PostgreSQL? – 17 – Identifying a blocking session 25.07.2017 by Daniel Westermann One single blocking session in a database can completely halt your application so identifying which session is blocking other sessions is a task you must be able to perform quickly. In Oracle you can query v$session for(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 16 – DDL triggers 14.07.2017 by Daniel Westermann A question I received recently from a customer: Oracle gives you the possibility to create DDL triggers. DDL triggers fire (as the name implies) when DDL events occur. Can we do that in PostgreSQL? Yes, this feature(…)
Database Administration & Monitoring What are typed tables in PostgreSQL? 13.07.2017 by Daniel Westermann While reading the PostgreSQL documentation for "CREATE TABLE" I came across this: "OF type_name: Creates a typed table, which takes its structure from the specified composite type (name optionally schema-qualified). A typed table is tied to its(…)
Database Administration & Monitoring Did you ever wonder what PostgreSQL is executing in the background when you use the psql shortcuts? 13.07.2017 by Daniel Westermann When you work with PostgreSQL you are probably using psql and when you use psql you are probably using one or more of the shortcuts psql is providing. These shortcuts provide a quick and convenient way to(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 15 – invisible indexes 12.07.2017 by Daniel Westermann It has been quite a while since the last post in this series. Today we'll look at what you know from Oracle as: Invisible indexes. In case you wonder what they might be useful for: Imagine you(…)
Database Administration & Monitoring A first look at EDB Postgres Enterprise Manager 7 beta – Connecting a PostgreSQL instance 15.06.2017 by Daniel Westermann In the last post we did a click/click/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For(…)
Database Administration & Monitoring A first look at EDB Postgres Enterprise Manager 7 beta 15.06.2017 by Daniel Westermann In case you missed it: EnterpriseDB has released the beta of Postgres Enterprise Manager 7 beta. When installation is as easy as for the current version that should just be a matter of clicking next, lets see.
Database Administration & Monitoring Getting Solaris 8 x86 up and running in Virtual Box 26.05.2017 by Daniel Westermann As this project is going to start soon and I learned that there is a x86 version of Solaris 8, today I thought it would be great if I can get a test setup up and(…)
Database Administration & Monitoring You do use the Oracle Trace File Analyzer, don’t you? 25.05.2017 by Daniel Westermann When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don't know what it is for then you probably should read this, especially when you are working in clustered(…)
Database Administration & Monitoring Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup 23.05.2017 by Daniel Westermann When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this(…)