Upgrading PostgreSQL to 9.4

Preface

In 9.4 there is a logical decoding which would allow to upgrade from 9.4 to 9.5 quiet cheap (at least it shoud be so). But right now upgrading major version of PostgreSQL is painful. In most common case it looks like that:

  1. Stop master and call …
more ...

HTTPS

Went 2015 year, everyone moves their services from HTTP to HTTPS. And because cool guys from StartSSL give valid certificates for free, I have decided to make the site be accessible through https. Since I would need to generate static content with pelican twice (for http and https) I have …

more ...

PostgreSQL 9.4 and pg_repack

We have workflows with storing cooling UGC-data in DB. The older the data is, the less likely it is asked. We partition tables with such data by date and eventually move data from SSD-disks to SATA. It gives us very good hardware savings. PostgreSQL has built-in support for …

more ...

Redesign

Finally I have found time to taste static content generators. And after some testing I have chosen pelican. So far I’m very satisfied. Let’s see what happens.

By the way, sources of the current site version could be found on github.

more ...

Pgcheck and delayed replics

Two months ago we announced pgcheck - a tool for automatic load control on PostgreSQL databases using PL/Proxy. Today we have fixed all found issues about one new feature - pgcheck can now account replication delays and not to route queires on delayed replics.

Sources and some more info could be …

more ...