Connecting to PostgreSQL
To connect Ignition to the PostreSQL database
-
From the Gateway, go to the Configure section.
-
From the menu on the left, select Databases > Connections.
The Database Connections page is displayed. -
Look for the orange arrow, click on Create new Database Connection....
-
Select the PostgreSQL JDBC Driver and click Next.
-
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. -
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. -
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.