This diagram you wanted is called the database schema. you can use a program called pg_dump (sorta) like this
pg_dump -s cobalt -f cobalt.shema -u on a good day with a lot of luck and a tail wind, this should ask you for the postgres username and password (_not_ the same as root user/pass) and then dump the schema for database cobalt to a file called cobalt.schema (pick whatever you want.) If you're any good with sql then you will be able to interpret this to tell you the database structure. otherwise, import it as sql into access to give you lots of pretty pictures to look at. Fcuk it, i'll just paste the version i have here. :P this basicaly tells you the tables, and column names and types. hope it helps: CREATE TABLE "vsite" ( "emaildomain" text, "name" text, "suspend" text, "userlist_sort" text, "type" text, "userlist_range" int4, "user_quota" int4, "fqdn" text, "quota" int4, "ftp" text, "user_fpx" text, "fpx" text, "user_apop" text, "ssi" text, "apop" text, "ssl" text, "cgi" text, "gid" int4, "ftpquota" int4, "ipaddr" text, "webdomain" text, "user_shell" text, "bwlimit" text, "shell" text, "maxusers" int4, "domain" text, "user_namegen" int4, "ftpusers" int4, "hostname" text, "modify" datetime); CREATE TABLE "bw" ( "bwlimit" text, "name" text, "method" text, "direction" text, "protocol" text, "type" text, "port" text, "modify" datetime); CREATE TABLE "cpu" ( "type" text, "name" text, "load1" float8, "load5" float8, "load15" float8, "uptime" int8, "procs" int8, "model_name" text, "mhz" int4, "temperature" int4, "modify" datetime); CREATE TABLE "defcon" ( "type" text, "name" text, "special" text, "defcon" int4, "modify" datetime); CREATE TABLE "memory" ( "type" text, "name" text, "total" int8, "free" int8, "used" int8, "percent" int4, "modify" datetime); CREATE TABLE "network" ( "type" text, "name" text, "in_bytes" int8, "in_packets" int8, "out_bytes" int8, "out_packets" int8, "errors" int8, "collisions" int8, "modify" datetime); CREATE TABLE "service" ( "type" text, "name" text, "state" text, "modify" datetime); CREATE TABLE "users" ( "apop" text, "name" text, "aliases" text, "altname" text, "uid" int4, "suspend" text, "type" text, "fullname" text, "forward" text, "vacation" text, "shell" text, "admin" text, "quota" int4, "vsite" text, "vacationmsg" text, "fpx" text, "modify" datetime); CREATE TABLE "quota" ( "type" text, "name" text, "total" float8, "free" float8, "used" float8, "percent" float8, "modify" datetime); ----- Original Message ----- From: "Matthew Nuzum" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 5:48 PM Subject: RE: [cobalt-developers] Connecting to the cobalt postrgres database... > > I've been digging through the Cobalt modules trying to find how the > admin > > interface connects to the Cobalt database, and it's proving rather > > frustrating. > > > > Any one know the default postgresql username/password used by cobalt? > is > > there any documentation on the database anywhere such as a diagram of > > tables, fields and relationships? > > > Hey! The easy way to find your connect info for postgres is to look in > the file: /etc/cobalt/.meta.id > You must be root to see it though. > > Matthew Nuzum > 5`//337-31337 > > followers.net > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers > _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
