Files
twenty/packages/twenty-postgres/linux/build_postgres.md
martmull e2af5b8628 4525 upgrade pg graphql (#4646)
* TO remove: add multiple workspace with command

* TO remove: update build script

* Update script and add doc

* TO remove: add more seed workspaces

* Build pg_graphql files for 1.5.1

* Build pg_graphql files for 1.5.1 macos arm

* Remove 600 seed workspaces

* Build pg_graphql files for 1.5.1 macos intel
2024-03-25 15:08:17 +01:00

1002 B

This doc explains how to build postgresql for Twenty

Build .control, .so and .pg_graphql--version.sql

docker buildx create --name mybuilder docker buildx use mybuilder

Do the same for in ['amd64', 'arm64'] ('amd64' builds faster)

cd packages/twenty-postgres docker buildx build --platform linux/ --load -t twenty-bitnami-postgres- linux docker run --name twenty-bitnami- -v ~/Desktop/twenty/packages/twenty-postgres:/twenty <IMAGE_TAG>

In another terminal

docker exec -it <CONTAINER_TAG> sh sh twenty/linux/build-postgres-linux.sh cp opt/bitnami/postgresql/lib/pg_graphql.so twenty/linux//15/pg_graphql/<PG_GRAPHQL_VERSION> cp opt/bitnami/postgresql/share/extension/pg_graphql.control twenty/linux//15/pg_graphql/<PG_GRAPHQL_VERSION> cp opt/bitnami/postgresql/share/extension/pg_graphql--<PG_GRAPHQL_VERSION>.sql twenty/linux//15/pg_graphql/<PG_GRAPHQL_VERSION>

Then

prod-server-build prod-server-run