没有合适的资源?快使用搜索试试~ 我知道了~
首页PostgreSQL Administration Cookbook 原版PDF by Riggs, Ciolli & Bartolini
PostgreSQL Administration Cookbook 原版PDF by Riggs, Ciolli & Bar...
需积分: 49 23 下载量 189 浏览量
更新于2023-05-25
收藏 4.28MB PDF 举报
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 projects, completely free to use, and developed by a very diverse worldwide community. Most of all, it just works!
资源详情
资源推荐
![](https://csdnimg.cn/release/download_crawler_static/10379951/bg1.jpg)
![](https://csdnimg.cn/release/download_crawler_static/10379951/bg2.jpg)
PostgreSQL Administration Cookbook
9.5/9.6 Edition
Effective database management using PostgreSQL 9.5/9.6
Simon Riggs
Gianni Ciolli
Gabriele Bartolini
BIRMINGHAM - MUMBAI
![](https://csdnimg.cn/release/download_crawler_static/10379951/bg3.jpg)
PostgreSQL Administration Cookbook
9.5/9.6 Edition
Copyright © 2017 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. However, the information contained in this book is sold without
warranty, either express or implied. Neither the authors, nor Packt Publishing, and its
dealers and distributors will be held liable for any damages caused or alleged to be 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.
First published: April 2017
Production reference: 1250417
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-78588-318-7
www.packtpub.com
![](https://csdnimg.cn/release/download_crawler_static/10379951/bg4.jpg)
Table of Contents
Preface
1
Chapter 1: First Steps
9
Introduction
9
Introducing PostgreSQL 9.6
9
What makes PostgreSQL different? 10
Robustness 12
Security 12
Ease of use 13
Extensibility 13
Performance and concurrency 14
Scalability 14
SQL and NoSQL 14
Popularity 15
Commercial support 15
Research and development funding 16
Getting PostgreSQL
16
How to do it...
16
How it works...
17
There's more...
17
Connecting to the PostgreSQL server
18
Getting ready
18
How to do it...
18
How it works...
19
There's more...
20
See also
21
Enabling access for network/remote users
21
How to do it...
21
How it works...
22
There's more...
24
See also
24
Using graphical administration tools
24
How to do it...
24
How it works...
27
See also
28
Using the psql query and scripting tool
28
Getting ready
29
![](https://csdnimg.cn/release/download_crawler_static/10379951/bg5.jpg)
[ ii ]
How to do it...
29
How it works...
31
There's more...
32
See also
32
Changing your password securely
33
How to do it...
33
How it works...
33
Avoiding hardcoding your password
34
Getting ready
34
How to do it...
34
How it works...
35
There's more...
35
Using a connection service file
36
How to do it...
36
How it works...
37
Troubleshooting a failed connection
37
How to do it...
37
There's more...
39
Chapter 2: Exploring the Database
40
Introduction
40
What version is the server?
41
How to do it...
41
How it works...
41
There's more...
42
What is the server uptime?
43
How to do it...
43
How it works...
44
See also
44
Locating the database server files
44
Getting ready
44
How to do it...
45
How it works...
46
There's more...
47
Locating the database server's message log
48
Getting ready
48
How to do it...
48
How it works...
49
There's more...
50
Locating the database's system identifier
51
剩余541页未读,继续阅读
![azw3](https://img-home.csdnimg.cn/images/20210720083646.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![](https://csdnimg.cn/release/wenkucmsfe/public/img/green-success.6a4acb44.png)