Postgres
Image: pgvector/pgvector:pg17
- Port 5432/tcp
- 10 GB volume at /var/lib/postgresql/data
- 1 vCPU · 1 GB
Template · Automation
Open-source Zapier alternative with PostgreSQL and Redis queues.
Opens the dashboard with this template pre-selected. Sign in with GitHub if you are new; the free tier needs no card.
3 services in the environment you pick, on the private network of the project.
ghcr.io/activepieces/activepieces:latest (app + worker in one container) + PostgreSQL + Redis.
Image: pgvector/pgvector:pg17
Image: redis:7-alpine
redis-server --appendonly yes --dir /data
Image: ghcr.io/activepieces/activepieces:latest
Generated secrets never leave the platform; references are resolved on the private network. Anything marked required is asked for at deploy time.
| Name | Value |
|---|---|
| POSTGRES_USER | postgresSuperuser name |
| POSTGRES_PASSWORD | generated (password)Generated at deploy |
| POSTGRES_DB | activepiecesDatabase created on first start |
| PGDATA | /var/lib/postgresql/data/pgdata |
| DATABASE_URL | postgresql://${{self.POSTGRES_USER}}:${{self.POSTGRES_PASSWORD}}@${{self.SKIFFLY_PRIVATE_DOMAIN}}:5432/${{self.POSTGRES_DB}}Connection string on the private network |
| Name | Value |
|---|---|
| REDIS_URL | redis://${{self.SKIFFLY_PRIVATE_DOMAIN}}:6379Private network only, no auth |
| Name | Value |
|---|---|
| AP_ENVIRONMENT | prod |
| AP_FRONTEND_URL | https://${{self.SKIFFLY_PUBLIC_DOMAIN}} |
| AP_ENCRYPTION_KEY | generated (hex32)32 hex characters |
| AP_JWT_SECRET | generated (secret) |
| AP_DB_TYPE | POSTGRES |
| AP_POSTGRES_HOST | ${{Postgres.SKIFFLY_PRIVATE_DOMAIN}} |
| AP_POSTGRES_PORT | 5432 |
| AP_POSTGRES_DATABASE | ${{Postgres.POSTGRES_DB}} |
| AP_POSTGRES_USERNAME | ${{Postgres.POSTGRES_USER}} |
| AP_POSTGRES_PASSWORD | ${{Postgres.POSTGRES_PASSWORD}} |
| AP_QUEUE_MODE | REDIS |
| AP_REDIS_HOST | ${{Redis.SKIFFLY_PRIVATE_DOMAIN}} |
| AP_REDIS_PORT | 6379 |
| AP_EXECUTION_MODE | UNSANDBOXED |
| AP_TELEMETRY_ENABLED | false |
Volumes, secrets and domain pre-wired. Runs on EU nodes, paid per minute from a prepaid balance.