Month: January 2019
Major feature update for the pgwatch2 Postgres monitoring tool
By Kaarel Moppel – 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 […]
pg_permissions: Inspecting your PostgreSQL security system
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! This blog […]
pgbouncer authentication made easy
UPDATED August 2023 pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple cookbook recipe for 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 […]
Keyword mess
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 […]