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
- 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 - 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
- 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.
- 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>:5432In 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
