use Postgresql on netserver as source of Nagios "ncar" config
file. See David's Postgres notes.
basics:
psql nnd
To see all switches:
select ip,short
from system,groups_system,groups
where system.id=groups_system.system_id and
groups.id=groups_system.group_id and
short='All_Switches';
To see all tables defined in the database:
select * from pg_class;
See Dave's schema.txt file. You can check it out from CVS (Dave's
CVS notes are at http://www.scd.ucar.edu/nets/tools/cvs/)
cd /tmp
cvs co nnd
cd nnd
more schema.txt
to be postgres, must su as root then "su postgres"
psql tricks:
\d
\z
\dt
select * from pg_class;