没有合适的资源?快使用搜索试试~ 我知道了~
首页[PostgreSQL:Up.and.Running(2012.7)].Regina.Obe.文字版.pdf
[PostgreSQL:Up.and.Running(2012.7)].Regina.Obe.文字版.pdf

[PostgreSQL:Up.and.Running(2012.7)].Regina.Obe.文字版.pdf 最近要学习一下这个数据库,放在这里备份。
资源详情
资源评论
资源推荐



PostgreSQL: Up and Running
Regina Obe and Leo Hsu
Beijing
•
Cambridge
•
Farnham
•
Köln
•
Sebastopol
•
Tokyo

PostgreSQL: Up and Running
by Regina Obe and Leo Hsu
Copyright © 2012 Regina Obe and Leo Hsu. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions
are also available for most titles (http://my.safaribooksonline.com). For more information, contact our
corporate/institutional sales department: 800-998-9938 or corporate@oreilly.com.
Editor: Meghan Blanchette
Production Editor: Iris Febres
Proofreader: Iris Febres
Cover Designer: Karen Montgomery
Interior Designer: David Futato
Illustrator: Rebecca Demarest
Revision History for the First Edition:
2012-07-02 First release
See http://oreilly.com/catalog/errata.csp?isbn=9781449326333 for release details.
Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of
O’Reilly Media, Inc. PostgreSQL: Up and Running, the image of the elephant shrew, and related trade
dress are trademarks of O’Reilly Media, Inc.
Many of the designations used by manufacturers and sellers to distinguish their products are claimed as
trademarks. Where those designations appear in this book, and O’Reilly Media, Inc., was aware of a
trademark claim, the designations have been printed in caps or initial caps.
While every precaution has been taken in the preparation of this book, the publisher and authors assume
no responsibility for errors or omissions, or for damages resulting from the use of the information con-
tained herein.
ISBN: 978-1-449-32633-3
[LSI]
1341247831

Table of Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
1. The Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Where to Get PostgreSQL 1
Notable PostgreSQL Forks 1
Administration Tools 2
What’s New in Latest Versions of PostgreSQL? 3
Why Upgrade? 4
What to Look for in PostgreSQL 9.2 4
PostgreSQL 9.1 Improvements 5
Database Drivers 5
Server and Database Objects 6
Where to Get Help 8
2. Database Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Configuration Files 9
The postgresql.conf File 10
The pg_hba.conf File 12
Reload the Configuration Files 14
Setting Up Groups and Login Roles (Users) 14
Creating an Account That Can Log In 15
Creating Group Roles 15
Roles Inheriting Rights 15
Databases and Management 16
Creating and Using a Template Database 16
Organizing Your Database Using Schemas 16
Permissions 17
Extensions and Contribs 18
Installing Extensions 19
Common Extensions 21
Backup 22
iii
剩余163页未读,继续阅读


















安全验证
文档复制为VIP权益,开通VIP直接复制

评论3