Watch command - how to watch a PostgreSQL database
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.
UNIX sockets vs. localhost: PostgreSQL Performance advice
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
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.
