Hi! 👋 I'm trying to set up datomic with Postgres, and I believe I set up everything correctly, but when I start my system datomic fails with the following error:

Terminating process - Lifecycle thread failed
java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: ERROR: relation "datomic_kvs" does not exist
  Position: 31
       at java.util.concurrent.FutureTask.report(FutureTask.java:122)
       at java.util.concurrent.FutureTask.get(FutureTask.java:192)
       at clojure.core$deref_future.invokeStatic(core.clj:2304)
       at clojure.core$future_call$reify__8477.deref(core.clj:6976)
       at clojure.core$deref.invokeStatic(core.clj:2324)
       at clojure.core$deref.invoke(core.clj:2310)
       at datomic.lifecycle_ext$standby_loop.invokeStatic(lifecycle_ext.clj:42)
       at datomic.lifecycle_ext$standby_loop.invoke(lifecycle_ext.clj:40)
       at clojure.lang.Var.invoke(Var.java:384)
       at datomic.lifecycle$start$fn__3330.invoke(lifecycle.clj:73)
       at clojure.lang.AFn.run(AFn.java:22)
       at java.lang.Thread.run(Thread.java:750)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "datomic_kvs" does not exist

postgres@629dc6959e77:/$ psql
psql (15.0 (Debian 15.0-1.pgdg110+1))
Type "help" for help.

postgres=# SELECT * FROM datomic_kvs
postgres-# \dt
            List of relations
 Schema |    Name     | Type  |  Owner   
--------+-------------+-------+----------
 public | datomic_kvs | table | postgres
(1 row)

doublecheck your connection string

Seems to be correct :thinking_face: But after investigating a bit more, I realized psql doesn't show the table when I run with the datomic user, so the problem seems to be there.

there you go

Yes, but, I don't know what extra permissions I'm supposed to give it. I'm just running the provided init scripts which seem to grant the right access on the tables.

I'm not sure if there's a recommended postgresql version to use with datomic, I have the feeling picking latest (15.0) may not have been the best choice here

Looks like I was able to get some progress. The table was not being created inside the datomic database due to how I was running the initialization scripts. Unfortunately, there are more issues 😩

I set up my code to use the following uri to connect to datomic: datomic:<POSTGRES-HOST>:5432/datomic?user=datomic&password=<PASSWORD> (where <POSTGRES-HOST> and <PASSWORD> are redacted for obvious reasons, but have correct values). When doing that, I'm getting this error: > ActiveMQNotConnectedException[errorType=NOT_CONNECTED message=AMQ219007: Cannot connect to server(s). Tried with all available servers.]

does that ring any bells?