下载  >  开发技术  >  其它  > PostgreSQL 10 Administration Cookbook 无水印原版pdf

PostgreSQL 10 Administration Cookbook 无水印原版pdf 评分

PostgreSQL 10 Administration Cookbook 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络,如有侵权,请联系csdn管理员删除 查看此书详细信息请在美国亚马逊官网搜索此书
PostgresQL 10 Administration Cookbook Copyright o 2018 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews Every effort has been made in the preparation of this book to ensure the accuracy of the information presented owever, the information contained in this book is sold without warranty, either express or implied Neither the author(s), nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information Commissioning Editor: amey varangaonkar Acquisition Editor: Namrata patil Content Development Editor: Amrita noronha Technical Editor: Sneha hanchate Copy Editor: Safis Project Coordinator: Shweta Birwatkar Proofreader: Safis Editing Indexer: Pratik Shirodkar Graphics: isha Chirayil Production Coordinator: shraddha Falebhai First published April 2017 Production reference: 1070518 Published by Packt Publishing Ltd Livery place 35 Livery street Birmingham B 3 2PB, UK ISBN978-1-78847-492-4 www.packtpub.com Mapt mapt. io Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance our career. For more information please visit our website Why subscribe? Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals Improve your learning with Skill Plans built especially for you Get a free e Book or video every month Mapt is fully searchable Copy and paste, print, and bookmark content PacktPub. com Did you know that Packt offers e Book versions of every book published, with PDF and epubfilesavailableYoucanupgradetotheebookversionatwww.Packtpub.comandasa print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at service@packtpub com for more details Atwww.packtpub.comyoucanalsoreadacollectionoffreetechnicalarticlessignupfora range of free newsletters, and receive exclusive discounts and offers on packt books and books Contributors About the authors Simon riggs is the cto of 2ndQuadrant, having contributed to Postgre SqL as a major developer and committer for 14 years. He has written and designed features for replication, performance, BI, management, and security. Under his guidance, 2ndQuadrant is now a leading developer of open source PostgreSQL, serving hundreds of clients in USA, Europe, and worldwide. Simon is a frequent speaker at many conferences on PostgreSQL Futures. He has worked as a database architect for 30 years Gianni ciolli is the head of professional services at 2ndQuadrant PostgreSQL consultant, trainer, and speaker at many PostgresQl conferences in Europe and abroad since the last 10 years. He has a phd in mathematics from the university of florence. He has worked with free and open source software since the 1990s and is active in the community(Prato Linux User Group and italian PostgresQL Users Group). He lives in London with his son. His other interests include music, drama, poetry and athletics About the reviewer Sheldon Strauch is a 23-year veteran of software consulting at IBM, Sears, Ernst &z young, and Kraft Foods. Having a bachelor's degree in business administration, he leverages his technical skills to improve business self-awareness. He is interested in data gathering, management, and mining; maps and mapping, business intelligence; and application of data analysis. He is currently focusing on the development of data management and mining 8 at Enova International at Chicago. At his leisure, he enjoys performing arts, music, and traveling with his wife, marilyn Packt is searching for authors like you If you're interested in becoming an author for Packt, please visit authors. packtpub com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea Table of contents Preface Chapter 1: First Steps Introduction 1999 Introducing PostgreSQL 10 What makes PostgreSQL different? 10 Robustness Security Ease of use 2233 Extensibility Performance and concurrency 14 Scalability 14 SQL and NosQL Popularity 15 Commercial support Research and development funding 16 Getting Postgre SQL 16 How to do it How it works 67 There's more 17 Connecting to the PostgresQL server 18 Getting ready 18 How to do it 18 How it works 20 Theres more 21 See also 21 Enabling access for network/remote users 21 How to do it 22 How it works 22 Theres more 24 See also 24 Using graphical administration tools 24 How to do it 24 How it works 27 OmniDB 28 See also 30 Using the psql query and scripting tool 31 Getting ready 31 How to do it 31 How it works 33 There's more 34 Table of Contents See also 35 Changing your password securely 35 How to do it 35 How it works 35 Avoiding hardcoding your password 36 Getting ready 36 How to do it 37 How it works 37 Theres more 38 Using a connection service file 38 How to do it 39 Howⅰ t works Troubleshooting a failed connection 39 How to do it 40 There's more 41 Chapter 2: Exploring the Database 42 Introduction 42 What version is the server 43 How to do it 43 How it works 43 There's more 44 What is the server uptime? 45 How to do it 45 How it works 45 See also 46 Locating the database server files 46 Getting ready 46 How to do it How it works 44 68 There's more 49 Locating the database server's message log 50 Getting ready How to do 55 How it works 52 There's more 53 Locating the database's system identifier 53 Getting ready 53 How to do it 54 How it works 54 Listing databases on this database server 56 How to do it How it works 55 67 There's more 58 How many tables are there in a database? Table of Contents How to do it 59 How it works 60 There's more 61 How much disk space does a database use? How to do it 66 22 How it works 62 How much disk space does a table use? 62 How to do it 63 How it works 63 There' s more 64 Which are my biggest tables? 64 How to do it 64 How it works 65 How many rows are there in a table? How to do it 66 55 How it works 66 Quickly estimating the number of rows in a table 67 How to do it 67 How it works 68 There's more 68 Function 1 -Estimating the number of rows 70 Function 2-Computing the size of a table without locks 70 Listing extensions in this database 72 Getting ready 73 How to do it 73 How it works 73 Theres more 74 Understanding object dependencies 74 Getting read 74 How to do it 75 How it works There's more 75 Chapter 3: Configuration 77 ntroduction 77 Reading the fine manual 78 How to do it 78 How it works 7 89 There's more 79 Planning a new database 79 etting ready How to do it How it works 7888 0 0 There's more Changing parameters in your programs 81 Table of Contents How to do it 81 How it works 82 There's more 82 Finding the current configuration settings 83 How to do it 83 Theres more 85 How it works 85 Which parameters are at non-default settings? 85 How to do it 86 How it works 87 There's more 87 Updating the parameter file 87 Getting ready 88 How to do it 88 How it works 89 Theres more 89 Setting parameters for particular groups of users 90 How to do 90 How it works 91 The basic server configuration checklist 91 Getting ready 91 How to do it 92 There's more 92 Adding an external module to PostgreSQL 93 Getting ready 94 How to do it 95 Installing modules using a software installer 95 Installing modules from PGXN 96 Installing modules from a manually downloaded package 97 Installing modules from source code 97 How it works 98 Using an installed module 98 Getting ready 99 How to do it 99 How it works 100 Managing installed extensions 100 How to do 100 How it works 102 Theres more 103 Chapter 4: Server Control 104 Introduction 104 Starting the database server manually 105 Getting ready 106 How to do it 106

...展开详情
所需积分/C币:24 上传时间:2018-06-22 资源大小:4.28MB
举报 举报 收藏 收藏 (1)
分享 分享

评论 下载该资源后可以进行评论 1

freecap 内容丰富,比较实用!
2018-12-16
回复
PostgreSQL Cookbook.pdf

PostgreSQL Cookbook.pdf Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL

立即下载
PostgreSQL Administration Cookbook 原版PDF by Riggs, Ciolli & Bartolini

PostgreSQL is an advanced SQL database server, available on a wide range of platforms and is fast becoming one of the world's most popular server databases with an enviable reputation for performance, stability, and an enormous range of advanced features. PostgreSQL is one of the oldest open source

立即下载
PostgreSQL 10 Administration Cookbook源码

PostgreSQL 10 Administration Cookbook 书涉及源码分享

立即下载
postgresql 9 administrator cookbook 第二版源码

postgresql 9 cookbook 第二版源码,从官网下载的。没有postgresql10 cookbook 的源码全

立即下载
Mastering PostgreSQL 9.6 无水印pdf

Mastering PostgreSQL 9.6 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除

立即下载
Mastering PostgreSQL 10 Expert techniques on PostgreSQL administration 无水印原版pdf

Mastering PostgreSQL 10 Expert techniques on PostgreSQL 10 development and administration 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络,如有侵权,请联系csdn管理员删除 查看此书详细信息请在美国亚马逊官网搜索此书

立即下载
PostgreSQL 10 High Performance 无水印原版pdf

PostgreSQL 10 High Performance 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络,如有侵权,请联系csdn管理员删除 查看此书详细信息请在美国亚马逊官网搜索此书

立即下载
PostgreSQL 10.1中文手册

PostgreSQL 10.1手册》基于上一版本的《PostgreSQL9.6.0中文手册》 翻译。翻译工作主要由瀚高软件的韩悦悦完成,详细请参考 PostgreSQL 10.1中文手册的翻译。 如果发现中文手册中的问题请向Github源码仓库或PostgreSQL中文手册翻译小组QQ群(309292849)反馈,也可直接向Github源码仓库提交PR。

立即下载
PostgreSQL 9 Administration Cookbook(2nd) 无水印pdf

PostgreSQL 9 Administration Cookbook(2nd) 英文无水印pdf 第2版 pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除

立即下载
PostgreSQL Administration Cookbook 9.5, 9.6 Edition 无水印pdf

PostgreSQL Administration Cookbook 9.5, 9.6 Edition 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除

立即下载
PostgreSQL Cookbook 无水印pdf

PostgreSQL Cookbook 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除

立即下载
PostgreSQL 9 Administration Cookbook

Book Description Publication Date: October 26, 2010 Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can rea

立即下载
PostgreSQL 10 Administration Cookbook 1st

A practical guide to administer, monitor and replicate your PostgreSQL 10 database Key Features Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently Monitor, tune, secure and protect your database for optimal performance A step-by-step, recipe-based guid

立即下载
ModbusTCP/RTU网关设计

基于UIP协议栈,实现MODBUS联网,可参考本文档资料,有MODBUS协议介绍

立即下载
html+css+js制作的一个动态的新年贺卡

该代码是http://blog.csdn.net/qq_29656961/article/details/78155792博客里面的代码,代码里面有要用到的图片资源和音乐资源。

立即下载
iCopy解码软件v1.0.1.7.exe

解ic,id,hid卡密码破解ic,id,hid卡密码破解ic,id,hid破解ic,id,hid卡破解ic,id,hid卡密码密码卡密码破解ic,id,hid卡...

立即下载
分布式服务框架原理与实践(高清完整版)

第1章应用架构演进1 1.1传统垂直应用架构2 1.1.1垂直应用架构介绍2 1.1.2垂直应用架构面临的挑战4 1.2RPC架构6 1.2.1RPC框架原理6 1.2.2最简单的RPC框架实现8 1.2.3业界主流RPC框架14 1.2.4RPC框架面临的挑战17 1.3SOA服务化架构18 1.3.1面向服务设计的原则18 1.3.2服务治理19 1.4微服务架构21 1.4.1什么是微服务21 1.4.2微服务架构对比SOA22 1.5总结23 第2章分布式服务框架入门25 2.1分布式服务框架诞生背景26 2.1.1应用从集中式走向分布式.26?

立即下载
Camtasia 9安装及破解方法绝对有效

附件中注册方法亲测有效,加以整理与大家共享。 由于附件大于60m传不上去,另附Camtasia 9百度云下载地址。免费自取 链接:http://pan.baidu.com/s/1kVABnhH 密码:xees

立即下载
电磁场与电磁波第四版谢处方 PDF

电磁场与电磁波第四版谢处方 (清晰版),做天线设计的可以作为参考。

立即下载
压缩包爆破解密工具(7z、rar、zip)

压缩包内包含三个工具,分别可以用来爆破解密7z压缩包、rar压缩包和zip压缩包。

立即下载