PostgreSQL 9 Admin Cookbook - Riggs, Sim.epub - (EPUB全文下载)
文件大小:0.73 mb。
文件格式:epub 格式。
书籍内容:
Table of Contents
PostgreSQL 9 Administration Cookbook
Credits
About the Authors
About the Reviewers
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. First Steps
Introduction
Introducing PostgreSQL 9
What makes PostgreSQL different?
Getting PostgreSQL
How to do it...
How it works...
There's more...
Connecting to PostgreSQL server
Getting ready
How to do it...
How it works...
Inspecting your connection information
See also
Enabling access for network/remote users
How to do it...
How it works...
There's more...
See also
Using graphical administration tools
How to do it...
How it works...
There's more...
See also
Using psql query and scripting tool
Getting ready
How to do it...
How it works...
There's more...
See also
Changing your password securely
How to do it...
How it works...
Avoiding hardcoding your password
Getting ready
How to do it...
How it works...
There's more...
Using a connection service file
How to do it...
How it works...
Troubleshooting a failed connection
How to do it...
There's more...
2. Exploring the Database
Introduction
What version is the server?
How to do it...
How it works...
There's more...
What is the server uptime?
How to do it...
How it works...
See Also
Locate the database server files
Getting ready
How to do it...
How it works...
There's more...
Locate the database server message log
Getting ready
How to do it...
How it works...
Getting ready
How to do it...
How it works...
There's more...
List databases on this database server?
How to do it...
How it works...
There's more...
How many tables in a database?
How to do it...
How it works...
There's more...
How much disk space does a database use?
How to do it...
How it works...
How much disk space does a table use?
How to do it...
How it works...
There's more...
Which are my biggest tables?
How to do it...
How many rows in a table?
How to do it...
How it works...
Quick estimate of the number of rows in a table
How to do it...
How it works...
There's more...
Function 1
Function 2
Understanding object dependencies
Getting ready
How to do it...
How it works...
There's more...
3. Configuration
Introduction
Reading the Fine Manual (RTFM)
How to do it...
How it works...
There's more...
Planning a new database
Getting ready
How to do it...
How it works...
There's more...
Changing parameters in your programs
How to do it...
How it works...
There's more...
What are the current configuratio ............
书籍插图:
以上为书籍内容预览,如需阅读全文内容请下载EPUB源文件,祝您阅读愉快。
书云 Open E-Library » PostgreSQL 9 Admin Cookbook - Riggs, Sim.epub - (EPUB全文下载)