Search results for: postgresql-up-and-running-3e

PostgreSQL Up and Running

Author : Regina O. Obe
File Size : 44.45 MB
Format : PDF, ePub, Docs
Download : 766
Read : 515
Download »
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e. If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before. Learn basic administration tasks such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with foreign data wrappers Learn how to use built-in replication to replicate data

PostgreSQL

Author : Regina Obe
File Size : 24.40 MB
Format : PDF, ePub
Download : 130
Read : 192
Download »
"A practical guide to the Advanced Open Source Database"--Cover.

Puppet 5 Essentials

Author : Martin Alfke
File Size : 62.74 MB
Format : PDF, Kindle
Download : 214
Read : 295
Download »
A Guide to managing servers and automation About This Book Breeze through Puppet's key features and performance improvements to bring real advantages to your IT infrastructure Discover Puppet best practices to help you avoid common mistakes and pitfalls Examples to help you get to grips with Puppet and succeed with everyday IT automation Who This Book Is For This book targets experienced IT professionals and new Puppet uses, who will learn all they need to know to go from installation to advanced automation. Get a rapid introduction to the essential topics and learn how to build best practices for advanced automation with Puppet. What You Will Learn Understand declarative configuration management Make use of GIT-based deployment workflows Extend Factor with secure elements Create modular and reusable Puppet code Extend your code base with publicly available Puppet modules Separate logic from data by using Hiera Understand and develop Puppet Roles and Profiles In Detail Puppet is a configuration management tool that allows you to automate all your IT configurations, giving you control over what you do to each Puppet Agent in a network, and when and how you do it. In this age of digital delivery and ubiquitous Internet presence, it's becoming increasingly important to implement scaleable and portable solutions, not only in terms of software, but also the system that runs it. This book gets you started quickly with Puppet and its tools in the right way. It highlights improvements in Puppet and provides solutions for upgrading. It starts with a quick introduction to Puppet in order to quickly get your IT automation platform in place. Then you learn about the Puppet Agent and its installation and configuration along with Puppet Server and its scaling options. The book adopts an innovative structure and approach, and Puppet is explained with flexible use cases that empower you to manage complex infrastructures easily. Finally, the book will take readers through Puppet and its companion tools such as Facter, Hiera, and R10k and how to make use of tool chains. Style and approach This book aims to impart all the knowledge required to tap into not only the basics of Puppet, but also its core. The basic ideas and principles of Puppet-based designs are explored and explained. Sophisticated tools are presented to enable you to use Puppet efficiently and productively.