docs: ECS - Specify sslmode=disable on DB url (windmill-labs#468)

gbouv · web-flow · commit cdceb6045a1b · 2024-01-12T20:32:25.000+01:00
diff --git a/docs/advanced/1_self_host/aws_ecs.mdx b/docs/advanced/1_self_host/aws_ecs.mdx
@@ -163,7 +163,7 @@ We will create 6 tasks definitions here:
    - Essential container: YES
    - Port mapping: 8000 / TCP / http / HTTP
    - Resource allocation: 1 CPU / 1.5 GiB memory
-   - Environment variable: `JSON_FMT=true`, `MODE=server` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill`. Replace the hostname and password with the ones from the RDS database your created above
+   - Environment variable: `JSON_FMT=true`, `MODE=server` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable`. Replace the hostname and password with the ones from the RDS database your created above
    - Turn on log collection for easy debugging
    - Add the following health check: `CMD-SHELL, curl -f http://localhost:8000/api/version || exit 1` - Interval: `10s` - Timeout: `5s` - Retries: `5`
    - Leave the rest default
@@ -198,7 +198,7 @@ The following fields needs to be set manually: `LATEST_RELEASE`, `DB_PASSWORD`,
 				},
 				{
 					"name": "DATABASE_URL",
-					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill"
+					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable"
 				},
 				{
 					"name": "MODE",
@@ -258,7 +258,7 @@ The following fields needs to be set manually: `LATEST_RELEASE`, `DB_PASSWORD`,
    - Essential container: YES
    - Port mapping: No port mapping for workers
    - Resource allocation: 2 CPU / 3.5 GiB memory
-   - Environment variable: `JSON_FMT=true`, `MODE=worker`, `WORKER_GROUP=default` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill`
+   - Environment variable: `JSON_FMT=true`, `MODE=worker`, `WORKER_GROUP=default` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable`
    - Add a Bind volume named `worker_dependency_cache` mapped to `/tmp/windmill/cache`
    - Turn on log collection for easy debugging
    - This is it, leave the rest default
@@ -281,7 +281,7 @@ The following fields needs to be set manually: `LATEST_RELEASE`, `DB_PASSWORD`,
 			"environment": [
 				{
 					"name": "DATABASE_URL",
-					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill"
+					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable"
 				},
 				{
 					"name": "JSON_FMT",
@@ -350,7 +350,7 @@ The following fields needs to be set manually: `LATEST_RELEASE`, `DB_PASSWORD`,
    - Essential container: YES
    - Port mapping: no port mapping for workers
    - Resource allocation: 2 CPU / 3.5 GiB memory
-   - Environment variable: `JSON_FMT=true`, `MODE=worker`, `WORKER_GROUP=native` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill`
+   - Environment variable: `JSON_FMT=true`, `MODE=worker`, `WORKER_GROUP=native` and `DATABASE_URL=postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable`
    - Add a Bind volume named `worker_dependency_cache` mapped to `/tmp/windmill/cache`
    - Turn on log collection for easy debugging
    - This is it, leave the rest default
@@ -373,7 +373,7 @@ The following fields needs to be set manually: `LATEST_RELEASE`, `DB_PASSWORD`,
 			"environment": [
 				{
 					"name": "DATABASE_URL",
-					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill"
+					"value": "postgres://postgres:<DB_PASSWORD>@<DB_HOSTNAME>:5432/windmill?sslmode=disable"
 				},
 				{
 					"name": "JSON_FMT",
