| Document Type
|
:
|
BL
|
| Record Number
|
:
|
946382
|
| Doc. No
|
:
|
b700752
|
| Main Entry
|
:
|
Riggs, Simon.
|
| Title & Author
|
:
|
PostgreSQL 9 administration cookbook : : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes /\ Simon Riggs, Hannu Krosing.
|
| Publication Statement
|
:
|
Birmingham, UK :: Packt Pub.,, 2010.
|
| Page. NO
|
:
|
1 online resource (345 pages)
|
| ISBN
|
:
|
1849510288
|
|
|
:
|
: 1849510296
|
|
|
:
|
: 9781849510288
|
|
|
:
|
: 9781849510295
|
| Contents
|
:
|
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?
|
|
|
:
|
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
|
|
|
:
|
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
|
|
|
:
|
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?
|
|
|
:
|
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
|
| Abstract
|
:
|
Over 80 recipes to help you run an efficient PostgreSQL 9.0 database.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Open source software.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
COMPUTERS-- Database Management-- General.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Open source software.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
PostgreSQL.
|
|
|
:
|
PostgreSQL.
|
|
|
:
|
PostgreSQL.
|
| Dewey Classification
|
:
|
005.7565
|
| LC Classification
|
:
|
QA76.9.D3R54 2010eb
|
| Added Entry
|
:
|
Krosing, Hannu.
|