PostgreSQL is a free, open source database with great capability. It is particularly suited to Darwino because, since 9.4, it features a native JSON data type with query capabilities. Moreover, it comes with an integrated full text search engine.
If you just started with PostgreSQL, the we strongly advise you to run one of the predefined installers. See: http://www.postgresql.org/download/. Please, choose the latest version, or at least version 9.4.
By default, the pre-packaged Darwino configuration files (see: TOMCAT installation) look for a PostgreSQL database on the local host using the user/password and port below:
- Port: 5432 (default)
Configuring PostgreSQL for the Demo Application
The demo projects use a specific database called
dwodemo, which should be created by either using the PostgreSQL command line tools, or the easiest UI admin 'pgAdmin III', installed by the PostgreSQL installer.
Here are the steps:
- Launch pgAdmin III
- Right click on the server and select 'Connect'. If asked, enter the password 'postgres'
- Right click on the database and select 'New Database...'
- Name it
dwodemoand hit ok. All the other default settings
Once done, you should see the database created after double clicking it in the list: