PostgreSQL Administration

Summary

This chapter presented numerous different administration options and features that are available to PostgreSQL DBAs. We first looked at the basics of starting and stopping your PostgreSQL server. We then walked through a number of different configuration options that are available to help tune your system. We took a look at tablespaces and discussed how using them could help you manage your disk activity. Finally, we examined a number of different database tasks that are common to PostgreSQL, including running VACUUM and ANALYZE, as well as how to go about upgrading between versions.

Armed with this information, you are now fully capable of maintaining your own PostgreSQL installation. The next few chapters enable you to expand upon this knowledge by showing you some of the tools available to help you interact with your PostgreSQL server, and by diving deeper into the features of PostgreSQL.