PostgreSQL 9 administration cookbook : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes / Simon Riggs, Hannu Krosing.

Print version record.

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?

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

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

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

Over 80 recipes to help you run an efficient PostgreSQL 9.0 database.

eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - Worldwide