Chapter 1. Installing PostgreSQL
In this chapter, we will cover what can go wrong during the installation process and what can be done to avoid those things from happening. At the end of the chapter, you should be able to avoid all of the pitfalls, traps, and dangers you might face during the setup process.
For this chapter, I have compiled some of the core problems that I have seen over the years, as follows:
Deciding on a version during installation
Memory and kernel issues
Preventing problems by adding checksums to your database instance
Wrong encodings and subsequent import errors
Polluted template databases
Killing the postmaster badly
At the end of the chapter, you should be able to install PostgreSQL and protect yourself against the most common issues popping up immediately after installation.