Hello team I m deploying SpiceDb
# spicedbc
claraisrael
06/27/2023, 1:09 PMHello team, I'm deploying SpiceDb Operator to K8s. Using postgres as my datastore engine. Is there a way to automate postgres migrations? I cant seem to find documentation. Any help is greatly appreciated! Thanks
v
vroldanbet
06/27/2023, 1:16 PMHey @claraisrael 👋 The operator should handle migrations automatically for you!
vroldanbet
06/27/2023, 1:16 PMas soon as you change the target version, the operator knows it should run
migratec
claraisrael
06/27/2023, 1:17 PMThe operators runs the migrate head command automatically ?
v
vroldanbet
06/27/2023, 1:17 PMyup!
c
claraisrael
06/27/2023, 1:17 PMAhh. When I tested out my postgres connection (w Tableplus) , the tables weren't populated
v
vroldanbet
06/27/2023, 1:19 PMweird, that should definitely not be the case
vroldanbet
06/27/2023, 1:19 PMhow did you use the operator? Did you create a
SpiceDBClustervroldanbet
06/27/2023, 1:19 PMWe have some docs here btw https://authzed.com/docs/spicedb/operator
c
claraisrael
06/27/2023, 1:19 PMYep I followed those.
v
vroldanbet
06/27/2023, 1:20 PMinteresting, that's definitely not expected. If the operator spins up a cluster, the first thing it does is run migrate, and it that does not succeed, it will set the status field of the
SpiceDBClusterc
claraisrael
06/27/2023, 1:21 PMI pointed to the correct postgres DB with the flags datastore uri and engine
v
vroldanbet
06/27/2023, 1:21 PMand did you see any status in the CR?
vroldanbet
06/27/2023, 1:22 PMif no tables showed up, it's possible something was misconfigured
c
claraisrael
06/27/2023, 1:22 PMOk. Let me look more into it! I'll ping you if I fix it or if I get stuck. Thanks!
v
vroldanbet
06/27/2023, 1:23 PMyeah when you use the operator, always have a look at the status field of the
SpiceDBClusterc
claraisrael
06/27/2023, 1:41 PMFixed! Thanks
2 Views