Setup PostgresQL Database for SCADA

Installing PostgresQL Database for SCADA can be easily done using default configuration with the following steps.

  1. Download & install PostgresQL core database for Windows. The only thing you need to think ahead is the superuser password.
  2. Download & install both 32bit & 64bit PostgresQL ODBC drivers. And then just click through the installation wizard.
  3. Paste the whole string directly into IGX Project Editor’s database task’s Connection String field:Provider=MSDASQL.1;Password=password;Persist Security Info=True;User ID=postgres;Extended Properties="Driver={PostgreSQL UNICODE};Server=127.0.0.1;Port=5432;Database=;"
  4. After pasting into the P.E., click on browsing button […] at the end of the Connection String cell will pop up the Data Link Properties.
  5. Change the password as per what entered during installation in first step.
  6. Click on the “Test Connection” button to validate. You shall get “Test connection succeeded.” if everything is OK.

You may then proceed to start the SCADA engine but in any case you get error messages while clicking on “Test Connection” button, Look out ODBC Driver Troubleshooting guide.

The provided external download links may be changed or updated from time to time, then search the updated download links for PostgreSQL and its ODBC driver respectively.

NOTE: Read more HERE on how to create a PostgreSQL database for your SCADA usage.