万本电子书0元读

万本电子书0元读

顶部广告

PostgreSQL 9 Administration Cookbook: LITE Edition电子书

售       价:¥

15人正在读 | 0人评论 9.8

作       者:Simon Riggs

出  版  社:Packt Publishing

出版时间:2011-05-19

字       数:86.9万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases.
目录展开

PostgreSQL Administration Cookbook: LITE

Table of Contents

PostgreSQL Administration Cookbook: LITE

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...

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. Database Administration

Introduction

Writing a script that either all succeeds or all fails

How to do it...

How it works...

There's more...

Writing a psql script that exits on first error

Getting ready

How to do it...

How it works...

There's more...

Performing actions on many tables

Getting ready

How to do it...

How it works...

There's more...

Using pg_batch to run tasks in parallel

Adding/Removing the columns of a table

How to do it...

How it works...

There's more...

Changing datatype of a column

Getting ready

How to do it...

How it works...

There's more...

Adding/Removing schemas

How to do it...

There's more...

Schema-level privileges

Moving objects between schemas

How to do it...

How it works...

There's more...

Adding/Removing tablespaces

Getting ready

How to do it...

How it works...

There's more...

Putting pg_xlog on a separate device

Tablespace-level tuning

Moving objects between tablespaces

Getting ready

How to do it...

How it works...

There's more...

Accessing objects in other PostgreSQL databases

Getting ready

How to do it...

How it works...

There's more...

See also

Making views updateable

Getting ready

How to do it...

How it works...

There's more...

Index

累计评论(0条) 1个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部