Chapter 19. Installing Postgres Pro AXE
On servers prepared for your deployment scenario:
Important
You must always install, configure, and create pgpro_axe before pgpro_metastore.
To install Postgres Pro AXE:
Install the Postgres Pro DBMS from the distribution.
For more information, refer to the Postgres Pro technical support.
Install pgpro_axe and pgpro_metastore:
Install the pgpro_axe and pgpro_metastore packages received from Postgres Pro.
Add the library names
pgpro_axeandpgpro_metastoreto theshared_preload_librariesvariable in thepostgresql.confconfiguration file, separated by a comma:shared_preload_libraries = 'pgpro_axe, pgpro_metastore'
Configure pgpro_axe parameters as required.
Example 19.1. Minimal pgpro_axe configuration
duckdb.unsafe_allow_execution_inside_functions = on duckdb.force_execution = false duckdb.max_memory = '16GB' duckdb.threads = 2 duckdb.max_workers_per_postgres_scan = 2 duckdb.threads_for_postgres_scan = 2 metastore.detailed_error_log = false duckdb.convert_unsupported_numeric_to_double = true
Create pgpro_axe and pgpro_metastore in the database:
CREATE EXTENSION pgpro_axe; CREATE EXTENSION pgpro_metastore;