Configuring UNIFYBroker/Plus for use with PostgreSQL

Before following the instructions on this page, ensure that UNIFYBroker has been configured for use with PostgreSql as detailed here.

Creating the PostgreSQL Database

Log onto the PostgreSQL server with pgAdmin or via the command line tool and connect to the existing UNIFYBroker database. Ensure the UNIFYBroker database is being targeted and run the UNIFYBroker/Plus Install PostgreSQL script which is located at <InstallDir>/Database/Plus Install PostgreSql.sql.

If the PostgreSQL server user account name is not the default postgres, then the above install script will need to be edited to reflect this. Open the SQL script in a text editor and replace all instances of postgres with the correct account name. Note that if the database is hosted on an Azure Database for PostgreSQL server which displays the account name as <name>@<server> then only the name component preceding the @ symbol should be used in the script.