28.1. Creating a Shared Directory (metastore.add_folder) #
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 22.1.
Execute the following command:
SELECT metastore.add_folder('shared_directory_name', 'storage_name', 'path_to_the_shared_directory');
Where:
shared_directory_name: The unique shared directory name.storage_name: The name of the storage where the shared directory is created.path_to_the_shared_directory: The path to the shared directory relative to the root directory of the storage.The specified shared directory must exist in the storage, but not in the
pga_foldermetadata table for this storage.
Postgres Pro AXE performs the following actions:
Verifies input parameters and user privileges.
Ensures that the specified path leads to an existing shared directory.
Creates a new entry in the
pga_foldermetadata table.
Example 28.1. Executing the metastore.add_folder stored procedure
SELECT metastore.add_folder('shared_directory_example', 'storage_example', '/relative_path');