Postgres Pro AXE 1.1.0 Documentation
				Next

Postgres Pro AXE
1.1.0 Documentation

Postgres Professional

Copyright © 2016–2026 The Postgres Professional company

Table of Contents

I. Overview

1. Key Advantages
2. Main Compontents
3. Business Scenarios

II. Quick Start

4. Installing Postgres Pro AXE
5. Configuring the Postgres Pro AXE Administrator
6. Defining a Metadata Catalog Connection (define_catalog_connection)
7. Initializing the Metadata Catalog (init)
8. Creating a Simple Secret (duckdb.create_simple_secret)
9. Creating an S3 Storage (metastore.add_storage)
10. Typical Commands for Working with the OLAP Data

III. Deployment

11. OLAP Data Processing Scenarios
12. Deployment Scenarios
13. Hardware and Software Requirements
14. Capacity Planning
15. Identifying User Groups and Usage Scenarios
16. Organizing Stored Procedures
17. Planning the Scalability of Compute Resources
18. Providing High Availability
19. Installing Postgres Pro AXE
20. Retrieving the pgpro_metastore Build Number (metastore.pgpro_build)
21. Updating and Deleting Postgres Pro AXE

IV. Administration

22. Access Management
23. Secrets
24. Storages
25. Analytical Tables
26. Columns
27. Analytical Schemas
28. Shared Directories
29. OLAP Data
30. Hive Partitioning
31. Configuring the Transaction Horizon

V. pgpro_axe

32. Functions
33. Supported Extensions
34. Configuration Parameters
35. Transactions
36. Syntax

VI. pgpro_metastore

37. Configuring the Metadata Catalog
38. Metadata Tables
39. Reading Metadata
40. Configuring Objects Visibility

VII. Appendixes

A. Release Notes
B. Glossary
C. Benchmark Test Results
D. Examples of Snapshot Usage
E. About OLTP and OLAP Workloads
F. Data Types

		Next
		Part I. Overview