How to Configure Symphony AC to use a Postgre SQL Server

1. Download and install PostgreSQL 
2. Download and install the ODBC driver on all PCs that will be connecting to the PostgreSQL server
   
   
3. Once installed, create a new database using pgAdmin4.
4. Execute the postgresql.sql script located in the Data folder on the Symphony AC server (typically: C:\Program Files (x86\Symphony AC\Data) using pgAdmin4 to create the tables within the newly created database.
5. Finally, run the Configuration Utility and set the Database to PostgreSQL and specify database server name and database server port (default is 5432) and database user connection (login) information (case sensitive).
   
   
6. After clicking Save Connection, close the Configuration Utility and launch the application

Symphony AC Operator Guide