[cobalt-users] Database Schema

[Jan P Tietze <jptietze@xxxxxxxxxxx>]

Hello all,

I have a database integrity problem on a RaQ3. A table in the 'cobalt'
postgres database is gone (quota), and presumably the database structure
is damaged, ie. I get 600+ spurious files named
pg_attribute_relid_attnam_index.<number> in the ~postgres/base/cobalt
directory. I want to do a dump/restore, but need a proper database
schema for that. Since I suspect mine is damaged (ie. I think index
definitions are gone, since none are in the schema right now, and I have
lost the quota table), I need a proper schema layout. Would anyone on
this list be so kind as to dump his/her database schema for me? The
command to run would be

pg_dump -s cobalt

or, depending on your setup if you have user authentication enabled,
possibly

pg_dump -s -u cobalt

I would need the command's output. Any help is appreciated very much.

Thank you in advance & best regards

Jan