Linux Appliance Design

3.6. Introduction to RTA's Built-in Tables

The RTA library has several built-in tables. Appendix A has the full details, so we will introduce them here. The first table has only one row.

3.6.1. rta_dbg

The rta_dbg table lets you control how and what is logged. You can turn on tracing of all SQL by setting trace to 1, and you can direct log messages to neither, syslog, stderr, or both by setting target to 0, 1, 2, or 3, respectively. You can also specify the priority, facility, and ident values for syslog(). From psql we get:

# select * from rta_dbg;
 syserr | rtaerr | sqlerr | trace | target | priority | facility | ident
--------+--------+--------+-------+--------+----------+----------+-------
 1      | 1      | 1      | 0     | 1      | 3        | 8        | rta
(1 row)

3.6.2. rta_stat ...