Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n3IAQ-000103-0M for pgsql-admin@arkaria.postgresql.org; Fri, 31 Dec 2021 13:41:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3IAO-00072R-So for pgsql-admin@arkaria.postgresql.org; Fri, 31 Dec 2021 13:41:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n3IAO-00072I-GC for pgsql-admin@lists.postgresql.org; Fri, 31 Dec 2021 13:41:56 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n3IAM-0005MQ-0X for pgsql-admin@lists.postgresql.org; Fri, 31 Dec 2021 13:41:55 +0000 Received: by mail-wm1-x32a.google.com with SMTP id j140-20020a1c2392000000b003399ae48f58so17507941wmj.5 for ; Fri, 31 Dec 2021 05:41:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :cc:references:from:in-reply-to; bh=yxDKXOyzcA7PfMNsRlO66J26NF3d2KNrxHX1x8nCmP0=; b=YIxFBE7BXW+qUC9VGTudj6Ye+hBKjgiEzPLG0HyPlA5/lfSGvmCDKxW5hrjKO/Kose t2HePUBdV8sJMtqUxmsjofPZaF3+awB2ogdJT3vNf9seJSsm75ytp1GFFY0mdgcHa8jz qQE67ssiWOwZmntarUwuPFBwHM7Rep4S6gIGx2Mmk5iFSpUSFjnRvajuLhPkAIF8gml6 g90ni4WAFQn4NA/5RorpHRONateCYADDsdHzhYEDyLt6hHHUz7pbF+z+Iu2D72SS+7KK ufLCos+243n3zlHYp4TroKsG0PZz+8a/LG4s+uXC6yn+1P1mgxQBtzdZQDTJMJQbJAK0 bdvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:cc:references:from:in-reply-to; bh=yxDKXOyzcA7PfMNsRlO66J26NF3d2KNrxHX1x8nCmP0=; b=ctDKiDHxD4L0duvuG9jfJB64oaeDlP4a3uQ2JSP0GbjeYs+libVeZVZBaMrvXbJgPz LAPXuTTOACznW8uY6g3ycTWaJaKQVgZEWv20vchhvKNb5lqfddwJlt5ipAeUR+MbOzeD lCo/jfdkYcRXK/QZgYSaxdXf9PsO0axBPnaodXcHaGrM312Uwp0eYBjzb9B+Fgeh3ZOZ NXfck+6sAskotsKUge8X/FSFRsbGCVlv6XeUTP5OE5Npo7sbgU5+wzvXSTB9vIvNN6dV UcFxGp2oDCjIRge7MTDtkiQcROLGJAXPHbRaeeXjyvrbVWQg1DklgsiiURb14FOBfnrO +5Qw== X-Gm-Message-State: AOAM532tpGostI2yfJOi2+xir85/CfWwzSknj/yIHA3dr+9tdsWjhGYu RVZiTieAxddslOGEJIN6sXkuRNPU14w= X-Google-Smtp-Source: ABdhPJxvH1wGysOv2tq0KO8yxQ5aviCDRPdS+W96l3FuXyQAoKlb4dtn0IeCPXUdNqL53BwbRxJ0Sg== X-Received: by 2002:a05:600c:1c18:: with SMTP id j24mr30257940wms.189.1640958111600; Fri, 31 Dec 2021 05:41:51 -0800 (PST) Received: from ?IPV6:2a05:4f46:e06:2000:cfb:e6b2:dab0:4845? ([2a05:4f46:e06:2000:cfb:e6b2:dab0:4845]) by smtp.gmail.com with ESMTPSA id n1sm28533382wri.46.2021.12.31.05.41.49 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 31 Dec 2021 05:41:50 -0800 (PST) Content-Type: multipart/alternative; boundary="------------0w2qlh0lf6K5bZ0IfRT1tToO" Message-ID: <5b7f4e96-7fa5-b472-025d-870379d7f318@gmail.com> Date: Fri, 31 Dec 2021 08:41:50 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.4.1 Subject: Re: GenSchemaSpy Content-Language: en-US To: Daulat Cc: pgsql-admin References: <25818f73-7ba5-3b2f-d8da-e22e63f30ddc@gmail.com> From: "Gogala, Mladen" In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0w2qlh0lf6K5bZ0IfRT1tToO Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------0w2qlh0lf6K5bZ0IfRT1tToO Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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
--------------0w2qlh0lf6K5bZ0IfRT1tToO--