...

By default, Servoy comes bundled with the Sybase SQL Anywhere engine PostgreSQL engine, a Servoy Repository database and a set of sample databases, but the installation of the engine and sample databases is optional in the installer.

...

...

In order to be able to start, the Servoy Application Server requires a

...

connection

...

to the Servoy Repository. When using existing databases, a valid connection to a properly configured Servoy Repository is required for the Servoy Application Server to be able to start.

Using the Bundled PostgreSQL Engine i.c.w.

...

Existing Databases

When the installation of the Sybase SQL Anywhere PostgreSQL database engine is required, keep the Database option in the All-In-One installer checked.

After installing the Servoy Application Server, the following steps are required to remove the sample databases and connect the Sybase SQL Anywhere PostgreSQL engine to existing Sybase SQL Anywhere PostgreSQL databases:

...

• Start the database (see Starting the Database for more information)

• Connect to the database using the commandline psql utility and drop the unwanted databases:

  Code Block
  title Connecting
  {servoyInstall}/application_server/

...

• postgres_db/bin/psql postgres DBA

• Code Block
  title

...

• Dropping the sample databases

...

...

• drop database if exists user_data

...

• ; drop database

...

• if exists example; drop database if exists log_data

...

• ; drop database

...

• if exists udm; drop database if exists pdf_forms

...

• ; drop database

...

• if exists bug_db

...

c:/myOwnDatabases/crm.db

...

Not using the bundled Sybase SQL Anywhere database engine

...

• ;

• Restore a dump of the existing databases. For information on how to backup and restore databases, see this PostgreSQL documentation.

Not Using the Bundled PostgreSQL Database Engine

When not using the Sybase SQL Anywhere PostgreSQL database engine, the option can be unchecked in the installer. This will skip the installation of both the Sybase SQL Anywhere PostgreSQL database engine, the repository database and the sample databases.

Since the Servoy Application Server requires at least one connection named 'repository_server' for the Servoy Repository, when unchecking the 'Database' option in the All-In-One installer, the installation of the Servoy Application Server will not be ready for use after finishing the All-In-One installer will not be ready for use.

In order to get the Servoy Application Server ready for use the following steps are required:

• Copy a servoy.properties file from another installation (for example a Servoy Developer

...

• installation) into the

...

• {servoyInstall}/application_server directory

...

• If the copied servoy.properties file

...

• doesn't already contain properly configured database connections, see Manual configuration in the Database Connections chapter for more information on how to manually edit the servoy.properties file.

Depending on the type of databases used, JDBC drivers might need to be added. See JDBC Drivers in the Database Connections chapter for more information.