Switching Database to PostgreSQL

To use PostgreSQL as Iotellect Server's database engine, follow the generic instructions from Switching To Another Database Engine article. Here is a list of notes specific to PostgreSQL:

  • Download PostgreSQL JDBC4 driver for your version of database server and store it on the machine running Iotellect Server. At the time of this writing, it is available at http://jdbc.postgresql.org/.

  • Put postgresql-X.X-XXX.jar into the /lib subfolder of Iotellect Server installation folder.

  • Set Database Driver in Iotellect Server Global Configuration Setting to org.postgresql.Driver. This is the java class name for the PostgreSQL driver.

  • The Database URL setting for the PostgreSQL database has the following format: jdbc:postgresql://host[:port]/database, where host is the IP or hostname of the  PostgreSQL server (can be an empty string or localhost), port is port name on which PostgreSQL server is running (omit this part of URL to use the default value), and database name is the name of database that contains Iotellect Server's data. You can use server for the database name. For example, if your PostgreSQL server runs at 192.168.0.1 with its default port, use the following URL: jdbc:postgresql://192.168.0.1/server.

  • Set Database Dialect setting to one of the following:

    • PostgreSQL (bytea): Recommended dialect.

    • PostgreSQL: Legacy dialect. In cases where the Iotellect data tables contain such large values that server memory allocation issues arise, explore alternative data storage options rather than using the non-bytea PostgreSQL dialect.

Was this page helpful?