PostgreSQL

2016 is over and it was great, 2017 will be even more exciting in the open source area

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our(…)

IT-Tage 2016 Informatik aktuell: feedback

Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog(…)

Can I do it with PostgreSQL? – 8 – Transportable tablespaces

My colleague Franck posted a comment to one of my last "Can I do it with PostgreSQL" blog posts. The comment he posted is: "Here is an idea for a future “Can I do(…)

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(…)