没有合适的资源?快使用搜索试试~ 我知道了~
首页PostgreSQL实用手册:2015版90实战配方
PostgreSQL实用手册:2015版90实战配方
需积分: 9 79 下载量 189 浏览量
更新于2024-07-22
收藏 2.16MB PDF 举报
《Packt.PostgreSQL.Cookbook.2015》是一本专为PostgreSQL技术爱好者编写的实用指南,由Chitij Chauhan撰写。这本书提供了超过90个实战菜谱,旨在帮助读者有效地管理、配置和设计基于PostgreSQL的解决方案。PostgreSQL是一款开源的对象关系型数据库管理系统,以其稳定性和可扩展性在大数据和云计算领域受到广泛认可。 书中涵盖了丰富的主题,包括但不限于数据存储与检索、数据库设计优化、事务处理、并发控制、查询优化、性能调优、备份与恢复、数据库安全以及与各种编程语言(如Python、Java、PHP)的集成等。每个“配方”都包含详细的步骤和解释,使得即使是初学者也能通过实际操作快速上手并提升技能。 版权方面,该书受到2015年Packt Publishing的版权保护,未经出版商事先书面许可,不得复制、存储或通过任何形式进行传播,除非用于学术引用或评论。尽管作者和出版社已尽最大努力确保信息的准确性,但书中提供的所有内容都是无保修的,不承担因本书直接或间接导致的任何损害。 此外,Packt Publishing在书中尽可能地提及了涉及的所有公司和产品的商标信息,但无法对此类信息的准确性提供绝对保证。《PostgreSQL Cookbook》首次出版于2015年1月,反映了当时的技术趋势和最佳实践,适合希望深入探索PostgreSQL技术的专业人士和开发者使用,无论他们是寻求入门知识还是寻求解决特定问题的新策略。通过阅读这本书,读者可以掌握PostgreSQL的核心功能,并将其应用到实际项目中,提升工作效率和数据库管理能力。
资源详情
资源推荐
Preface
3
f Win32 OpenSSL v1.0.1
f pgAdmin v1.18.1
f PostgreSQL v.9.3
f Oracle Solaris Version 10
f CentOS Linux Version 6 or higher
Who this book is for
This book is for system administrators, database administrators, architects, developers,
and anyone with an interest in planning, managing, and designing database solutions using
PostgreSQL. This book is ideal for you if you have some prior experience with any relational
database or with the SQL language.
Sections
This book contains the following sections:
Getting ready
This section tells us what to expect in the recipe, and describes how to set up any software or
any preliminary settings needed for the recipe.
How to do it…
This section contains the steps required to follow the recipe.
How it works…
This section usually consists of a detailed explanation of what happened in the previous section.
There's more…
This section consists of additional information about the recipe in order to make the reader
more knowledgeable about the recipe.
See also
This section provides helpful links to other useful information for the recipe.
Preface
4
Conventions
In this book, you will nd a number of styles of text that distinguish between different kinds of
information. Here are some examples of these styles, and explanations of their meanings.
Code words in text, database table names, folder names, lenames, le extensions,
pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "The rst
method relies on using the CREATE DATABASE SQL statement."
A block of code is set as follows:
SELECT name, setting, unit ,(source = 'default') as is_default
FROM pg_settings WHERE context = 'sighup'
AND (name like '%delay' or name like '%timeout')
AND setting != '0';
Any command-line input or output is written as follows:
pg_ctl -D /var/lib/pgsql/data reload
New terms and important words are shown in bold. Words that you see on the screen, in
menus or dialog boxes for example, appear in the text like this: "In the New Inbound Rule
Wizard dialog box, click on the Protocol and Ports option, then click on the radio buttons,
as shown in the following screenshot, and nally click on the Next button."
Warnings or important notes appear in a box like this.
Tips and tricks appear like this.
Reader feedback
Feedback from our readers is always welcome. Let us know what you think about this
book—what you liked or may have disliked. Reader feedback is important for us to develop
titles that you really get the most out of.
To send us general feedback, simply send an e-mail to feedback@packtpub.com, and
mention the book title via the subject of your message.
If there is a topic that you have expertise in and you are interested in either writing or
contributing to a book, see our author guide on www.packtpub.com/authors.
Preface
5
Customer support
Now that you are the proud owner of a Packt book, we have a number of things to help you to
get the most from your purchase.
Downloading the example code
You can download the example code les for all Packt books you have purchased from your
account at http://www.packtpub.com. If you purchased this book elsewhere, you can
visit http://www.packtpub.com/support and register to have the les e-mailed directly
to you.
Errata
Although we have taken every care to ensure the accuracy of our content, mistakes do happen.
If you nd a mistake in one of our books—maybe a mistake in the text or the code—we would be
grateful if you could report this to us. By doing so, you can save other readers from frustration
and help us improve subsequent versions of this book. If you nd any errata, please report them
by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on
the Errata Submission Form link, and entering the details of your errata. Once your errata are
veried, your submission will be accepted and the errata will be uploaded to our website or
added to any list of existing errata under the Errata section of that title.
To view the previously submitted errata, go to https://www.packtpub.com/books/
content/support and enter the name of the book in the search eld. The required
information will appear under the Errata section.
Piracy
Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt,
we take the protection of our copyright and licenses very seriously. If you come across any
illegal copies of our works, in any form, on the Internet, please provide us with the location
address or website name immediately so that we can pursue a remedy.
Please contact us at copyright@packtpub.com with a link to the suspected pirated material.
We appreciate your help in protecting our authors, and our ability to bring you valuable content.
Questions
You can contact us at questions@packtpub.com if you are having a problem with any
aspect of the book, and we will do our best to address it.
1
Managing Databases
and the PostgreSQL
Server
In this chapter, we will cover the following recipes:
f Creating databases
f Creating schemas
f Creating users
f Creating groups
f Destroying databases
f Creating and dropping tablespaces
f Moving objects between tablespaces
f Initializing a database cluster
f Starting the server
f Stopping the server
f Displaying the server status
f Reloading the server conguration les
f Terminating connections
剩余285页未读,继续阅读
DoomLord
- 粉丝: 114
- 资源: 1318
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 最优条件下三次B样条小波边缘检测算子研究
- 深入解析:wav文件格式结构
- JIRA系统配置指南:代理与SSL设置
- 入门必备:电阻电容识别全解析
- U盘制作启动盘:详细教程解决无光驱装系统难题
- Eclipse快捷键大全:提升开发效率的必备秘籍
- C++ Primer Plus中文版:深入学习C++编程必备
- Eclipse常用快捷键汇总与操作指南
- JavaScript作用域解析与面向对象基础
- 软通动力Java笔试题解析
- 自定义标签配置与使用指南
- Android Intent深度解析:组件通信与广播机制
- 增强MyEclipse代码提示功能设置教程
- x86下VMware环境中Openwrt编译与LuCI集成指南
- S3C2440A嵌入式终端电源管理系统设计探讨
- Intel DTCP-IP技术在数字家庭中的内容保护
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功