registry with postgres

[Phil gib]

hello i have compiled/started the registry with inmemory Config  . i checked it works well with  some Nifi 1.3.0 Examples calling the registry ...
So i try now to  persist my schema with the postgres config

I created a postgres DB ( schema_registry)
postgres-# \l
                                     List of databases
      Name       |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------------+----------+----------+-------------+-------------+-----------------------
 postgres        | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 schema_registry | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 

 but i got the following error when starting the  registry with postgres  config .....
ERROR [2017-07-04 14:23:28,431] com.hortonworks.registries.schemaregistry.webservice.SchemaRegistryResource: Encountered error while listing schemas
! org.postgresql.util.PSQLException: ERROR: relation "schema_metadata_info" does not exist
!   Position: 15
! at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
! at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
! at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
! at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)

pb of table creation inside my schema_registry DB  ?

best regards

[Satish Duggana]

Did you create required tables in schema_registry db?

 

You can look at the script located at https://github.com/hortonworks/registry/blob/master/bootstrap/sql/postgresql/create_tables.sql

 

Thanks,

Satish.

--
You received this message because you are subscribed to the Google Groups "Registry" group.
To unsubscribe from this group and stop receiving emails from it, send an email to registry+u...@googlegroups.com.
To post to this group, send email to regi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/registry/68c4622b-79f8-42c3-b537-32143a4a5c03%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Phil gib]

Thanks satish ..  i got it  and run the script . it works now
i can persist  my schemas in the registry

best regards
Phil