pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGenSchemaSpy
9+ messages / 4 participants
[nested] [flat]
* GenSchemaSpy
@ 2021-12-28 17:30 Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
0 siblings, 1 reply; 9+ messages in thread
From: Daulat @ 2021-12-28 17:30 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello Team,
I have to generate an ER Diagram in postgres using schemaspy tool.
Can you please share the basic steps for the same.
Thanks
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
@ 2021-12-28 17:36 ` Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Tim Clarke @ 2021-12-28 17:36 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On 28/12/2021 17:30, Daulat wrote:
Hello Team,
I have to generate an ER Diagram in postgres using schemaspy tool.
Can you please share the basic steps for the same.
Thanks
The wiki page has basics https://wiki.postgresql.org/wiki/SchemaSpy and there are good hits from github on this as well. Get back to us with any specifics to your problem once you've got it running.
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/
Watch our latest Minerva Briefings on BrightTALK<https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_c...;
Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom
________________________________
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
@ 2021-12-28 17:58 ` Daulat <daulat.dba@gmail.com>
2021-12-28 18:21 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 18:33 ` Re: GenSchemaSpy João Gaspar <joao.f.r.gaspar@gmail.com>
2021-12-29 20:52 ` Re: GenSchemaSpy Gogala, Mladen <gogala.mladen@gmail.com>
0 siblings, 3 replies; 9+ messages in thread
From: Daulat @ 2021-12-28 17:58 UTC (permalink / raw)
To: Tim Clarke <tim.clarke@minerva.info>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Thanks Tim,
I am getting the following messages.
INFO - Starting Main v6.1.0 on SDGL1143 with PID 29536
(D:\schemaspy-6.1.0.jar started by allen in C:\Users\allen)
INFO - The following profiles are active: default
INFO - Started Main in 1.136 seconds (JVM running for 1.617)
INFO - Starting schema analysis
INFO - Connected to PostgreSQL - 10.2
INFO - Gathering schema details
Gathering schema
details...................................................................(33sec)
Connecting
relationships...................................................................(79sec)
Writing/graphing summary.INFO - Gathered schema details in 79 seconds
INFO - Writing/graphing summary
WARN - Failed to query Graphviz version using 'dot -V'
Cannot run program "dot": CreateProcess error=2, The system cannot find the
file specified
INFO - Graphviz rendered set to ''
..ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\schemapy\diagrams\summary\relationships.real.compact.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\schemapy\diagrams\summary\relationships.real.large.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\schemapy\diagrams\summary\relationships.implied.compact.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\schemapy\diagrams\summary\relationships.implied.large.dot
.ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\tempcategory_placeholder_map.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\users_external_tool_id.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\cluster_reload_objects.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\owasp_extra_replacements.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\owasp_skip_params_for_urls.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\placeholder.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\mt_org_template.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\system_configuration.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\registeruser.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for:
D:\schemapy\diagrams\orphans\user_current_assignment_report.1degree.dot
Failed to generate Orphan diagram
.....(5sec)
Writing/diagramming detailsINFO - Completed summary in 5 seconds
INFO - Writing/diagramming details
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at
org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: org.schemaspy.output.diagram.DiagramException: Failed to
generate Table diagram
at
org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:71)
at
org.schemaspy.output.html.mustache.diagrams.MustacheDiagramFactory.generateTableDiagram(MustacheDiagramFactory.java:44)
at
org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:80)
at
org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:426)
at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:260)
at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:123)
at
org.schemaspy.cli.SchemaSpyRunner.runAnalyzer(SchemaSpyRunner.java:98)
at org.schemaspy.cli.SchemaSpyRunner.run(SchemaSpyRunner.java:87)
at org.schemaspy.Main.main(Main.java:55)
... 8 more
Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or
invalid version
at
org.schemaspy.output.diagram.graphviz.GraphvizDot.generateDiagram(GraphvizDot.java:193)
at
org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:68)
... 16 more
C:\Users\allen>
C:\Users\allen>Graphviz
On Tue, Dec 28, 2021 at 11:07 PM Tim Clarke <tim.clarke@minerva.info> wrote:
> On 28/12/2021 17:30, Daulat wrote:
>
> Hello Team,
>
> I have to generate an ER Diagram in postgres using schemaspy tool.
> Can you please share the basic steps for the same.
>
> Thanks
>
> The wiki page has basics https://wiki.postgresql.org/wiki/SchemaSpy and
> there are good hits from github on this as well. Get back to us with any
> specifics to your problem once you've got it running.
> Tim Clarke
>
>
>
> Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 |
> Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1
> 647 503 2848
> Web: https://www.manifest.co.uk/
>
> Watch our latest Minerva Briefings on BrightTALK
> <https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_c...;
>
>
>
> Minerva Analytics Ltd - A Solactive Company
> 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United
> Kingdom
>
> ------------------------------
>
> Copyright: This e-mail may contain confidential or legally privileged
> information. If you are not the named addressee you must not use or
> disclose such information, instead please report it to admin@minerva.info
> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd:
> Registered in England Number 11260966 & The Manifest Voting Agency Ltd:
> Registered in England Number 2920820 Registered Office at above address.
> Please Click Here https://www.manifest.co.uk/legal/ for further
> information.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
@ 2021-12-28 18:21 ` Tim Clarke <tim.clarke@minerva.info>
2 siblings, 0 replies; 9+ messages in thread
From: Tim Clarke @ 2021-12-28 18:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On 28/12/2021 17:58, Daulat wrote:
Thanks Tim,
I am getting the following messages.
INFO - Starting Main v6.1.0 on SDGL1143 with PID 29536 (D:\schemaspy-6.1.0.jar started by allen in C:\Users\allen)
INFO - The following profiles are active: default
INFO - Started Main in 1.136 seconds (JVM running for 1.617)
INFO - Starting schema analysis
INFO - Connected to PostgreSQL - 10.2
INFO - Gathering schema details
Gathering schema details...................................................................(33sec)
Connecting relationships...................................................................(79sec)
Writing/graphing summary.INFO - Gathered schema details in 79 seconds
INFO - Writing/graphing summary
WARN - Failed to query Graphviz version using 'dot -V'
Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified
INFO - Graphviz rendered set to ''
..ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\schemapy\diagrams\summary\relationships.real.compact.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\schemapy\diagrams\summary\relationships.real.large.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\schemapy\diagrams\summary\relationships.implied.compact.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\schemapy\diagrams\summary\relationships.implied.large.dot
.ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\tempcategory_placeholder_map.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\users_external_tool_id.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\cluster_reload_objects.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\owasp_extra_replacements.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\owasp_skip_params_for_urls.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\placeholder.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\mt_org_template.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\system_configuration.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\registeruser.1degree.dot
Failed to generate Orphan diagram
ERROR - Failed to produce diagram for: D:\schemapy\diagrams\orphans\user_current_assignment_report.1degree.dot
Failed to generate Orphan diagram
.....(5sec)
Writing/diagramming detailsINFO - Completed summary in 5 seconds
INFO - Writing/diagramming details
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: org.schemaspy.output.diagram.DiagramException: Failed to generate Table diagram
at org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:71)
at org.schemaspy.output.html.mustache.diagrams.MustacheDiagramFactory.generateTableDiagram(MustacheDiagramFactory.java:44)
at org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:80)
at org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:426)
at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:260)
at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:123)
at org.schemaspy.cli.SchemaSpyRunner.runAnalyzer(SchemaSpyRunner.java:98)
at org.schemaspy.cli.SchemaSpyRunner.run(SchemaSpyRunner.java:87)
at org.schemaspy.Main.main(Main.java:55)
... 8 more
Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or invalid version
at org.schemaspy.output.diagram.graphviz.GraphvizDot.generateDiagram(GraphvizDot.java:193)
at org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:68)
... 16 more
C:\Users\allen>
C:\Users\allen>Graphviz
Looks like graphviz isn't installed or can't be found - it can't run an executable called Dot: "Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or invalid version"
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/
Watch our latest Minerva Briefings on BrightTALK<https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_c...;
Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom
________________________________
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
@ 2021-12-28 18:33 ` João Gaspar <joao.f.r.gaspar@gmail.com>
2021-12-29 06:17 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
2 siblings, 1 reply; 9+ messages in thread
From: João Gaspar @ 2021-12-28 18:33 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: Tim Clarke <tim.clarke@minerva.info>; pgsql-admin@lists.postgresql.org
Hi Daulat,
Check documentation
https://schemaspy.readthedocs.io/en/latest/new.html
Since 6.1.0 you can add the flag in the commandline argument -vizjs and
schemaspy skip the graphviz installation.
https://schemaspy.readthedocs.io/en/latest/configuration/commandline.html
Cheers
A terça, 28/12/2021, 17:58, Daulat <daulat.dba@gmail.com> escreveu:
> Thanks Tim,
>
> I am getting the following messages.
>
> INFO - Starting Main v6.1.0 on SDGL1143 with PID 29536
> (D:\schemaspy-6.1.0.jar started by allen in C:\Users\allen)
> INFO - The following profiles are active: default
> INFO - Started Main in 1.136 seconds (JVM running for 1.617)
> INFO - Starting schema analysis
> INFO - Connected to PostgreSQL - 10.2
> INFO - Gathering schema details
> Gathering schema
> details...................................................................(33sec)
> Connecting
> relationships...................................................................(79sec)
> Writing/graphing summary.INFO - Gathered schema details in 79 seconds
> INFO - Writing/graphing summary
> WARN - Failed to query Graphviz version using 'dot -V'
> Cannot run program "dot": CreateProcess error=2, The system cannot find
> the file specified
> INFO - Graphviz rendered set to ''
> ..ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.real.compact.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.real.large.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.implied.compact.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.implied.large.dot
> .ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\tempcategory_placeholder_map.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\users_external_tool_id.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\cluster_reload_objects.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\owasp_extra_replacements.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\owasp_skip_params_for_urls.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\placeholder.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\mt_org_template.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\system_configuration.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\registeruser.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\user_current_assignment_report.1degree.dot
> Failed to generate Orphan diagram
> .....(5sec)
> Writing/diagramming detailsINFO - Completed summary in 5 seconds
> INFO - Writing/diagramming details
> Exception in thread "main" java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
> at
> org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
> Caused by: org.schemaspy.output.diagram.DiagramException: Failed to
> generate Table diagram
> at
> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:71)
> at
> org.schemaspy.output.html.mustache.diagrams.MustacheDiagramFactory.generateTableDiagram(MustacheDiagramFactory.java:44)
> at
> org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:80)
> at
> org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:426)
> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:260)
> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:123)
> at
> org.schemaspy.cli.SchemaSpyRunner.runAnalyzer(SchemaSpyRunner.java:98)
> at org.schemaspy.cli.SchemaSpyRunner.run(SchemaSpyRunner.java:87)
> at org.schemaspy.Main.main(Main.java:55)
> ... 8 more
> Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or
> invalid version
> at
> org.schemaspy.output.diagram.graphviz.GraphvizDot.generateDiagram(GraphvizDot.java:193)
> at
> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:68)
> ... 16 more
>
> C:\Users\allen>
> C:\Users\allen>Graphviz
>
>
>
>
> On Tue, Dec 28, 2021 at 11:07 PM Tim Clarke <tim.clarke@minerva.info>
> wrote:
>
>> On 28/12/2021 17:30, Daulat wrote:
>>
>> Hello Team,
>>
>> I have to generate an ER Diagram in postgres using schemaspy tool.
>> Can you please share the basic steps for the same.
>>
>> Thanks
>>
>> The wiki page has basics https://wiki.postgresql.org/wiki/SchemaSpy and
>> there are good hits from github on this as well. Get back to us with any
>> specifics to your problem once you've got it running.
>> Tim Clarke
>>
>>
>>
>> Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 |
>> Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1
>> 647 503 2848
>> Web: https://www.manifest.co.uk/
>>
>> Watch our latest Minerva Briefings on BrightTALK
>> <https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_c...;
>>
>>
>>
>> Minerva Analytics Ltd - A Solactive Company
>> 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United
>> Kingdom
>>
>> ------------------------------
>>
>> Copyright: This e-mail may contain confidential or legally privileged
>> information. If you are not the named addressee you must not use or
>> disclose such information, instead please report it to admin@minerva.info
>> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd:
>> Registered in England Number 11260966 & The Manifest Voting Agency Ltd:
>> Registered in England Number 2920820 Registered Office at above address.
>> Please Click Here https://www.manifest.co.uk/legal/ for further
>> information.
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 18:33 ` Re: GenSchemaSpy João Gaspar <joao.f.r.gaspar@gmail.com>
@ 2021-12-29 06:17 ` Daulat <daulat.dba@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Daulat @ 2021-12-29 06:17 UTC (permalink / raw)
To: João Gaspar <joao.f.r.gaspar@gmail.com>; +Cc: Tim Clarke <tim.clarke@minerva.info>; pgsql-admin <pgsql-admin@lists.postgresql.org>
OK Joao,
I am getting below errors now.
ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\diagram\diagrams\summary\relationships.real.large.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for:
D:\diagram\diagrams\summary\relationships.implied.large.dot
..
On Wed, Dec 29, 2021 at 12:03 AM João Gaspar <joao.f.r.gaspar@gmail.com>
wrote:
> Hi Daulat,
>
> Check documentation
> https://schemaspy.readthedocs.io/en/latest/new.html
>
> Since 6.1.0 you can add the flag in the commandline argument -vizjs and
> schemaspy skip the graphviz installation.
>
> https://schemaspy.readthedocs.io/en/latest/configuration/commandline.html
>
> Cheers
>
>
> A terça, 28/12/2021, 17:58, Daulat <daulat.dba@gmail.com> escreveu:
>
>> Thanks Tim,
>>
>> I am getting the following messages.
>>
>> INFO - Starting Main v6.1.0 on SDGL1143 with PID 29536
>> (D:\schemaspy-6.1.0.jar started by allen in C:\Users\allen)
>> INFO - The following profiles are active: default
>> INFO - Started Main in 1.136 seconds (JVM running for 1.617)
>> INFO - Starting schema analysis
>> INFO - Connected to PostgreSQL - 10.2
>> INFO - Gathering schema details
>> Gathering schema
>> details...................................................................(33sec)
>> Connecting
>> relationships...................................................................(79sec)
>> Writing/graphing summary.INFO - Gathered schema details in 79 seconds
>> INFO - Writing/graphing summary
>> WARN - Failed to query Graphviz version using 'dot -V'
>> Cannot run program "dot": CreateProcess error=2, The system cannot find
>> the file specified
>> INFO - Graphviz rendered set to ''
>> ..ERROR - RelationShipDiagramError
>> Failed to produce diagram for:
>> D:\schemapy\diagrams\summary\relationships.real.compact.dot
>> ERROR - RelationShipDiagramError
>> Failed to produce diagram for:
>> D:\schemapy\diagrams\summary\relationships.real.large.dot
>> ERROR - RelationShipDiagramError
>> Failed to produce diagram for:
>> D:\schemapy\diagrams\summary\relationships.implied.compact.dot
>> ERROR - RelationShipDiagramError
>> Failed to produce diagram for:
>> D:\schemapy\diagrams\summary\relationships.implied.large.dot
>> .ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\tempcategory_placeholder_map.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\users_external_tool_id.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\cluster_reload_objects.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\owasp_extra_replacements.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\owasp_skip_params_for_urls.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\placeholder.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\mt_org_template.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\system_configuration.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\registeruser.1degree.dot
>> Failed to generate Orphan diagram
>> ERROR - Failed to produce diagram for:
>> D:\schemapy\diagrams\orphans\user_current_assignment_report.1degree.dot
>> Failed to generate Orphan diagram
>> .....(5sec)
>> Writing/diagramming detailsINFO - Completed summary in 5 seconds
>> INFO - Writing/diagramming details
>> Exception in thread "main" java.lang.reflect.InvocationTargetException
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at
>> org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
>> at
>> org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
>> at
>> org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
>> at
>> org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
>> Caused by: org.schemaspy.output.diagram.DiagramException: Failed to
>> generate Table diagram
>> at
>> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:71)
>> at
>> org.schemaspy.output.html.mustache.diagrams.MustacheDiagramFactory.generateTableDiagram(MustacheDiagramFactory.java:44)
>> at
>> org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:80)
>> at
>> org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:426)
>> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:260)
>> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:123)
>> at
>> org.schemaspy.cli.SchemaSpyRunner.runAnalyzer(SchemaSpyRunner.java:98)
>> at org.schemaspy.cli.SchemaSpyRunner.run(SchemaSpyRunner.java:87)
>> at org.schemaspy.Main.main(Main.java:55)
>> ... 8 more
>> Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or
>> invalid version
>> at
>> org.schemaspy.output.diagram.graphviz.GraphvizDot.generateDiagram(GraphvizDot.java:193)
>> at
>> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:68)
>> ... 16 more
>>
>> C:\Users\allen>
>> C:\Users\allen>Graphviz
>>
>>
>>
>>
>> On Tue, Dec 28, 2021 at 11:07 PM Tim Clarke <tim.clarke@minerva.info>
>> wrote:
>>
>>> On 28/12/2021 17:30, Daulat wrote:
>>>
>>> Hello Team,
>>>
>>> I have to generate an ER Diagram in postgres using schemaspy tool.
>>> Can you please share the basic steps for the same.
>>>
>>> Thanks
>>>
>>> The wiki page has basics https://wiki.postgresql.org/wiki/SchemaSpy and
>>> there are good hits from github on this as well. Get back to us with any
>>> specifics to your problem once you've got it running.
>>> Tim Clarke
>>>
>>>
>>>
>>> Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 |
>>> Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1
>>> 647 503 2848
>>> Web: https://www.manifest.co.uk/
>>>
>>> Watch our latest Minerva Briefings on BrightTALK
>>> <https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_c...;
>>>
>>>
>>>
>>> Minerva Analytics Ltd - A Solactive Company
>>> 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United
>>> Kingdom
>>>
>>> ------------------------------
>>>
>>> Copyright: This e-mail may contain confidential or legally privileged
>>> information. If you are not the named addressee you must not use or
>>> disclose such information, instead please report it to
>>> admin@minerva.info
>>> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd:
>>> Registered in England Number 11260966 & The Manifest Voting Agency Ltd:
>>> Registered in England Number 2920820 Registered Office at above address.
>>> Please Click Here https://www.manifest.co.uk/legal/ for further
>>> information.
>>>
>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
@ 2021-12-29 20:52 ` Gogala, Mladen <gogala.mladen@gmail.com>
2021-12-30 09:15 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
2 siblings, 1 reply; 9+ messages in thread
From: Gogala, Mladen @ 2021-12-29 20:52 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 12/28/2021 12:58 PM, Daulat wrote:
> Cannot run program "dot": CreateProcess error=2, The system cannot
> find the file specified
> INFO - Graphviz rendered set to ''
Did you install GraphViz?
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-29 20:52 ` Re: GenSchemaSpy Gogala, Mladen <gogala.mladen@gmail.com>
@ 2021-12-30 09:15 ` Daulat <daulat.dba@gmail.com>
2021-12-31 13:41 ` Re: GenSchemaSpy Gogala, Mladen <gogala.mladen@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Daulat @ 2021-12-30 09:15 UTC (permalink / raw)
To: Gogala, Mladen <gogala.mladen@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
No.
I am using an option -vizjs to avoid the requirement of GraphViz.
See Example here:
java -jar D:\schemaspy-6.1.0.jar -t pgsql -s rpt -db testdb -u postgres -p
2WS -host 10.25.0.222 -o D:\rpt -dp D:\postgresql-42.3.1.jar -vizjs
On Thu, Dec 30, 2021 at 2:23 AM Gogala, Mladen <gogala.mladen@gmail.com>
wrote:
>
> On 12/28/2021 12:58 PM, Daulat wrote:
> > Cannot run program "dot": CreateProcess error=2, The system cannot
> > find the file specified
> > INFO - Graphviz rendered set to ''
>
> Did you install GraphViz?
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
> Blog: https://dbwhisperer.wordpress.com
>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: GenSchemaSpy
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Re: GenSchemaSpy Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-29 20:52 ` Re: GenSchemaSpy Gogala, Mladen <gogala.mladen@gmail.com>
2021-12-30 09:15 ` Re: GenSchemaSpy Daulat <daulat.dba@gmail.com>
@ 2021-12-31 13:41 ` Gogala, Mladen <gogala.mladen@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Gogala, Mladen @ 2021-12-31 13:41 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
On 12/30/2021 4:15 AM, Daulat wrote:
> No.
> I am using an option -vizjs to avoid the requirement of GraphViz.
>
> See Example here:
>
> java -jar D:\schemaspy-6.1.0.jar -t pgsql -s rpt -db testdb -u
> postgres -p 2WS -host 10.25.0.222 -o D:\rpt -dp
> D:\postgresql-42.3.1.jar -vizjs
>
>
I see everything that I need to see here:
On 12/28/2021 12:58 PM, Daulat wrote:
> _*Cannot run program "dot": CreateProcess error=2*_, The system cannot
> find the file specified
> INFO - Graphviz rendered set to ''
Your jar file is looking for the program called "dot" which is a part of
the GraphViz package. That's all I need to know. You will have to
install GraphViz, a standard tool for directed graphs.
Regards
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2021-12-31 13:41 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-28 17:30 GenSchemaSpy Daulat <daulat.dba@gmail.com>
2021-12-28 17:36 ` Tim Clarke <tim.clarke@minerva.info>
2021-12-28 17:58 ` Daulat <daulat.dba@gmail.com>
2021-12-28 18:21 ` Tim Clarke <tim.clarke@minerva.info>
2021-12-28 18:33 ` João Gaspar <joao.f.r.gaspar@gmail.com>
2021-12-29 06:17 ` Daulat <daulat.dba@gmail.com>
2021-12-29 20:52 ` Gogala, Mladen <gogala.mladen@gmail.com>
2021-12-30 09:15 ` Daulat <daulat.dba@gmail.com>
2021-12-31 13:41 ` Gogala, Mladen <gogala.mladen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox