define_catalog_connection)Execute the following command:
SELECT metastore.define_catalog_connection('host', 'port', 'database', 'username', 'password');
Where:
host and port:
The hostname and port number of the server with the metadata catalog.
database: The name of the database where
the metadata catalog is initialized.
username and password:
The username and password for connecting to the
server with the metadata catalog.
If one of these parameters is missing, for example, when connecting to the server with the metadata catalog without a user password, pass an empty string as a value.
Example 6.1.
SELECT metastore.define_catalog_connection('host', 'port','database','', '');
Reconnect to the pgpro_metastore server (not to the server with the metadata catalog) for the changes to take effect.