عنوان
پدید آورنده
موضوع
رده
QA76.9.D3 R54 2010eb
QA76
.
9
.
D3
R54
2010eb
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1849510288
(Number (ISBN
1849510296
(Number (ISBN
9781849510288
(Number (ISBN
9781849510295
NATIONAL BIBLIOGRAPHY NUMBER
Number
b700752
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
PostgreSQL 9 administration cookbook :
General Material Designation
[Book]
Other Title Information
solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes /
First Statement of Responsibility
Simon Riggs, Hannu Krosing.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Birmingham, UK :
Name of Publisher, Distributor, etc.
Packt Pub.,
Date of Publication, Distribution, etc.
2010.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (345 pages)
CONTENTS NOTE
Text of Note
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 9; Getting PostgreSQL; Connecting to PostgreSQL server; Enabling access for network/remote users; Using graphical administration tools; Using psql query and scripting tool; Changing your password securely; Avoiding hardcoding your password; Using a connection service file; Troubleshooting a failed connection; Chapter 2: Exploring the Database; Introduction; What version is the server?; What is the server uptime?
Text of Note
Creating a new userTemporarily preventing a user from; connecting; Removing a user without dropping their data; Checking all users have a secure password; Giving limited superuser powers to specific; users; Auditing DDL changes; Auditing data changes; Integrating with LDAP; Connecting using SSL; Encrypting sensitive data; Chapter 7: Database Administration; Introduction; Writing a script that either all succeeds; or all fails; Writing a psql script that exits on first error; Performing actions on many tables; Adding/Removing the columns of a table; Changing datatype of a column
Text of Note
Giving users their own private databaseRunning multiple servers on one system; Set up a Connection Pool; Chapter 5: Tables & Data; Introduction; Choosing good names for database objects; Handling objects with quoted names; Enforcing same name, same column; definition; Identifying and removing duplicates; Preventing duplicate rows; Finding a unique key for a set of data; Generating test data; Randomly sampling data; Loading data from a spreadsheet; Loading data from flat files; Chapter 6: Security; Introduction; Revoking user access to a table; Granting user access to a table
Text of Note
Locate the database server filesLocate the database server message log; List databases on this database server?; How many tables in a database?; How much disk space does a database use?; How much disk space does a table use?; Which are my biggest tables?; How many rows in a table?; Quick estimate of the number of rows; in a table; Understanding object dependencies; Chapter 3: Configuration; Introduction; Reading the Fine Manual (RTFM); Planning a new database; Changing parameters in your programs; What are the current configuration settings?; Which parameters are at non-default; settings?
Text of Note
Updating the parameter fileSetting parameters for particular groups; of users; Basic server configuration checklist; Adding an external module to PostgreSQL; Running server in power saving mode; Chapter 4: Server Control; Introduction; Starting the database server manually; Stopping the server safely and quickly; Stopping the server in an emergency; Reloading the server configuration files; Restarting the server quickly; Preventing new connections; Restricting users to just one session each; Pushing users off the system; Deciding on a design for multi-tenancy; Using multiple schemas
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
Over 80 recipes to help you run an efficient PostgreSQL 9.0 database.
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
Safari Books Online
Stock Number
CL0500000096
OTHER EDITION IN ANOTHER MEDIUM
Title
PostgreSQL 9 administration cookbook.
International Standard Book Number
9781849510288
TITLE USED AS SUBJECT
PostgreSQL.
PostgreSQL.
PostgreSQL.
TOPICAL NAME USED AS SUBJECT
Database management.
Open source software.
SQL (Computer program language)
COMPUTERS-- Database Management-- General.
Database management.
Open source software.
SQL (Computer program language)
(SUBJECT CATEGORY (Provisional
COM-- 021000
UNIVERSAL DECIMAL CLASSIFICATION (UDC)
Number
681.3.06
DEWEY DECIMAL CLASSIFICATION
Number
005
.
7565
Edition
22
LIBRARY OF CONGRESS CLASSIFICATION
Class number
QA76
.
9
.
D3
Book number
R54
2010eb
PERSONAL NAME - PRIMARY RESPONSIBILITY
Riggs, Simon.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Krosing, Hannu.
ORIGINATING SOURCE
Date of Transaction
20201207163153.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
