Error Creating tables on PostgreSQL

Error Creating tables on PostgreSQL

Problem

The below error or something similar may appear when creating the tables on a PostgreSQL database. This will be after entering the Central Config parameters and clicking save.

Solution

  1. Make sure that the max_prepared_transactions line in the postgresql.conf (e.g. C:\Program Files\PostgreSQL\9.5\data\postgresql.conf) file is uncommented (no # at the beginning) and has a value of 100. 

  2. The PostgreSQL service must be restarted after this change has been made.

Related articles

 

 

© 2023 Foray, LLC - All Rights Reserved