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.init(force_init bool DEFAULT false)

If the metadata catalog is already initialized on the server, you receive a warning:

      postgres=# SELECT metastore.init();
      INFO:  Metastore catalog already initialized on remote server
      INFO:  Run metastore.init(true) to force rewrite catalog on remote server
      init
      ------

      (1 row)
      

In this case, you can reinitialize the metadata catalog by executing the same command with the force_init parameter set to true:

        postgres=# SELECT metastore.init(true);
        init
        ------

        (1 row)