2: Exploring the Database in Software Draw QR Code 2d barcode in Software 2: Exploring the Database

2: Exploring the Database generate, create qr codes none on software projects upc 31 32 33 34 36 4 Software qrcode 0 43 45 46 47 48 49 53. Table of Contents 3: Configuration Introduction Rea ding 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 file Setting parameters for particular groups of users Basic server configuration checklist Adding an external module to PostgreSQL Running server in power saving mode 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 database Running multiple servers on one system Set up a Connection Pool 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. 57 58 59 60 62 6 Software Quick Response Code 3 65 66 67 68 70. 4: Server Control 73 74 75 76 76 7 Software QRCode 8 80 81 83 84 85 88 89 91. 5: Tables & Data 95 96 97 99 103 QR Code for None 106 112 114 117 119 122. Table of Contents 6: Security Introduction Rev oking 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 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 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 Adding/Removing schemas Moving objects between schemas Adding/Removing tablespaces Moving objects between tablespaces Accessing objects in other PostgreSQL databases Making views updateable Introduction Is the user connected What are they running Are they active or blocked Who is blocking them Killing a specific session Resolving an in-doubt prepared transaction Is anybody using a specific table When did anybody last use it How much disk space is used by temporary data Why are my queries slowing down . 125 126 128 130 Software qr codes 131 133 134 136 139 140 144 145 147 153 154 156 158 163 165 168 170 171 174 177 182 189 193 194 196 198 199 201 201 203 205 208. 7: Database Administration 8: Monitoring and Diagnosis Table of Contents Investigating and reporting a bug Producing a daily summary of logfile errors 210 212. 9: Regular Maintenance Introduction Con trolling automatic database maintenance Avoiding auto freezing and page corruptions Avoiding transaction wraparound Removing old prepared transactions Actions for heavy users of temporary tables Identifying and fixing bloated tables and indexes Maintaining indexes Finding the unused indexes Carefully removing unwanted indexes Planning maintenance Introduction Finding slow SQL statements Collecting regular statistics from pg_stat* views Finding what makes SQL slow Reducing the number of rows returned Simplifying complex SQL Speeding up queries without rewriting them Why is my query not using an index How do I force a query to use an index Using optimistic locking Reporting performance problems Introduction Understanding and controlling crash recovery Planning backups Hot logical backup of one database Hot logical backup of all databases Hot logical backup of all tables in a tablespace Backup of database object definitions Standalone hot physical database backup Hot physical backup & Continuous Archiving Recovery of all databases Recovery to a point in time Recovery of a dropped/damaged table Recovery of a dropped/damaged tablespace. 215 216 221 222 qr bidimensional barcode for None 225 227 229 233 236 238 239 241 242 245 246 250 251 257 260 261 263 265 267 268 270 272 274 276 277 278 280 283 286 288 291.
Copyright © . All rights reserved.