Page tree
Skip to end of metadata
Go to start of metadata
Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 103 rates

Installation Notes

Windows/Linux

  • use the installer

OSX

Installation

  • no visual installer available (windows/linux only)
  • adjust the shared memory of the system first:
  • far the simplest is to perform a package installation: select networked DMBS package
  • to exit the installer you will have to press the F3 key

Starting Stopping

  • setup environment:
    . /Applications/IngresII/ingres/.ingIIsh
    
  • use ingstatus, ingstart, ingstop, createdb

Configure Magnolia/Jackrabbit

Jackrabbit Configuration File

  • copy the MySQL configuration file
  • class to use org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager
  • value for schema is: "ingres"

Example:

    <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager">
      <param name="driver" value="com.ingres.jdbc.IngresDriver" />
      <param name="url" value="jdbc:ingres://localhost:II7/magnolia;AUTO=multi" />
      <param name="schema" value="ingres" /><!-- warning, this is not the schema name, it's the db type -->
      <param name="schemaObjectPrefix" value="${wsp.name}_" />
      <param name="externalBLOBs" value="false" />
    </PersistenceManager>

JDBC Driver
Can be found at lib/iijdbc.jar

JDBC URL

  • the port is the instance name: II by default and 7 for JDBC
  • AUTO=multi --> see known issues

User/Password

  • ingres uses systems users
  • for local connections one can omit the user/password

Create/Delete Databases

createdb <databasename>
destroydb <databasename>

Verify the installation

start the console

sql magnolia

List the tables (\g for go)

help \g

Exit the console

\q

Backup

Ingres supports hot backups

Activate Journaling/First Backup

ckpdb +j magnolia

+j activates journaling (re-applayable changes since last backup)

Regular Backup/Checkpoints

ckpdb magnolia

Note: the backups are stored in the checkpoint directory

Restore

rollforwarddb magnolia

-j: to exclude the journal (don't re-apply the changes after the moment of backing up)

Notes

  • you should also backup the system database IIdbdb
  • also backup the data store (jackrabbit) if maintained in the filesystem

Visual UI

The visual UI is only available on Windows but remote connections are supported. They get currently ported to Java and hence will be available for all platforms.