PL/Proxy on PostgreSQL 11 and FreeBSD 12
PL/Proxy is a procedural language implementation that makes really easy to do database proxying, and sharding as a consequence. Unluckily getting it to run on PostgreSQL 11 and FreeBSD 12 is not for free.
written sometime in August 2019
|
The Most Ancient (running) System I Logged Into
A few days ago I had to log in a foreign Unix system, and I was astonished at the command prompt!
written sometime in July 2019
|
yum upgrade postgresql11 panic!
I have to say, I don’t use CentOS very much and I’m not a good user of systemd, that is the reason why I got five minutes of pure fear!
written sometime in July 2019
|
Checking PostgreSQL Version in Scripts
psql(1) has a bar support for conditionals, that can be used to check PostgreSQL version and act accordingly in scripts.
written sometime in July 2019
|
Suggesting Single-Column Primary Keys (almost) Automatically
Is it possible to infer primary keys automatically? If it, I’m not able at doing that, but at least I can try.
written sometime in July 2019
|