From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Er Data Modeller for PostgreSQL |
Date: | 2016-12-28 23:48:34 |
Message-ID: | 6f2d3779-9f4e-db62-cdd3-276dfb19aad8@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2016-12-29 00:03:57 | Re: Er Data Modeller for PostgreSQL |
Previous Message | Rich Shepard | 2016-12-28 23:24:40 | Re: Er Data Modeller for PostgreSQL |