Problem
It's not explicitly stated in Spoke which Postgres versions are supported, but the cypress-tests.yaml and jest-tests.yaml files indicate that Spoke supports Postgres 10. Postgres 10 is no longer officially supported, and the final release was in November 2022 - link. When using newer versions of Postgres, such as Postgres 15, I run into this error when attempting to run Cypress tests: permission denied for schema public. I believe the error is related to this StackOverflow post.
Solution
Support Postgres versions 15+.
Problem
It's not explicitly stated in Spoke which Postgres versions are supported, but the
cypress-tests.yamlandjest-tests.yamlfiles indicate that Spoke supports Postgres 10. Postgres 10 is no longer officially supported, and the final release was in November 2022 - link. When using newer versions of Postgres, such as Postgres 15, I run into this error when attempting to run Cypress tests:permission denied for schema public. I believe the error is related to this StackOverflow post.Solution
Support Postgres versions 15+.