Forum OpenACS Q&A: Re: PG OACS 5.1.1 Schema Diagrams - PNG, PS, PDF Formats

Collapse
Posted by George Essig on
Get graphviz from:

http://www.graphviz.org/

I actually used the SuSE 9.1 RPM.

Get postgresql_autodoc from:

https://github.com/cbbrowne/autodoc

Create a database containing want you want to diagram.

createdb oacs_5_kernel
createlang plpgsql oacs_5_kernel
psql oacs_5_kernel < ./acs-kernel-create.sql

Use postgresql_autodoc to generate documentation files in html, dia, dot, and xml formats.

postgresql_autodoc -d oacs_5_kernel -f oacs_5_kernel

Use the graphviz dot command to convert the dot file into png and ps files.

dot -Tpng -o oacs_5_kernel.png oacs_5_kernel.dot
dot -Tps -o oacs_5_kernel.ps oacs_5_kernel.dot

Used Adobe Photoshop to convert the ps file to pdf. Other utilities like ps2pdf and Adobe distiller truncated the diagram. I don't know why.

I just uploaded the postgresql_autodoc html file to:

https://openacs.org/storage/download/oacs_5_kernel.html?version_id=199144

George Essig