Learn?Exploreyourdatabaseanddiscoverwhereyourserverfilesandservermessagelogsarestored,howmuchdiskspaceyourdatabaseisusing,andwhatyourobjectdependenciesare?Advancedtechnicaltipsandscriptsforexperiencedusers?Addorremovenewcolumns,schemas,ortablespaces?MoveyourobjectsbetweentablespacesandaccesstheminotherPostgreSQLdatabases?BestpracticeforplanninganddesigninglivedatabasesAboutPostgreSQLisapowerful,opensource,enterprisedatabase.ThisPostgreSQL9AdministrationCookbookLITEbookdescribeskeyaspectsofthePostgreSQLopensourcedatabasesystem.ThebookwillhelpasysadminorDBAtogetstartedwithkeyadministrationissuesinPostgreSQL,goingfromaninitialconnectiontoaserver,findingoutaboutwhereyourserverstoresvitalinformation,toremoving,adding,ormovingobjectsandchangingdatabaseschema.Thishands-onguidewillassistdevelopersworkingonlivedatabasessupportingweborenterprisesoftwareapplications.Tofindoutmoreaboutupgradingtothefulledition,visitwww.packtpub.com/lite-editionsandlogintoyouraccountforoffersandhelp.Ifyoudon’thaveanaccountonPacktPub.com,visittodayandsetoneup!Features?LearnthebasicsofworkingwithPostgreSQL;connecttoaserver,explorethedatabase,andadjustthesizeofyourdatabasetothespaceavailable.?Amendyourdatabasewiththeadditionorremovalofcolumns,schemasandtablespaces?PartofPackt'sCookbookseries:Eachrecipeisacarefullyorganizedsequenceofinstructionstocompletethetaskasefficientlyaspossible