Connecting to PostgreSQL

To connect Ignition to the PostreSQL database

  1. From the Gateway, go to the Configure section.

  2. From the menu on the left, select Databases > Connections.
    The Database Connections page is displayed.

  3. Look for the orange arrow, click on Create new Database Connection....

    images/download/attachments/6033911/image2015-3-2_8_47_19.png

  4. Select the PostgreSQL JDBC Driver and click Next.

  5. Enter the following information:
    Name: PostgreSQL
    Connect URL: jdbc:postgresql://localhost:5432/test
    username: postgres
    password: password is what you entered in during the Postgres installation.

  6. Click Create New Database Connection at the bottom of the form.
    The Database Connections page is displayed showing the Status of your connection as Valid.

  7. To display the details about the status of your database connection, see the Note on the above window and click on the Database Connection Status link.