20.2. Deleting a Storage (metastore.remove_storage) #
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 18.1.
Execute the following command on the Postgres Pro AXE server:
SELECT metastore.remove_storage('storage_name');
Where storage_name is the name of the storage to delete.
Postgres Pro AXE performs the following actions:
Checks input parameters and user privileges.
Creates a new entry in the
pga_snapshotmetadata table and sets theend_snapshotfield for the storage in thepga_storagemetadata table.Sets the
end_snapshotfield for entries associated with the storage in other metadata tables.
Example 20.3. Executing the metastore.remove_storage Stored Procedure
SELECT metastore.remove_storage('storage_example');