twentyhq / twenty

Building a modern alternative to Salesforce, powered by the community.
https://twenty.com
Other
17.59k stars 2.07k forks source link

[docker.io/twentycrm/twenty-postgres:latest]: extension "pg_graphql" is not available #8032

Open brdar opened 3 hours ago

brdar commented 3 hours ago

Bug Description

When selfhosting twentycrm i get error extension "pg_graphql" is not available. Im using twentycrm/twenty:latest docker image. and twentycrm/twenty-postgres:latest pg image.

Initial migration succeeds except pg_graphql extension. I guess binaries are missing in postgres image. How do you guys run it?

A clear and concise description of what the current behavior is. Please also add screenshots of the existing application.

query failed: CREATE EXTENSION IF NOT EXISTS "pg_graphql"
error: error: extension "pg_graphql" is not available
Failed to perform 'create extension pg_graphql': QueryFailedError: extension "pg_graphql" is not available

App starts but crashes when any GraphQl request is made.

brdar commented 2 hours ago

I've gone through all developer docs and could not find any mention of this issue. I wanted to ask for advice before building my image with "pg_graphql" extension binaries. Thank you