Traveling in time(lines) with pg_rewind
At 9.5 pg_rewind was introduced, with this feature it was possible to make a server that is no longer master to follow a promoted standby that has a new timeline. There are at least a few use cases that could benefit from this…
Adding columns with default value fast
I recently came across a discussion in #postgresql channel about how to add a new column that will represent record insert timestamps to a table with minimal locking.Normally you would do something like this :monkey=# alter table alter_test add column…
Custom Postgres installation with Docker
Lately, i wanted to make a new test / lab environment that would be dispensable, fast to deploy and easily customisable. VM's are all nice for lab use and they served me well over the years, but they tend to…
Repairing clog corruptions
Yesterday, i got a page from a client about a possible corruption issue to one of his clients, so i decided to share how i dealt with it. Before starting with how i approached the problem, i want to say…