I could make good use of the “slow time” around the turn of the year and managed to push out another set of features for our Open Source PostgreSQL monitoring tool called pgwatch2 – so a quick overview on changes in this post. Continuing the tradition, I’m calling it “Feature Pack 4” as it’s mostly […]

Security is an important topic. This is not only true in the PostgreSQL world – it holds truth for pretty much any modern IT system. Databases, however, have special security requirements. More often than not confidential data is stored and therefore it makes sense to ensure that data is protected properly. Security first! PostgreSQL: Listing […]

pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple cookbook how to configure user authentication with pgbouncer. I wrote this cookbook using Fedora Linux and installed pgbouncer using the PGDG Linux RPM packages available from the download site. But it should work pretty similarly anywhere.   What is […]

I once received a mail with question: Can you tell me why I can’t select the column `references`?   Well, the quick answer will be: because REFERENCES is a keyword you should use double quotes around it, e.g. =# select references from v_table_relation; But why do you sometimes need to explicitly quote identifiers and sometimes […]