Damn, my main USB stick died!
My main USB stick died, and while I had several backup copies, the damage was not zero!
pgenv get configuration!
I have already written about a very useful and powerful small pearl by theory: pgenv. Now the tool does support for user configuration!
Managing Multiple PostgreSQL Installations with pgenv
pgenv is a shell script that allows you to quickly manage multiple PostgreSQL installations within the same host. It reminds somehow perlbrew (for Perl 5) and systems like that. In this post I briefly show how to use pgenv as well as I explain which changes I made to it.
PostgreSQL negative PID
PostgreSQL uses a simple trick to recognize if the server has started in single-user mode.
An example of PostgreSQL rules: updating pg_settings
Rules are a powerful mechanism by which PostgreSQL allows a statement to be transformed into another. And PostgreSQL itself does use rules in order to make your life easier.
Luca Ferrari