Upgrading to PostgreSQL

Overview

PostgreSQL is an open source Relational database management system (RDBMS) that has a significantly smaller footprint than SQL Server. There are no database size limits with PostgreSQL, and it outperforms MS Access and SQL Server.


Steps to Follow

Download and install PostgreSQL 

Download and install the ODBC driver on all PCs that will be connecting to the PostgreSQL server.

Once installed, create a new database using pgAdmin4.

Execute the postgresql.sql script located in the Data folder using pgAdmin4 to create the tables within the newly created database.

Finally, run the Configuration Utility and set the Database to PostgreSQL and specify the correct logon, database name (case sensitive) and data connection information. 

After clicking Save Connection, close the Configuration Utility and launch the application.


Was this article helpful?