4. Install the Informatica clients. 5. Complete the post-installation tasks. 6. Install drivers, additional utilities, and product documentation. Note: The pre-installation and post-installation tasks differ based on the product you install. If you install more than one Informatica product, complete the Informatica platform steps one time, and ... create extension "uuid-ossp"^ create or replace function newid() returns uuid as 'select uuid_generate_v1();' language sql^ Then re-create the database (to ensure it is empty), and restart Tomcat. So the solution is to load an existing extension - as you suggested.
uuid-ossp. The uuid-ossp extension provides functions to generate universally unique identifiers (UUIDs) and also functions to produce certain special UUID constants. The easiest way to install it is to copy the files from an existing PostgreSQL installation into Yugabyte, and then create the extension.
How to use PostgreSQL extensions. PostgreSQL extensions must be installed in your database before you can use them. To install a particular extension, run the CREATE EXTENSION command. This command loads the packaged objects into your database. Azure Database for PostgreSQL supports a subset of key extensions as listed below.