Discover how to design, develop, and maintain your database application effectively with PostgreSQL About This BookUnderstand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologiesA hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architectsThe book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.Who This Book Is ForThis book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.What You Will Learn Compile PostgreSQL from source and understand the PostgreSQL architecture Configure parameters and change default settings for a PostgreSQL server Leverage the logging mechanism to identify errors and suboptimal queries Use replication to scale horizontally Set up backup.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.