Registering PostgreSQL as a service on Windows with pg_ctl
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.
VirtualBox vs. hardware for PostgreSQL
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.
pg_service.conf: The forgotten config file
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.
Permissions: A little trickery
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
Managing backup speed with pg_basebackup
How to adjust backup speed when using pg_basebackup in PostgreSQL. What if the I/O capacity of servers is low & network bandwidth is large?
walbouncer: Filtering the transaction log
You might not want to replicate all data to your standbys. walbouncer can filter the transaction log, & replicate only the data needed.
pg_resetxlog: renamed to pg_resetwal
pg_resetxlog was formerly a feature of PostgreSQL. This has been renamed to pg_resetwal, see the update in the blog.
wal_level: What is the difference?
PostgreSQL replication requires changing the wal_level from “minimal” to “hot_standby”. What er the impacts? Read out more.
max_connections - Performance impacts
Setting max_connections to an insanely high value is not good for performance. I tried it, to see what impact it has in PostgreSQL.
Detecting fraud: Benford's law
Benford's law is a mechanism, which is widely used in many fields. Especially accounting fraud can be detected nicely using this simple law of mathematics.
