Ingres 3 - part 2

Well, now that the software appears fully installed and configured, the daemons all hovering in the background waiting to spring to life, time to put some data in, and see if one can ever see it again ;-)

Logged in as user ingres, and off we go:

[ingres@fedora4 ~]$ createdb newone
Creating database 'newone' . . .

Creating DBMS System Catalogs . . .
Modifying DBMS System Catalogs . . .
Creating Standard Catalog Interface . . .
Creating Front-end System Catalogs . . .
Creation of database 'newone' completed successfully.

So far so good, now have a go at creating then selecting some data:

[ingres@fedora4 ~]$ sql newone
INGRES TERMINAL MONITOR Copyright 2005 Computer Associates Intl, Inc.
Ingres Linux Version II 3.0.2 (int.lnx/105) login
Fri Oct 21 09:49:07 2005

continue
* create table t1 (col1 char(20));
* insert into t1 values ('hello world');
* select * from t1
* \g
Executing . . .
(1 row)

┌────────────────────┐
│col1 │
├────────────────────┤
│hello world │
└────────────────────┘
(1 row)
continue
* \q
Your SQL statement(s) have been committed.
Ingres Version II 3.0.2 (int.lnx/105) logout
Fri Oct 21 09:52:46 2005

So, what's the conclusion? Well, I'm very impressed.

I suppose I will encounter some problems with the very installation I have just completed, as there are specific environmental settings, as well as kernel parameters that I did not investigate and adjust.

Another important issue a chose to totally ignore is that of user identity when performing the download and installation. This should also have been identified and used correctly. However, what the above exercise proved, is that Ingres for Linux is fine, and can be used 'out of box'.

Basic installation and configuration is simple - if the defaults are fine for you, that is!