Part VIII. Appendixes

Table of Contents

A. Postgres Pro Error Codes
B. Date/Time Support
B.1. Date/Time Input Interpretation
B.2. Handling of Invalid or Ambiguous Timestamps
B.3. Date/Time Key Words
B.4. Date/Time Configuration Files
B.5. POSIX Time Zone Specifications
B.6. History of Units
B.7. Julian Dates
C. SQL Key Words
D. SQL Conformance
D.1. Supported Features
D.2. Unsupported Features
D.3. XML Limits and Conformance to SQL/XML
E. Release Notes
E.1. Postgres Pro Shardman 17.5.1
E.2. Release 17.5
E.3. Release 17.4
E.4. Release 17.3
E.5. Release 17.2
E.6. Release 17.1
E.7. Release 17
E.8. Prior Releases
F. Additional Supplied Modules and Extensions Shipped in postgrespro-sdm-17-contrib
F.1. amcheck — tools to verify table and index consistency
F.2. aqo — cost-based query optimization
F.3. auto_explain — log execution plans of slow queries
F.4. dblink — connect to other Postgres Pro databases
F.5. pgcrypto — cryptographic functions
F.6. pg_proaudit — enables detailed logging of various security events
F.7. pgpro_stats — a means for tracking planning and execution statistics of all SQL statements executed by a server
F.8. pg_query_state — a facility to know the current state of query execution on working backend
F.9. pg_stat_statements — track statistics of SQL planning and execution
F.10. pg_wait_sampling — collecting sampling-based statistics on wait events
F.11. postgres_fdw — access data stored in external Postgres Pro servers
F.12. ptrack — a block-level incremental backup engine for Postgres Pro
F.13. uuid-ossp — a UUID generator
G. Postgres Pro Modules and Extensions Shipped as Individual Packages
G.1. pgpro_pwr — workload reports
H. Additional Supplied Programs
H.1. Additional PostgreSQL/Postgres Pro Client Applications
H.2. Additional Postgres Pro Server Applications
H.3. Third-Party Server Applications
I. External Projects
I.1. Client Interfaces
I.2. Administration Tools
I.3. Procedural Languages
I.4. Extensions
J. Postgres Pro Limits
K. Demo Database Airlines
K.1. Installation
K.2. Schema Diagram
K.3. Schema Description
K.4. Schema Objects
K.5. Usage
L. Acronyms
M. Glossary
N. Color Support
N.1. When Color is Used
N.2. Configuring the Colors
O. Obsolete or Renamed Features
O.1. recovery.conf file merged into postgresql.conf
O.2. Default Roles Renamed to Predefined Roles
O.3. pg_xlogdump renamed to pg_waldump
O.4. pg_resetxlog renamed to pg_resetwal
O.5. pg_receivexlog renamed to pg_receivewal