testing EE PR preview app (#12851)

adishM98 · web-flow · commit 6d7733c9dac3 · 2025-05-12T16:16:51.000+05:30
* testing PR app on render preview * fix volume issue on ee pr app * fix postgresql.conf issue * fix postgresql.conf issue * fix postgresql.conf issue (#12856)
diff --git a/.github/workflows/render-preview-deploy.yml b/.github/workflows/render-preview-deploy.yml
@@ -542,7 +542,7 @@ jobs:
             "serviceDetails": {
               "disk": {
                 "name": "tooljet-ee-pr-${{ env.PR_NUMBER }}-postgresql",
-                "mountPath": "/data",
+                "mountPath": "/var/lib/postgresql/13/main",
                 "sizeGB": 10
               },
               "env": "docker",
diff --git a/docker/ce-preview.Dockerfile b/docker/ce-preview.Dockerfile
@@ -83,7 +83,7 @@ RUN apt update && apt -y install postgresql-13 postgresql-client-13 supervisor
 RUN mkdir -p /var/log/supervisor /var/run/postgresql && \
     chown -R postgres:postgres /var/run/postgresql /var/log/supervisor
 
-# Explicitly create PG main directory with correct ownership
+# Explicitly create PG main directory with correct ownerships
 RUN mkdir -p /var/lib/postgresql/13/main && \
     chown -R postgres:postgres /var/lib/postgresql
 
diff --git a/docker/ee/ee-preview.Dockerfile b/docker/ee/ee-preview.Dockerfile
@@ -9,7 +9,7 @@ WORKDIR /app
 ARG CUSTOM_GITHUB_TOKEN
 ARG BRANCH_NAME
 
-# Clone and checkout the frontend repository
+# Clone and checkout the frontend repositorys
 RUN git config --global url."https://x-access-token:${CUSTOM_GITHUB_TOKEN}@github.com/".insteadOf "https://github.com/"
 
 RUN git config --global http.version HTTP/1.1
@@ -109,6 +109,14 @@ RUN wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-k
 RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main" | tee /etc/apt/sources.list.d/pgdg.list
 RUN apt update && apt -y install postgresql-13 postgresql-client-13 supervisor --fix-missing
 
+
+# Explicitly create PG main directory with correct ownership
+RUN mkdir -p /var/lib/postgresql/13/main && \
+    chown -R postgres:postgres /var/lib/postgresql
+
+RUN mkdir -p /var/log/supervisor /var/run/postgresql && \
+    chown -R postgres:postgres /var/run/postgresql /var/log/supervisor
+
 # Remove existing data and create directory with proper ownership
 RUN rm -rf /var/lib/postgresql/13/main && \
     mkdir -p /var/lib/postgresql/13/main && \
