Part VIII. Appendixes
Prev UpPostgres Pro Enterprise 17.7.1 DocumentationHome Next

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 Enterprise 17.7.1
E.2. Postgres Pro Enterprise 17.6.1
E.3. Postgres Pro Enterprise 17.5.1
E.4. Postgres Pro Enterprise 17.4.1
E.5. Postgres Pro Enterprise 17.2.2
E.6. Postgres Pro Enterprise 17.2.1
E.7. Release 17.7
E.8. Release 17.6
E.9. Release 17.5
E.10. Release 17.4
E.11. Release 17.3
E.12. Release 17.2
E.13. Release 17.1
E.14. Release 17
E.15. Prior Releases
F. Additional Supplied Modules and Extensions Shipped in postgrespro-ent-17-contrib
F.1. amcheck — tools to verify table and index consistency
F.2. aqo — cost-based query optimization
F.3. auth_delay — pause on authentication failure
F.4. auto_dump — get data and reproduce problematic queries
F.5. auto_explain — log execution plans of slow queries
F.6. basebackup_to_shell — example "shell" pg_basebackup module
F.7. basic_archive — an example WAL archive module
F.8. biha — built-in high-availability cluster
F.9. bloom — bloom filter index access method
F.10. btree_gin — GIN operator classes with B-tree behavior
F.11. btree_gist — GiST operator classes with B-tree behavior
F.12. citext — a case-insensitive character string type
F.13. cube — a multi-dimensional cube data type
F.14. daterange_inclusive — upper bound-inclusive daterange
F.15. dbcopies_decoding — 1C module for updating database copies
F.16. dblink — connect to other Postgres Pro databases
F.17. dbms_lob — operate on large objects
F.18. dict_int — example full-text search dictionary for integers
F.19. dict_xsyn — example synonym full-text search dictionary
F.20. dump_stat — functions to backup and recover the pg_statistic table
F.21. earthdistance — calculate great-circle distances
F.22. fasttrun — a transaction unsafe function to truncate temporary tables
F.23. file_fdw — access data files in the server's file system
F.24. fulleq — an additional equivalence operator for compatibility with Microsoft SQL Server
F.25. fuzzystrmatch — determine string similarities and distance
F.26. hstore — hstore key/value datatype
F.27. Hunspell Dictionaries Modules
F.28. hypopg — support for hypothetical indexes
F.29. in_memory — store data in shared memory using tables implemented via FDW
F.30. intagg — integer aggregator and enumerator
F.31. intarray — manipulate arrays of integers
F.32. isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
F.33. jsquery — a language to query jsonb data type
F.34. lo — manage large objects
F.35. ltree — hierarchical tree-like data type
F.36. mchar — additional data types for compatibility with Microsoft SQL Server
F.37. multimaster — synchronous cluster to provide OLTP scalability and high availability
F.38. online_analyze — update statistics after INSERT, UPDATE, DELETE, SELECT INTO, or COPY operations
F.39. pageinspect — low-level inspection of database pages
F.40. passwordcheck — verify password strength
F.41. pg_buffercache — inspect Postgres Pro buffer cache state
F.42. pgcrypto — cryptographic functions
F.43. pg_freespacemap — examine the free space map
F.44. pgpro_application_info — port applications using DBMS_APPLICATION_INFO package
F.45. pgpro_bfile — a composite type to access an external file
F.46. pg_proaudit — enables detailed logging of various security events
F.47. pgpro_autopart — dynamic partition creation
F.48. pgpro_bindump — a replication protocol module for backup and restore
F.49. pgpro_cpumeter — a CPU usage monitoring system function
F.50. pg_prewarm — preload relation data into buffer caches
F.51. pgpro_gbtree — global index on a partitioned table
F.52. pgpro_ilm — enables moving rarely used relations to a lower-cost storage
F.53. pgpro_queue — message queueing management
F.54. pgpro_rp — resource prioritization
F.55. pgpro_scheduler — scheduling, monitoring and managing job execution
F.56. pgpro_sfile — storage for large objects
F.57. pgpro_usage — per-user statistics on relations and functions
F.58. pg_query_state — a facility to know the current state of query execution on working backend
F.59. pgrowlocks — show a table's row locking information
F.60. pg_stat_statements — track statistics of SQL planning and execution
F.61. pgstattuple — obtain tuple-level statistics
F.62. pg_surgery — perform low-level surgery on relation data
F.63. pg_transfer — quick transfer of tables between instances
F.64. pg_trgm — support for similarity of text using trigram matching
F.65. pg_trgm_mchar — trigram-based search for similar mchar and mvarchar strings
F.66. pg_tsparser — an extension for text search
F.67. pg_variables — functions for working with variables of various types
F.68. pg_visibility — visibility map information and utilities
F.69. pg_wait_sampling — collecting sampling-based statistics on wait events
F.70. pg_walinspect — low-level WAL inspection
F.71. plantuner — hints for the planner to disable or enable indexes for query execution
F.72. postgres_fdw — access data stored in external Postgres Pro servers
F.73. proxima — a combination of a proxy and a connection pooler
F.74. ptrack — a block-level incremental backup engine for Postgres Pro
F.75. referee — manage quorum settings with an even number of nodes configured with multimaster
F.76. rum — an access method to work with the RUM indexes
F.77. seg — a datatype for line segments or floating point intervals
F.78. shared_ispell — a shared ispell dictionary
F.79. spi — Server Programming Interface features/examples
F.80. sslinfo — obtain client SSL information
F.81. tablefunc — functions that return tables (crosstab and others)
F.82. tcn — a trigger function to notify listeners of changes to table content
F.83. test_decoding — SQL-based test/example module for WAL logical decoding
F.84. tsm_system_rows — the SYSTEM_ROWS sampling method for TABLESAMPLE
F.85. tsm_system_time — the SYSTEM_TIME sampling method for TABLESAMPLE
F.86. unaccent — a text search dictionary which removes diacritics
F.87. uuid-ossp — a UUID generator
F.88. vops — support for vector operations
F.89. xml2 — XPath querying and XSLT functionality
G. Postgres Pro Modules and Extensions Shipped as Individual Packages
G.1. pgpro_anonymizer — mask or replace sensitive data
G.2. pgpro_datactl — manage Postgres Pro Enterprise data files
G.3. pgpro_multiplan — save query execution plans and prepared statements for future usage
G.4. pgpro_planner — additional query transformations and optimizations
G.5. pgpro_pwr — workload reports
G.6. pgpro_result_cache — save query results for reuse
G.7. pgpro_stats — a means for tracking planning and execution statistics of all SQL statements executed by a server
G.8. utl_http — access data on the Internet over the HTTP protocol
G.9. utl_mail — manage emails
G.10. utl_smtp — send emails over SMTP
G.11. TDE — enable page level encryption
H. Third-Party Modules and Extensions Shipped as Individual Packages
H.1. apache_age — graph database functionality
H.2. oracle_fdw — access to Oracle databases
H.3. pg_hint_plan — control an execution plan with hinting phrases
H.4. tds_fdw — connect to databases that use the TDS protocol
H.5. wal2json — convert WAL changes into JSON via logical decoding
I. Additional Supplied Programs
I.1. Additional PostgreSQL/Postgres Pro Client Applications
I.2. Third-Party Client Applications
I.3. Additional Postgres Pro Server Applications
I.4. Third-Party Server Applications
J. External Projects
J.1. Client Interfaces
J.2. Administration Tools
J.3. Procedural Languages
J.4. Extensions
J.5. citus — distributed database and columnar storage functionality
K. Configuring Postgres Pro for 1C Solutions
K.1. Configuring the Locale
K.2. Basic Server Requirements and Configuration
K.3. Configuring Server Parameters
K.4. Additional Modules
L. Migration Tools in Postgres Pro
L.1. Working with Packages
L.2. Package Export Using ora2pgpro
L.3. Script Parameters
M. Postgres Pro Limits
N. Demo Database “Airlines”
N.1. Installation
N.2. Schema Diagram
N.3. Schema Description
N.4. Schema Objects
N.5. Usage
O. Acronyms
P. Glossary
Q. Color Support
Q.1. When Color is Used
Q.2. Configuring the Colors
R. Obsolete or Renamed Features
R.1. recovery.conf file merged into postgresql.conf
R.2. Default Roles Renamed to Predefined Roles
R.3. pg_xlogdump renamed to pg_waldump
R.4. pg_resetxlog renamed to pg_resetwal
R.5. pg_receivexlog renamed to pg_receivewal
Prev Up Next
70.3. Backup Manifest WAL Range Object Home Appendix A. Postgres Pro Error Codes