Chapter 6. Defining a Metadata Catalog Connection (define_catalog_connection)
Execute the following command:
SELECT metastore.define_catalog_connection('host', 'port', 'database', 'username', 'password');
Where:
hostandport: The hostname and port number of the server with the metadata catalog.database: The name of the database where the metadata catalog is initialized.usernameandpassword: 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.
For more detailed instructions, refer to Section 37.1.