Read-only Database Support

Ingres II 2.5 provides the ability to distribute a read-only database on a CD-ROM or other read-only media.

Example: Create a Read-only Database

For example, to create a read-only database called mydatabase on UNIX:

1. Log in as the installation owner.
2. Change location to the staging directory:

   cd /stagingarea

3. Create directory and subdirectories:

   mkdir ingres

   mkdir ingres/data

   mkdir ingres/data/default

4. Place appropriate permissions:

   chmod 755 ingres

   chmod 700 ingres/data

   chmod 777 ingres/data/default

5. Change location to the database files:

   cd /install/inst1/ingres/data/default

6. Copy the database directory and its subdirectories to the new area:

   cp -r mydatabase /stagingarea/ingres/data/default/

7. Copy the directory structure to the CD-ROM or other device:

   cp -r ingres/data/default/mydatabase /cdrom

   Create a new database location using the create location statement or using the accessdb utility:

   create location cdromloc with area=/cdrom, usage=(database);

8. Use the createdb command to access the read-only database in the installation:

   createdb -r cdromloc mydatabase