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.
