Cargando…
PostgreSQL 9 administration cookbook : over 150 recipes to help you run an efficient PostgreSQL database in the cloud /
Through example-driven recipes, with plenty of code, focused on the most vital features of the latest PostgreSQL version (9.4), both administrators and developers will follow short, specific guides to understand and leverage useful Postgre functionalities to create better and more efficient database...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
2015.
|
| Edición: | Second edition. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Getting PostgreSQL; Connecting to the PostgreSQL server; Enabling access for network/remote users; Using graphical administration tools; Using the 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?
- Locating the database server filesLocating the database server's message log; Locating the database's system identifier; Listing 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?; Quickly estimating the number of rows in a table; Listing extensions in this database; Understanding object dependencies; Chapter 3: Configuration; Introduction; Reading The Fine Manual (RTFM); Planning a new database; Changing parameters in your programs.
- Finding the current configuration settingsWhich parameters are at nondefault settings?; Updating the parameter file; Setting parameters for particular groups of users; The basic server configuration checklist; Adding an external module to PostgreSQL; Using an installed module; Managing installed extensions; 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 only one session eachPushing users off the system; Deciding on a design for multitenancy; Using multiple schemas; Giving users their own private database; Running multiple servers on one system; Setting up a connection pool; Accessing multiple servers using the same host and port; Chapter 5: Tables and Data; Introduction; Choosing good names for database objects; Handling objects with quoted names; Enforcing the same name and definition for columns; Identifying and removing duplicates; Preventing duplicate rows; Finding a unique key for a set of data; Generating test data.
- Randomly sampling dataLoading data from a spreadsheet; Loading data from flat files; Chapter 6: Security; Introduction; The PostgreSQL superuser; Revoking user access to a table; Granting user access to a table; Creating a new user; Temporarily preventing a user from connecting; Removing a user without dropping their data; Checking whether all users have a secure password; Giving limited superuser powers to specific users; Auditing DDL changes; Auditing data changes; Always knowing which user is logged in; Integrating with LDAP; Connecting using SSL.