Re: [GENERAL] Er Data Modeller for PostgreSQL

On 12/28/2016 03:24 PM, Rich Shepard wrote:
> On Fri, 23 Dec 2016, Thomas Kellerer wrote:
>
>> Scott Mead just blogged about using SchemaSpy with Postgres
>
> Thomas,
>
>   I've spent the past two days without success trying to get schemaSpy
> running here

An example from my machine that works:

aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u
postgres  -db production -host localhost  -dp
/home/aklaver/bin/postgresql-9.4.1212.jre6.jar -o s_spy

Using database properties:
   [schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema
details........................................................................(2sec)
Writing/graphing summary..............(3sec)
Writing/diagramming
details.....................................................................(14sec)
Wrote relationship details of 69 tables/views to directory 's_spy' in 20
seconds.
View the results by opening s_spy/index.html


> and have found a solution that works quickly and easily: dbeaver
> <http://www.dbeaver.com/>. Yes, it's a GUI rather than CLI application but
> it works ... and it's F/OSS under the GPL. Best of all worlds.

Looks interesting.

>
>   I downloaded the postgresql-jdbc driver and installed it in a couple of
> places trying to make schemaSpy happy, and futzed with pg_hba.conf access
> control. The dbeaver application downloaded and internally installed the
> postgresql-jdbc driver it wants to use.
>
>   It took no time to figure out how to create, test, and establish a
> connection to the databases and examine their E-R diagrams. They're now
> saved as .png files.
>
> Thanks very much for your pointer and my wishes for a healthy, happy, and
> prosperous 2017 to you and all who responded to my question,
>
> Rich
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com