PostgreSQL

Versions

BEXIS2 supports different versions of PostgreSQL (version >= 9). However, appropriate configurations may need to be made and based on endoflife.date for PostgreSQL, you should consider installing and using a recommended version of it, which is neither EOL nor will be soon.

Configurations

Based on the version of PostgreSQL you have installed, different settings need to be done. Please check out the following ones.

Locale and Formatting

In most cases, the "datestyle" type set within your PostgreSQL instance might be wrong. So please do the following steps to either ensure you have the correct type or change it accordingly.

1. Please open the file postgresql.conf with an editor of your choice. You will find the file within the installation directory of PostgreSQL (e.g. C:\Program Files\PostgreSQL\13\data).
2. Search for the property datestyle (e.g. in most editors on Windows, CTRL + F will open up a search overlay).
3. Independent of the current value next to the property, change the whole line to datestyle = 'iso, dmy'.
4. Save the file
5. Restart PostgreSQL on your machine. If you do not know how to restart the service, just restart the whole machine.

Password Encryption Method

tba