PostgreSQL 9 Administration Cookbook
Connecting to PostgreSQL server
Enabling access for network/remote users
Using psql query and scripting tool
Changing your password securely
Avoiding hardcoding your password
Using a connection service file
Troubleshooting a failed connection
Locate the database server files
Locate 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?
Quick estimate of the number of rows in a table
Understanding object dependencies
Reading the Fine Manual (RTFM)
Changing parameters in your programs
What are the current configuration settings?
Which parameters are at non-default settings?
Setting parameters for particular groups of users
Basic server configuration checklist
Adding an external module to PostgreSQL
Running server in power saving mode
Starting the database server manually
Stopping the server safely and quickly
Stopping the server in an emergency
Reloading the server configuration files
Restricting users to just one session each
Deciding on a design for multi-tenancy
Giving users their own private database
Running multiple servers on one system
Choosing good names for database objects
Handling objects with quoted names
Enforcing same name, same column definition
Identifying and removing duplicates
Finding a unique key for a set of data
Loading data from a spreadsheet
Revoking user access to a table
Granting user access to a table
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
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
Moving objects between schemas
Moving objects between tablespaces
Accessing objects in other PostgreSQL databases
Resolving an in-doubt prepared transaction
Is anybody using a specific table?
How much disk space is used by temporary data?
Why are my queries slowing down?
Investigating and reporting a bug
Producing a daily summary of logfile errors
Controlling 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
Carefully removing unwanted indexes
Collecting regular statistics from pg_stat* views
Reducing the number of rows returned
Speeding up queries without rewriting them
Why is my query not using an index?
How do I force a query to use an index
Reporting performance problems
Understanding and controlling crash recovery
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 a dropped/damaged table
Recovery of a dropped/damaged tablespace
Recovery of a dropped/damaged database
Improving performance of backup/restore
Incremental/Differential backup and restore
Understanding replication concepts
File-based log-shipping replication
Setting up streaming log replication
Managing log shipping replication
Selective replication using Londiste
Selective replication using Slony 2.0