PostgreSQL 9 administration cookbook : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes /
Riggs, Simon.
PostgreSQL 9 administration cookbook : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes / Simon Riggs, Hannu Krosing. - Birmingham, UK : Packt Pub., 2010. - 1 online resource (345 pages)
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.
9781849510288 (electronic bk.) 1849510288 (electronic bk.) 9781849510295 (electronic bk.) 1849510296 (electronic bk.)
CL0500000096 Safari Books Online
018011917 Uk
PostgreSQL.
PostgreSQL.
PostgreSQL.
Database management.
SQL (Computer program language)
Open source software.
Bases de données--Gestion.
SQL (Langage de programmation)
Logiciels libres.
COMPUTERS--Database Management--General.
Database management.
Open source software.
SQL (Computer program language)
Electronic books.
Handbooks and manuals.
QA76.9.D3 / R54 2010eb
005.7565
681.3.06
PostgreSQL 9 administration cookbook : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes / Simon Riggs, Hannu Krosing. - Birmingham, UK : Packt Pub., 2010. - 1 online resource (345 pages)
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.
9781849510288 (electronic bk.) 1849510288 (electronic bk.) 9781849510295 (electronic bk.) 1849510296 (electronic bk.)
CL0500000096 Safari Books Online
018011917 Uk
PostgreSQL.
PostgreSQL.
PostgreSQL.
Database management.
SQL (Computer program language)
Open source software.
Bases de données--Gestion.
SQL (Langage de programmation)
Logiciels libres.
COMPUTERS--Database Management--General.
Database management.
Open source software.
SQL (Computer program language)
Electronic books.
Handbooks and manuals.
QA76.9.D3 / R54 2010eb
005.7565
681.3.06