Setting up Postgress.
From version 4.0.0.487+ mysql and postgress is supported.
Download the database engine here.
Most of the functionality has been checked plugins still need work some of them will just work others need small adjustments.
For example purposes we use a premade sql to create a scheme in the database.
Then we use that scheme to add to osFinancials / Turbocash.
Install Postgress database and create a new scheme.
in this exampe we will use osf_nld.
In the folder of osfinancials we can find a new program called.
ExecSQL.
Start this program and setup the login data.
Remember you need access from the machine you are working on.
Press ok to continue.
In the folder BIN/SQL/Scripts there is a file called GEN_osf_sql_nld.sql
Open the file with notepad.
Select all and copy the data. and paste it into the top memo of the new program.
Press the run button, wait a while and then the new database should now have tables and data.
Now startup osFinancials or Turbocash.
Before opening a set of books select the add button and from the popup menu Select Set of books directory.
add the same settings as when using the ExecSQL program
Press change and open the new books.
You will see the books being updated to add missing default tables.
You now should have a working database on postgress.