PostgreSQL

How to patch Postgres Plus Advanced Server

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no :) The difference is(…)

Running PostgreSQL on ZFS on Linux – Compression

In the last posts in this little series we looked at how to get a ZFS file system up and running on a CentOS 7 host and how snapshots and clones can be used(…)

Running PostgreSQL on ZFS on Linux – Fun with snapshots and clones

In the last post we looked at how to get a ZFS file system up and running on a CentOS 7 host and how to enable the auto mount of the ZFS file systems. In this post(…)

Running PostgreSQL on ZFS on Linux

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement(…)

Connecting your PostgreSQL instance to an Oracle database – Debian version

Some time ago I blogged about attaching your PostgreSQL instance to an Oracle database by using the oracle_fdw foreign data wrapper. This resulted in a comment which is the reason for this post: Doing the same(…)

What the hell are these template0 and template1 databases in PostgreSQL?

When people start to work with PostgreSQL, especially when they are used to Oracle, some things might be very confusing. A few of the questions we usually get asked are: Where is the listener and how can I configure it?(…)

Securing your connections to PostgreSQL by using SSL

Security is a big topic today and in the news almost every day. As the database usually holds sensitive data this data must be well protected. In most cases this is done by encrypting critical data inside the database and(…)

EDB Failover Manager 2.1, (two) new features

In the last post we upgraded EDB EFM from version 2.0 to 2.1. In this post we'll look at the new features. Actually we'll look only at two of the new features in this(…)

EDB Failover Manager 2.1, upgrading

Some days ago EnterpriseDB released a new version of its EDB Failover Manager which brings one feature that really sounds great: "Controlled switchover and switchback for easier maintenance and disaster recovery tests". This is(…)

Auditing in PostgreSQL

Today, especially in the Pharma and Banking sectors, sooner or later you will be faced with the requirement of auditing. Detailed requirements will vary but usually at least tracking logons to the database is a must. Some companies need more(…)