Twitter Updates

    follow me on Twitter

    G-AVLN in front of her home

    G-AVLN in front of her home

    Mostly Unix and Linux topics. But flying might get a mention too.

    Friday, October 28, 2005

    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!

    1 comment:

    Anonymous said...

    Hi, love your blog about SQL recovery. If you want to know more about SQL recovery visit http://www.swstars.com at SQL recovery

    Blog Archive