PostgreSQL 11 Administration Cookbook

PostgreSQLisapowerful,opensourcedatabasemanagementsystemwithanenviablereputationforhighperformanceandstability.Withmanynewfeaturesinitsarsenal,PostgreSQL11allowsyoutoscaleupyourPostgreSQLinfrastructure.Thisbooktakesastep-by-step,recipe-basedapproachtoeffectivePostgreSQLadministration.Thebookwillintroduceyoutonewfeaturessuchaslogicalreplication,nativetablepartitioning,additionalqueryparallelism,andmuchmoretohelpyoutounderstandandcontrol,crashrecoveryandplanbackups.Youwilllearnhowtotackleavarietyofproblemsandpainpointsforanydatabaseadministratorsuchascreatingtables,managingviews,improvingperformance,andsecuringyourdatabase.Asyoumakesteadyprogress,thebookwilldrawattentiontoimportanttopicssuchasmonitoringroles,backup,andrecoveryofyourPostgreSQL11databasetohelpyouunderstandrolesandproduceasummaryoflogfiles,ensuringhighavailability,concurrency,andreplication.Bytheendofthisbook,youwillhavethenecessaryknowledgetomanageyourPostgreSQL11databaseefficiently.