Step 4 – WinCC OA Configuration

Create the WinCC OA schema in the PostgreSQL® database on the Patroni leader node. Then, create a WinCC OA project using NGA and set up the database connections.

1. Create the WinCC OA Schema in the PostgreSQL® Database

  1. On the Leader node of Patroni, which serves as the primary PostgreSQL® database, test the connection by running:
    <WinCC OA installation>\bin\pgsql\bin\psql.exe -U postgres
  2. After confirming the connection, create the WinCC OA schema by executing the following command:
    <WinCC OA installation>\bin\pgsql\bin\psql.exe -f <WinCC OA installation>\data\NGA\PostgreSQL\sql\schema.sql -U postgres

2. Create the WinCC OA Project

  1. Depending on your requirements, create a redundant or a non-redundant WinCC OA project using NGA with the Manual configuration option (for Manual configuration see chapter Archiving). This means that a managed PostgreSQL® database will not be created automatically.
  2. Configure the Database Connection for both the PostgreSQL® backend and the PostgreSQL_2 backend as follows:
    <IP of Database Server 1>:5432$<IP of Database Server 2>:5432
    In a redundant network configuration, you can change the database connection by specifying
    <IP of Database Server 1>,<2nd IP of Database Server 1>:5432$<IP of Database Server 2>,<2nd IP of Database Server 2>:5432