Child pages
  • Installing on Existing Databases

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In order to be able to start, the Servoy Application Server requires a connection to the Servoy Repository. When using existing databases, make sure that a valid connection to a properly configured Servoy Repository is available to 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 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 PostgreSQL engine to existing PostgreSQL databases:

...

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

    Code Block
    titleConnecting
    {

...

  • servoyInstall}/application_server/postgres_db/bin/psql postgres DBA
  • Code Block
    titleDropping 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;
  • Restore a dump of the existing databases. For information on how to backup and restore databases, see

...

...

  • .

Not

...

Using the

...

Bundled PostgreSQL

...

Database Engine

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

...

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

...

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.

Note
titleUsing an existing database for the [Servoy Repository]

See Servoy Repository upgradeUpgrade for information on upgrading or creating the Servoy Repository tables in an existing database. See Database Servers for more information on how to configure the 'repository_server' server connection to point to the existing database