PostgreSQL

EM13c and postgres plugin

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with(…)

Which parameter changes do require a restart of my PostgreSQL instance?

Starting wiht PostgreSQL 9.4 you can change parameters in postgresql.conf with the "alter system" command in psql. In principle every parameter can be changed that way but not every parameter is applied immediately. Some of(…)

A look at PostgreSQL 9.6 – psql gexec

This little, but powerful, enhancement that it made it in PostgreSQL 9.6 is probably nothing a application can benefit of. But it can be huge saving for people doing maintenance operations on a PostgreSQL instance. It is(…)

A look at PostgreSQL 9.6 – Killing idle transactions automatically

A common issue with databases: The guy at floor 2 did some work on the database and then rashly left for lunch because the lady on floor 1 is already waiting for him. Unfortunately he did not close his transaction(…)

A look at PostgreSQL 9.6 – progress reporting for VACUUM operations

Vacuum in PostgreSQL is one of the most important points to consider when managing a PostgreSQL instance. Usually vacuum is running in the background and just gets the job done. But, as always, there are situations when(…)

A look at PostgreSQL 9.6 – The wait interface

For a long time there was no real wait interface in PostgreSQL core. Now, with the upcoming 9.6, pg_stat_activity was extended to provide more meaningful information for what a session is currently waiting on.

Happy birthday PostgreSQL

Connecting your PostgreSQL instance to a Microsoft SQL Server instance

In the last posts I looked at how you can connect Oracle and MariaDB/MySQL to a PostgreSQL instance. In this post I'll do the same with a MS SQL Server instance.

Interested in the most advanced open source database? Where you can meet us in June …

Are you interested in what PostgreSQL can do for you? You can join us at the following events in June:(…)

Connecting your PostgreSQL instance to a MariaDB/MySQL instance

Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I'll do the same with a MariaDB/MySQL instance.