PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

One important requirement of this recipe is that we know where certain PostgreSQL binaries are found. Locate the directory where PostgreSQL binaries are installed—for example, most Debian-based systems use /usr/lib/postgresql/12/bin while Red Hat systems use /usr/pgsql-12/bin instead.

One way to do this is to obtain the information from the package manager itself. Debian systems can use this command to find PostgreSQL binaries:

dpkg -L postgresql-12 | grep bin

Red Hat and similar systems can use this command instead:

rpm -ql postgresql12 | grep bin

Other package managers may have different methods of collecting this information.