Re: Database reverse engineering

Started by Nonameover 18 years ago2 messagesgeneral
Jump to latest
#1Noname
MargaretGillon@chromalloy.com

I am trying to use postgresql-autodoc. The autodoc finds all the Perl
modules and compiles but when I go to /usr/local/bin and run
postgresql_autodoc like this

postgresql_autodoc -f owl -d owl -u postgres --password='****'

I get a message that says

Use of uninitialized value in numeric lt (<) at
/usr/local/bin/postgresql_autodoc line 246.
PostgerSQL 7.3 and later are supported at
/usr/local/bin/postgresql_autodoc line 247.
Database handle destroyed without explicit disconnect.

This happens when I run the program as root or as super user postgres. The
postgresql on my Redhat 9 system is 8.2.5 . The 7.3 was removed with an
RPM uninstall several weeks ago. The perl is 5.8.8. I do not know Perl. I
have seen this list discuss using postgresql_autodoc so any help from
people who have used this program would be appreciated.

Please reply to me as well as the list as I am on the digest version. TIA.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the
intended recipient(s) and may contain proprietary and/or confidential
information which may be privileged or otherwise protected from
disclosure. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of
the message as well as any attachment(s) to the original message.

#2vladimir konrad
v.konrad@lse.ac.uk
In reply to: Noname (#1)

I am trying to use postgresql-autodoc. The autodoc finds all the Perl
modules and compiles but when I go to /usr/local/bin and run
postgresql_autodoc like this

I had a good luck with schema-spy (done in java)...

http://schemaspy.sourceforge.net/

Vlad

ps: the command I use is (all on one line):
java -jar ~/app/schemaspy/schemaSpy_3.1.1.jar -t
pgsql -cp /usr/share/java/postgresql-8.2-506.jdbc3.jar -host localhost -db
database_name -s public -u database_user -o doc/db

-cp - the location of postgresql jdbc driver
-o - output directory

The database_user does not need password for localhost connection to
postgresql on my system...