PostgreSQL

Vertically scale your PostgreSQL infrastructure with pgpool – 2 – Automatic failover and reconfiguration

In the first post of this little series we did the basic setup of pgpool and configured the watchdog. So, as of now, pgpool uses a VIP which is active on one of the(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 1 – Basic setup and watchdog configuration

I have written some posts on how you can make your PostgreSQL deployment high available by using PostgreSQL's streaming replication feature in the past ( 1, 2 ). The main issue you'll have to(…)

Postgres Barman and DMK

As PostgreSQL is more and more present in our client’s infrastructure, I wanted to describe you the barman installation and configuration. Barman is the backup and recovery tool for PostgreSQL, I configured it using DMK out tool for infrastructure administrators(…)

EDB BART 2.0 – How to upgrade and block level incremental backups

We already have some posts on how you can use EDB BART to backup and restore your PostgreSQL instances from one central server (EnterpriseDB Backup and Recovery Tool (BART), getting started with postgres plus(…)

Converting a column from one data type to another in PostgreSQL

Last week at a customer the following question came up: We have a varchar2 column in Oracle that contains a date but actually is stored as a string. When we want to convert this column to be a real date(…)

Can I do it with PostgreSQL? – 9 – Temporary tables

It has been quite a while since the last posts in this series, so here is what we looked at until now: Can I do it with PostgreSQL? – 1 – Restore points Can(…)

From PostgreSQL 9.1.8 to PostgreSQL 9.5.5 including a standby database with minimal downtime

As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one(…)

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