Cargando…
PostgreSQL 9 administration cookbook : solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes /
Over 80 recipes to help you run an efficient PostgreSQL 9.0 database.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn702117134 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 110216s2010 enk of 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d E7B |d UMI |d OCLCQ |d COO |d HEBIS |d OCLCQ |d DEBSZ |d OCLCQ |d DKDLA |d YDXCP |d OCLCQ |d OCLCF |d OCLCQ |d JBG |d AGLDB |d CNNOR |d MOR |d PIFAG |d OCLCQ |d AL5MG |d OCLCO |d OCL |d U3W |d BRL |d STF |d WRM |d VTS |d CEF |d NLE |d INT |d VT2 |d UKMGB |d OCLCQ |d OCLCO |d AU@ |d OCLCQ |d A6Q |d M8D |d OCLCO |d UKAHL |d HS0 |d UKCRE |d OCLCQ |d OCLCO |d OCLCQ | ||
| 016 | 7 | |a 018011917 |2 Uk | |
| 019 | |a 741519880 |a 961519804 |a 962602553 |a 988474376 |a 992072162 |a 1037524138 |a 1038641977 |a 1055398037 |a 1058571129 |a 1081259072 |a 1083605650 |a 1103256719 |a 1129353040 |a 1152973528 |a 1153501999 |a 1228615647 | ||
| 020 | |a 9781849510288 |q (electronic bk.) | ||
| 020 | |a 1849510288 |q (electronic bk.) | ||
| 020 | |a 9781849510295 |q (electronic bk.) | ||
| 020 | |a 1849510296 |q (electronic bk.) | ||
| 029 | 1 | |a AU@ |b 000053272803 | |
| 029 | 1 | |a CHNEW |b 000610372 | |
| 029 | 1 | |a DEBBG |b BV043127790 | |
| 029 | 1 | |a DEBSZ |b 36847707X | |
| 029 | 1 | |a DEBSZ |b 372803687 | |
| 029 | 1 | |a DEBSZ |b 421647647 | |
| 029 | 1 | |a HEBIS |b 286047640 | |
| 029 | 1 | |a HEBIS |b 291544061 | |
| 029 | 1 | |a NZ1 |b 14170386 | |
| 029 | 1 | |a UKMGB |b 018011917 | |
| 035 | |a (OCoLC)702117134 |z (OCoLC)741519880 |z (OCoLC)961519804 |z (OCoLC)962602553 |z (OCoLC)988474376 |z (OCoLC)992072162 |z (OCoLC)1037524138 |z (OCoLC)1038641977 |z (OCoLC)1055398037 |z (OCoLC)1058571129 |z (OCoLC)1081259072 |z (OCoLC)1083605650 |z (OCoLC)1103256719 |z (OCoLC)1129353040 |z (OCoLC)1152973528 |z (OCoLC)1153501999 |z (OCoLC)1228615647 | ||
| 037 | |a CL0500000096 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b R54 2010eb | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 080 | |a 681.3.06 | ||
| 082 | 0 | 4 | |a 005.7565 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Riggs, Simon. | |
| 245 | 1 | 0 | |a PostgreSQL 9 administration cookbook : |b solve real-world PostgreSQL problems with over 100 simple, yet incredibly effective recipes / |c Simon Riggs, Hannu Krosing. |
| 260 | |a Birmingham, UK : |b Packt Pub., |c 2010. | ||
| 300 | |a 1 online resource (345 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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? | |
| 505 | 8 | |a 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? | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a Over 80 recipes to help you run an efficient PostgreSQL 9.0 database. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL. |2 blmlsh |
| 630 | 0 | 7 | |a PostgreSQL. |2 fast |0 (OCoLC)fst01394262 |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Open source software. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Logiciels libres. | |
| 650 | 7 | |a COMPUTERS |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 650 | 7 | |a Open source software. |2 fast |0 (OCoLC)fst01046097 | |
| 650 | 7 | |a SQL (Computer program language) |2 fast |0 (OCoLC)fst01102869 | |
| 655 | 7 | |a Handbooks and manuals. |2 fast |0 (OCoLC)fst01423877 | |
| 700 | 1 | |a Krosing, Hannu. | |
| 776 | 0 | 8 | |i Print version: |a Riggs, Simon. |t PostgreSQL 9 administration cookbook. |d Birmingham, UK : Packt Publishing, 2010 |z 9781849510288 |w (OCoLC)692145048 |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=350867 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH28576553 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26943604 | ||
| 938 | |a ebrary |b EBRY |n ebr10435415 | ||
| 938 | |a EBSCOhost |b EBSC |n 350867 | ||
| 938 | |a YBP Library Services |b YANK |n 3601852 | ||
| 994 | |a 92 |b IZTAP | ||