Skip to content

Instantly share code, notes, and snippets.

@jeevanullas
Created April 1, 2015 11:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeevanullas/1b689a5f00adf39ec2eb to your computer and use it in GitHub Desktop.
Save jeevanullas/1b689a5f00adf39ec2eb to your computer and use it in GitHub Desktop.
Schemaspy Output
java -jar schemaSpy_5.0.0.jar -t pgsql -db eucalyptus_shared -host 127.0.0.1:8777 -u eucalyptus -p a30975d9cae09908c5ca3b8b7332ed6876b030d3a20a70cc8fd21602994597b7 -connprops "ssl\=true;sslfactory\=org.postgresql.ssl.NonValidatingFactory" -all -o ./schemaspy -dp postgresql-9.4-1201.jdbc4.jar -s public -noads
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Analyzing schemas that match regular expression '.*':
(use -schemaSpec on command line or in .properties to exclude other schemas)
eucalyptus_auth eucalyptus_autoscaling eucalyptus_cloud eucalyptus_cloudformation eucalyptus_cloudwatch eucalyptus_cloudwatch_backend eucalyptus_config eucalyptus_dns eucalyptus_faults eucalyptus_general eucalyptus_imaging eucalyptus_loadbalancing eucalyptus_osg eucalyptus_records eucalyptus_reporting eucalyptus_reporting_backend eucalyptus_simpleworkflow eucalyptus_storage eucalyptus_walrus information_schema pg_catalog
Analyzing eucalyptus_auth
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details......................(2sec)
Writing/graphing summary............(1sec)
Writing/diagramming details...................(4sec)
Wrote relationship details of 19 tables/views to directory './schemaspy/eucalyptus_auth' in 7 seconds.
View the results by opening ./schemaspy/eucalyptus_auth/index.html
Analyzing eucalyptus_autoscaling
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.....................(1sec)
Writing/graphing summary............(1sec)
Writing/diagramming details..................(6sec)
Wrote relationship details of 18 tables/views to directory './schemaspy/eucalyptus_autoscaling' in 9 seconds.
View the results by opening ./schemaspy/eucalyptus_autoscaling/index.html
Analyzing eucalyptus_cloud
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...........................................................(4sec)
Writing/graphing summary............(4sec)
Writing/diagramming details........................................................(33sec)
Wrote relationship details of 56 tables/views to directory './schemaspy/eucalyptus_cloud' in 42 seconds.
View the results by opening ./schemaspy/eucalyptus_cloud/index.html
Analyzing eucalyptus_cloudformation
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.......(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details....(0sec)
Wrote relationship details of 4 tables/views to directory './schemaspy/eucalyptus_cloudformation' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_cloudformaAnalyzing eucalyptus_cloudwatch
tion/index.html
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details......(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details...(0sec)
Wrote relationship details of 3 tables/views to directory './schemaspy/eucalyptus_cloudwatch' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_cloudwatch/index.html
Analyzing eucalyptus_cloudwatch_backend
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.....................................(3sec)
Writing/graphing summary.........(1sec)
Writing/diagramming details..................................(0sec)
Wrote relationship details of 34 tables/views to directory './schemaspy/eucalyptus_cloudwatch_backend' in 5 seconds.
View the results by opening ./schemaspy/eucalyptus_cloudwatch_backend/index.html
Analyzing eucalyptus_config
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.........(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details......(0sec)
Wrote relationship details of 6 tables/views to directory './schemaspy/eucalyptus_config' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_config/index.html
Analyzing eucalyptus_dns
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details..........(0sec)
Writing/graphing summary............(0sec)
Writing/diagramming details.......(0sec)
Wrote relationship details of 7 tables/views to directory './schemaspy/eucalyptus_dns' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_dns/index.html
Analyzing eucalyptus_faults
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details....(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details.(0sec)
Wrote relationship details of 1 tables/views to directory './schemaspy/eucalyptus_faults' in 0 seconds.
View the results by opening ./schemaspy/eucalyptus_faults/index.html
Analyzing eucalyptus_general
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details....(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details.(0sec)
Wrote relationship details of 1 tables/views to directory './schemaspy/eucalyptus_general' in 0 seconds.
View the results by opening ./schemaspy/eucalyptus_general/index.html
Analyzing eucalyptus_imaging
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details........(0sec)
Writing/graphing summary..............(0sec)
Writing/diagramming details.....(1sec)
Wrote relationship details of 5 tables/views to directory './schemaspy/eucalyptus_imaging' in 3 seconds.
View the results by opening ./schemaspy/eucalyptus_imaging/index.html
Analyzing eucalyptus_loadbalancing
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details..................(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details...............(5sec)
Wrote relationship details of 15 tables/views to directory './schemaspy/eucalyptus_loadbalancing' in 7 seconds.
View the results by opening ./schemaspy/eucalyptus_loadbalancing/index.html
Analyzing eucalyptus_osg
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.............(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details..........(0sec)
Wrote relationship details of 10 tables/views to directory './schemaspy/eucalyptus_osg' in 2 seconds.
View the results by opening ./schemaspy/eucalyptus_osg/index.html
Analyzing eucalyptus_records
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.....(0sec)
Writing/graphing summary...........(0sec)
Writing/diagramming details..(0sec)
Wrote relationship details of 2 tables/views to directory './schemaspy/eucalyptus_records' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_records/index.html
Analyzing eucalyptus_reporting
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.....(0sec)
Writing/graphing summary...........(0sec)
Writing/diagramming details..(0sec)
Wrote relationship details of 2 tables/views to directory './schemaspy/eucalyptus_reporting' in 0 seconds.
View the results by opening ./schemaspy/eucalyptus_reporting/index.html
Analyzing eucalyptus_reporting_backend
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details.................(1sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details..............(0sec)
Wrote relationship details of 14 tables/views to directory './schemaspy/eucalyptus_reporting_backend' in 1 seconds.
View the results by opening ./schemaspy/eucalyptus_reporting_backend/index.html
Analyzing eucalyptus_simpleworkflow
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...........(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details........(4sec)
Wrote relationship details of 8 tables/views to directory './schemaspy/eucalyptus_simpleworkflow' in 6 seconds.
View the results by opening ./schemaspy/eucalyptus_simpleworkflow/index.html
Analyzing eucalyptus_storage
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details....................(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details.................(0sec)
Wrote relationship details of 17 tables/views to directory './schemaspy/eucalyptus_storage' in 2 seconds.
View the results by opening ./schemaspy/eucalyptus_storage/index.html
Analyzing eucalyptus_walrus
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details..................(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details...............(1sec)
Wrote relationship details of 15 tables/views to directory './schemaspy/eucalyptus_walrus' in 3 seconds.
View the results by opening ./schemaspy/eucalyptus_walrus/index.html
Analyzing information_schema
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...
No tables or views were found in schema 'information_schema'.
The schema exists in the database, but the user you specified (eucalyptus)
might not have rights to read its contents.
Another possibility is that the regular expression that you specified
for what to include (via -i) didn't match any tables.
22 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
eucalyptus_auth eucalyptus_autoscaling eucalyptus_cloud eucalyptus_cloudformation eucalyptus_cloudwatch eucalyptus_cloudwatch_backend eucalyptus_config eucalyptus_dns eucalyptus_faults eucalyptus_general eucalyptus_imaging eucalyptus_loadbalancing eucalyptus_osg eucalyptus_records eucalyptus_reporting eucalyptus_reporting_backend eucalyptus_simpleworkflow eucalyptus_storage eucalyptus_walrus information_schema pg_catalog public
These schemas contain tables/views that user 'eucalyptus' can see:
eucalyptus_auth eucalyptus_autoscaling eucalyptus_cloud eucalyptus_cloudformation eucalyptus_cloudwatch eucalyptus_cloudwatch_backend eucalyptus_config eucalyptus_dns eucalyptus_faults eucalyptus_general eucalyptus_imaging eucalyptus_loadbalancing eucalyptus_osg eucalyptus_records eucalyptus_reporting eucalyptus_reporting_backend eucalyptus_simpleworkflow eucalyptus_storage eucalyptus_walrus information_schema pg_catalog(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details(0sec)
Wrote relationship details of 0 tables/views to directory './schemaspy/information_schema' in 0 seconds.
View the results by opening ./schemaspy/information_schema/index.html
Analyzing pg_catalog
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...
No tables or views were found in schema 'pg_catalog'.
The schema exists in the database, but the user you specified (eucalyptus)
might not have rights to read its contents.
Another possibility is that the regular expression that you specified
for what to include (via -i) didn't match any tables.
22 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
eucalyptus_auth eucalyptus_autoscaling eucalyptus_cloud eucalyptus_cloudformation eucalyptus_cloudwatch eucalyptus_cloudwatch_backend eucalyptus_config eucalyptus_dns eucalyptus_faults eucalyptus_general eucalyptus_imaging eucalyptus_loadbalancing eucalyptus_osg eucalyptus_records eucalyptus_reporting eucalyptus_reporting_backend eucalyptus_simpleworkflow eucalyptus_storage eucalyptus_walrus information_schema pg_catalog public
These schemas contain tables/views that user 'eucalyptus' can see:
eucalyptus_auth eucalyptus_autoscaling eucalyptus_cloud eucalyptus_cloudformation eucalyptus_cloudwatch eucalyptus_cloudwatch_backend eucalyptus_config eucalyptus_dns eucalyptus_faults eucalyptus_general eucalyptus_imaging eucalyptus_loadbalancing eucalyptus_osg eucalyptus_records eucalyptus_reporting eucalyptus_reporting_backend eucalyptus_simpleworkflow eucalyptus_storage eucalyptus_walrus information_schema pg_catalog(0sec)
Writing/graphing summary.........(0sec)
Writing/diagramming details(0sec)
Wrote relationship details of 0 tables/views to directory './schemaspy/pg_catalog' in 0 seconds.
View the results by opening ./schemaspy/pg_catalog/index.html
Wrote relationship details of 21 schemas in 103 seconds.
Start with ./schemaspy/index.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment