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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2006 W. Jason Gilmore
About this chapter
Cite this chapter
(2006). PostgreSQL Administration. In: Beginning PHP and PostgreSQL 8. Apress. https://doi.org/10.1007/978-1-4302-0136-6_26
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0136-6_26
Publisher Name: Apress
Print ISBN: 978-1-59059-547-3
Online ISBN: 978-1-4302-0136-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books