Index

A

• access
  • controlling, via firewalls / Controlling access via firewalls, How to do it..., How it works...
  • controlling, via configuration files / Controlling access via configuration files, How to do it..., There's more…
• ACID (Atomicity, Consistency, Isolation, Durability) / Creating databases
• active sessions
  • creating / Checking active sessions, There's more...
  • pid column / How it works...
  • datname column / How it works...
  • application_name column / How it works...
  • client_addr column / How it works...
  • client_hostname column / How it works...
  • query column / How it works...
  • state column / How it works...
• archive_command parameter / How it works...
• archive_mode parameter / How it works...
• asymmetric encryption / Encrypting confidential data
• auto freeze
  • preventing / Preventing auto freeze and page corruption, How it works...
• autovacuum
  • about / Controlling automatic database maintenance, How to do it...
• autovacuum, parameters
  • log_autovacuum_min_duration / There's more...
  • autovacuum_max_workers / There's more...
  • autovacuum_vacuum_threshold / There's more...
  • autovacuum_analyze_threshold / There's more...
  • autovacuum_vacuum_scale_factor / There's more...
  • autovacuum_analyze_scale_factor / There's more...
  • autovacuum_freeze_max_age / There's more...
  • autovacuum_vacuum_cost_delay / There's more...
• autovacuum launcher / How it works...
• autovacuum_analyze_scale_factor parameter / There's more...
• autovacuum_analyze_threshold parameter / There's more...
• autovacuum_freeze_max_age parameter / There's more...
• autovacuum_max_workers parameter / There's more...
• autovacuum_vacuum_cost_delay parameter / There's more...
• autovacuum_vacuum_scale_factor parameter / There's more...
• autovacuum_vacuum_threshold parameter / There's more...

B

• backend connections
  • terminating, URL / There's more...
• backend_data_directory0 parameter / How it works...
• backend_hostname0 parameter / How it works...
• backend_port0 parameter / How it works...
• backend_weight0 parameter / How it works...
• base backup
  • taking / Taking a base backup, How it works...
• bloating tables
  • about / Dealing with bloating tables and indexes, How to do it..., How it works...
• blocking sessions
  • finding / Finding blocking sessions, How it works...
• Bucardo
  • used, for setting up replication / Replication using Bucardo, How to do it..., How it works...
  • version 5.2.0, URL / Getting ready
  • URL / How it works...

C

• checkpoint_segments parameter / How it works...
• check_postgres script
  • URL / There's more...
• confidential data
  • encrypting / Encrypting confidential data, How to do it..., How it works..., There's more...
• configuration files
  • used, for controlling access / Controlling access via configuration files, How to do it..., There's more…
• connect function
  • URL / How it works..., How it works...
• connection
  • pooling, pgbouncer used / Connection pooling using pgbouncer, How to do it..., There's more...
  • making to PostgreSQL database, Perl used / Making a connection to a PostgreSQL database using Perl, How it works...
  • making to PostgreSQL database, Python used / Making connections to a PostgreSQL database using Python, How it works...
• connections
  • terminating / Terminating connections, There's more...
• connection_cache parameter / How it works...
• constraint exclusion
  • about / Partitioning and constraint exclusion, How it works...
• CPU bottlenecks
  • identifying / Identifying CPU bottlenecks, How it works...
• CPU usage
  • monitoring / Monitoring CPU usage, How it works...

D

• data
  • monitoring / Monitoring data and index pages, How to do it...
  • upgrading, pg_dump used / Using pg_dump to upgrade data, How to do it...
• data, replicating
  • from other databases to PostgreSQL, GoldenGate used / Replicating data from other databases to PostgreSQL using GoldenGate, Getting ready, How to do it..., How it works...
• database
  • destroying / Destroying databases, There's more...
  • about / Introduction
  • objects, securing / Securing database objects, How it works...
  • changes, auditing / Auditing database changes, How to do it..., There's more...
  • restoring / Restoring databases and specific database objects, How it works...
• database cluster
  • initializing / Initializing a database cluster, How it works...
  • initializing, URL / How it works...
• database load
  • monitoring / Monitoring database load, How it works...
• databases
  • creating / Creating databases, How to do it..., How it works...
  • monitoring / Introduction
• data node / How it works...
• dead rows / Preventing auto freeze and page corruption
• dearmor function / How it works...
• disk
  • usage, determining / Determining disk usage, There's more...
• disk I/O bottlenecks
  • identifying / Identifying disk I/O bottlenecks, How it works...
• disk space usage
  • monitoring / Monitoring disk space usage, How it works...
• disk usage
  • URL / How it works...
• DRBD
  • used, for setting up replication / Replication using DRBD, How to do it..., How it works...

E

• EnterpriseDB
  • URL / Getting ready
• EXPLAIN command
  • generic mode / How to do it...
  • analyze mode / How to do it...
  • verbose mode / How to do it...
• explain plan
  • getting, for SQL statement / Getting the execution plan for a statement, How to do it..., How it works...

F

• -F switch / Getting ready
• file system level backup
  • about / File system level backup, How it works..., There's more...
• firewalls
  • used, for controlling access / Controlling access via firewalls, How to do it..., How it works...
• frozen rows / Preventing auto freeze and page corruption
• F switches / Getting ready

G

• GoldenGate
  • about / Introduction
  • used, for replicating data from other databases to PostgreSQL / Replicating data from other databases to PostgreSQL using GoldenGate, Getting ready, How to do it..., How it works...
  • used for Oracle database, URL / Getting ready
• groups
  • creating / Creating groups, There's more...
• GTM / How it works...

H

• historical CPU load
  • examining / Examining historical CPU load, How it works...
• historical memory load
  • examining / Examining historical memory load, How to do it...
• hot physical backup
  • about / Hot physical backup and continuous archiving, How to do it..., How it works...
• hot streaming replication
  • setting up / Setting up hot streaming replication, How to do it...
  • listen_addresses parameter / How it works...
  • wal_level parameter / How it works...
  • wal_keep_segments parameter / How it works...
  • archive_mode parameter / How it works...
  • archive_command parameter / How it works...
  • max_wal_senders parameter / How it works...
  • checkpoint_segments parameter / How it works...
  • hot_standby parameter / How it works...
  • standby_mode parameter / How it works...
  • primary_conninfo parameter / How it works...
  • trigger_file parameter / How it works...
• hot_standby parameter / How it works...

I

• indexes
  • about / Dealing with bloating tables and indexes, How to do it..., How it works...
• index pages / How to do it...
• initdb command / How to do it...

L

• leaf fragmentation / How to do it...
• listen_addresses parameter / How it works..., How it works...
• load average / How it works...
• load_balance_on parameter / How it works...
• log files
  • maintaining / Maintaining log files, How to do it...
• logical backup
  • of single PostgreSQL database / A logical backup of a single PostgreSQL database, How to do it..., How it works...
  • of all PostgreSQL databases / A logical backup of all PostgreSQL databases, How it works..., There's more...
  • of specific objects / A logical backup of specific objects, How it works...
• logical backups
  • about / Introduction
• log_autovacuum_min_duration parameter / There's more...
• Londiste
  • used, for setting up replication / Replication using Londiste, How to do it..., How it works...
  • URL / How it works...
• LVM (logical volume manager) / There's more...

M

• mailing list
  • performance, URL / There's more...
• master/slave streaming replication
  • setting up / How to do it...
• master_slave_mode parameter / How it works...
• max_pool parameter / How it works...
• max_wal_senders parameter / How it works...
• mpstat command / How to do it...
• multi version concurrency control (MVCC) / Creating databases
• mutual exclusion lock (mutex) / How it works...
• MVCC (multiversion concurrency control) / Preventing transaction ID wraparound failures

N

• network status
  • monitoring / Monitoring network status, How it works...

O

• objects
  • moving, between tablespaces / Moving objects between tablespaces, How to do it...
• Oracle 11g software
  • used, for reinstalling on Linux platform, URL / Getting ready

P

• paging
  • monitoring / Monitoring paging and swapping, How to do it..., How it works...
• partitioning
  • about / Introduction
  • implementing / Implementing partitioning, How to do it..., How it works...
  • URL / There's more, There's more
  • managing / Managing partitions, How to do it..., How it works...
  • and constraint exclusion / Partitioning and constraint exclusion, How it works...
  • alternate methods / Alternate partitioning methods, How to do it..., How it works...
  • with PL/Proxy / Getting ready, How to do it..., How it works...
• passwords, PostgreSQL
  • creacking / Cracking PostgreSQL passwords, How to do it..., How it works...
  • brute force method / How it works...
  • dictionary attack method / How it works...
• Perl
  • about / Introduction
  • PostgreSQL, accessing from / Introduction
  • used, for creating tables / Creating tables using Perl, How to do it..., How it works...
  • used, for inserting tables / Getting ready, How it works...
  • used, for accessing table data / Accessing table data using Perl, How to do it..., How it works...
  • used, for updating records / Updating records using Perl, How to do it..., How it works...
  • used, for deleting records / Getting ready, How to do it..., How it works...
• pgbouncer
  • setting / Setting up pgbouncer, How it works...
  • used, for connection pooling / Connection pooling using pgbouncer, How to do it..., How it works...
  • URL / There's more...
  • managing / Managing pgbouncer, How to do it..., How it works...
  • SHOW CLIENTS command / How it works...
  • SHOW SERVERS command / How it works...
  • SHOW POOLS command / How it works...
  • SHOW STATS command / How it works...
• pgbouncer utility / Introduction
• pgpool
  • installing / Installing pgpool, How it works...
  • URL / Getting ready, How it works..., How it works...
  • configuring / Configuring pgpool and testing the setup, How to do it..., How it works...
  • setup, testing / Configuring pgpool and testing the setup, How to do it..., How it works...
  • listen_addresses parameter / How it works...
  • port parameter / How it works...
  • backend_hostname0 parameter / How it works...
  • backend_port0 parameter / How it works...
  • backend_weight0 parameter / How it works...
  • backend_data_directory0 parameter / How it works...
  • connection_cache parameter / How it works...
  • max_pool parameter / How it works...
  • replication_mode parameter / How it works...
  • load_balance_on parameter / How it works...
  • master_slave_mode parameter / How it works...
  • starting / Starting and stopping pgpool, How it works...
  • stopping / How it works...
• pgpool, stopping modes
  • smart mode / How it works...
  • fast mode / How it works...
• pgpool-II utility / Introduction
• pgp_key_id function / How it works...
• pgp_pub_decrypt function / How it works...
• pgp_pub_encrypt function / How it works...
• pg_dump
  • used, for upgrading data / Using pg_dump to upgrade data, How to do it..., How it works...
• pg_restore utility / How it works...
• pg_upgrade utility
  • used, for upgrading version / Using the pg_upgrade utility for a version upgrade, How to do it..., How it works...
• physical backups
  • about / Introduction
• PL/Proxy
  • installing / Installing PL/Proxy, How it works...
  • installing, steps / How to do it...
  • partitioning with / Partitioning with PL/Proxy, How to do it..., How it works...
  • URL / There's more
• planner statistics
  • updating / Updating planner statistics, How it works...
• point-in-time recovery
  • about / Point-in-time recovery, How to do it..., How it works...
• port parameter / How it works...
• Postgres-XC cluster
  • setting up / Setting up the Postgres-XC cluster, How to do it..., How it works...
  • URL / Getting ready
  • GTM / How it works...
  • coordinator / How it works...
  • data node / How it works...
• PostgreSQL
  • about / Introduction
  • installing on CentOS, URL / Getting ready
  • installing on Ubuntu platform, URL / Getting ready
  • SSL, enabling / Enabling SSL in PostgreSQL, How it works..., There's more...
  • passwords, cracking / Cracking PostgreSQL passwords, How to do it..., How it works...
  • URL / How it works...
  • Wiki links / There's more...
• PostgreSQL cluster
  • upgrading, URL / How it works...
• PostgreSQL database
  • single PostgreSQL database, logical backup / A logical backup of a single PostgreSQL database, How to do it..., How it works...
  • all PostgreSQL database, logical backup / A logical backup of all PostgreSQL databases, How it works..., There's more...
• PostgreSQL driver
  • URL / How to do it...
• PostgreSQL repository
  • URL / Getting ready
• Pretty Good Privacy (PGP) compatible encryption / How it works...
• primary_conninfo parameter / How it works...
• process
  • upgrading, URL / How it works...
• Python
  • about / Introduction
  • used, for making connections to PostgreSQL database / Making connections to a PostgreSQL database using Python, How it works...
  • used, for creating tables / Creating tables using Python, How to do it..., How it works...
  • used, for inserting records / Getting ready, How it works...
  • used, for accessing table data / How to do it..., How it works...
  • used, for updating records / Getting ready, How to do it..., How it works...
  • used, for deleting records / Getting ready, How to do it..., How it works...

Q

• queries
  • about / Finding out what queries users are currently running, How it works...
• query
  • forcing, to use index / Forcing a query to use an index, How to do it..., How it works...

R

• records
  • inserting, Perl used / Inserting records using Perl, How to do it..., How it works...
  • updating, Perl used / Updating records using Perl, How to do it..., How it works...
  • deleting, Perl used / Deleting records using Perl, How to do it..., How it works...
  • updating, Python used / Inserting records using Python, How it works..., Updating records using Python, How to do it..., How it works...
  • deleting, Python used / Deleting records using Python, How to do it..., How it works...
• REINDEX command / How it works...
• remote connectivity
  • testing / Testing remote connectivity, How it works...
• replication
  • setting up, Slony used / Replication using Slony-I, How to do it..., How it works..., There's more...
  • setting up, Londiste used / Replication using Londiste, How to do it..., How it works...
  • setting up, Bucardo used / Replication using Bucardo, How to do it..., How it works...
  • setting up, DRBD used / Replication using DRBD, How to do it..., How it works...
• replication_mode parameter / How it works...
• routine
  • reindexing / Routine reindexing, How to do it..., There's more...

S

• sar command / How it works...
• sar output / How it works...
• schemas
  • creating / Creating schemas
• Secure Sockets Layer (SSL) / Enabling SSL in PostgreSQL
• server
  • starting / Starting the server, How to do it...
  • stopping / Stopping the server, How it works..., There's more...
  • status, displaying / Displaying the server status, How it works...
  • configuration files, reloading / Reloading the server configuration files, How it works...
• server firewall / Controlling access via firewalls
• SHOW CLIENTS command
  • about / How it works...
  • user / How it works...
  • database / How it works...
  • state / How it works...
  • connect_time / How it works...
  • request_time / How it works...
  • port / How it works...
• SHOW POOLS command
  • cl_active / How it works...
  • cl_waiting / How it works...
  • sl_active / How it works...
  • sl_idle / How it works...
  • sl_used / How it works...
• SHOW SERVERS output
  • user / How it works...
  • database / How it works...
  • state / How it works...
  • connect_time / How it works...
  • request_time / How it works...
  • port / How it works...
• SHOW STATS command
  • total_requests / How it works...
  • total_received / How it works...
  • total_sent / How it works...
  • total_query_time / How it works...
• Skytools 3.2
  • URL / Getting ready
• Slony
  • used, for setting up replication / Replication using Slony-I, How to do it..., How it works..., There's more...
  • URL / Getting ready, How it works...
• slow statements
  • logging / Logging slow statements
  • logging_collector parameter / How it works...
  • log_directory parameter / How it works...
• SSL
  • enabling, in PostgreSQL / Enabling SSL in PostgreSQL, There's more...
  • encryption, testing / Testing SSL encryption, How it works...
• standby_mode parameter / How it works...
• statement
  • explain plan, getting / Getting ready, How to do it..., How it works...
• statistics
  • collecting / Collecting statistics, How it works...
• streaming replication
  • URL / How it works...
• swapping
  • monitoring / Getting ready, How to do it..., How it works...
• symmetric encryption / Encrypting confidential data
• sysid / Creating users
• system
  • worst user, finding / Finding the worst user on the system, How it works...
• system load
  • monitoring / Monitoring system load , How it works..., Monitoring system performance, How to do it..., How it works...

T

• table
  • accessing / Table access statistics , How it works...
  • creating, Perl used / Creating tables using Perl, How to do it..., How it works...
  • URL / How it works...
• table data
  • accessing, Perl used / Accessing table data using Perl, How to do it..., How it works...
• table data
  • accessing, Python used / Accessing table data using Python, How it works...
• tables
  • creating, Python used / Creating tables using Python, How to do it...
• tablespaces
  • creating / Creating and dropping tablespaces, How to do it..., There's more...
  • dropping / Creating and dropping tablespaces, How it works..., There's more...
  • objects, moving between / Moving objects between tablespaces, How to do it...
• transaction ID wraparound failures
  • preventing / Preventing transaction ID wraparound failures, How to do it...
• trigger_file parameter / How it works...

U

• -U switch / Getting ready
• unused indexes
  • finding / Finding unused indexes, How it works..., There's more…
  • URL / There's more…
• users
  • creating / Creating users, How it works..., There's more...
• U switches / Getting ready

V

• version
  • upgrading, pg_upgrade utility used / Using the pg_upgrade utility for a version upgrade, How to do it..., How it works...
• vmstat command / How to do it...

W

• wal_keep_segments parameter / How it works...
• wal_level parameter / How it works...
• web link
  • URL / How it works...
• write-ahead log (WAL) / How to do it...
• W switches / Getting ready