PostgreSQL

Getting started with Docker – 2 – building your own base image

In the last post we quickly looked at how you can install everything you need to run docker containers on a CentOS 7 host and did bring up the official PostgreSQL image. However there are good reasons(…)

Getting started with Docker – 1 – overview and installation

Everybody is talking about Docker nowadays. What it is about? Do you remember Solaris Zones or Containers? It is more or less the same although development of Docker during the last years made Linux(…)

Can I do it with PostgreSQL? – 7 – Partitioning

PostgreSQL supports tables up to 32TB. Do you want to be the one responsible for managing such a table? I guess not. Usually you start to partition your tables when they grow very fast and consume more(…)

Can I do it with PostgreSQL? – 6 – Server programming

Today we'll continue this series with another topic: What does PostgreSQL provide when it comes to server programming, that is: Writing functions and triggers to support your application? In Oracle you can either use PL/SQL or(…)

Can I do it with PostgreSQL? – 5 – Generating DDL commands

From time to time it is very useful that you can generate the DDL commands for existing objects (Tables, Indexes, whole Schema ...). In Oracle you can either use the dbms_metadata PL/SQL package for this or use(…)

Can I do it with PostgreSQL? – 4 – External tables

In the last posts of this series we talked about restore points, how you could do things that would require the dual table in Oracle and how you can make use(…)

Can I do it with PostgreSQL? – 3 – Tablespaces

In the last posts of this series we talked about restore points and how you could do things that would require the dual table in Oracle. In this post we'll look at tablespaces. This(…)

Can I do it with PostgreSQL? – 2 – Dual

In the first post of this series we talked about restore points. Another question that pops up from time to time is how you can do things in PostgreSQL that would require the dual(…)

Can I do it with PostgreSQL? – 1 – Restore points

When discussing with customers about PostgreSQL we often hear that they can do things in one database that they can not do in PostgreSQL. Most of the times this is not true and you actually can do it in PostgreSQL.

How to patch Postgres Plus Advanced Server in a Standby configuration

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn't it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled(…)