advantys/workflowgen-postgres repository overview

⁠WorkflowGen PostgreSQL 17 Database with pgvector

Production-ready PostgreSQL 17 database image for WorkflowGen v10+ with pgvector extension for AI and semantic search capabilities.

⁠✅ Production-Ready

Linux (Debian Bookworm), Windows Server 2022 LTSC, and Windows Server 2019 LTSC containers are fully supported for production use with WorkflowGen v10+.

This is currently the recommended production database for WorkflowGen v10 deployments.

⁠Key Features

• PostgreSQL 17 - Stable and mature open-source database
• pgvector - Native vector embeddings for AI/semantic search
• SCRAM-SHA-256 - Enhanced security authentication
• Supply chain integrity - SHA256 checksum verification of binaries
• Health monitoring - Built-in health checks with pg_isready
• Secure by default - Runs as non-admin user (wfgen_pguser)
• Pre-configured - WorkflowGen schema with 55 tables initialized automatically

⁠Quick Start

⁠Linux (Debian Bookworm)

Create a database.env file:

PGDATA=/var/lib/postgresql/data
POSTGRES_INITDB_ARGS=--username=postgres
POSTGRES_PASSWORD=yourStrong(!)Password
WFGEN_DATABASE_USER_PASSWORD=myDbPassword
WFGEN_ADMIN_PASSWORD=adminPassword

Run the container:

docker container run -d \
    --env-file ./database.env \
    --mount "type=volume,src=pgdata,dst=/var/lib/postgresql/data" \
    --name wfgen-postgres \
    -p 5432:5432 \
    advantys/workflowgen-postgres:10.4.0-postgres-debian-bookworm

⁠Windows (Server 2022 or Server 2019 LTSC)

Create a database.env file:

PGDATA=C:\pgsql\data
POSTGRES_INITDB_ARGS=--username=postgres
POSTGRES_PASSWORD=yourStrong(!)Password
WFGEN_DATABASE_USER_PASSWORD=myDbPassword
WFGEN_ADMIN_PASSWORD=adminPassword

Run the container:

docker container run -d `
    --env-file .\database.env `
    --mount "type=volume,src=pgdata,dst=C:\pgsql\data" `
    --name wfgen-postgres `
    -p 5432:5432 `
    advantys/workflowgen-postgres:10.4.0-postgres-win-ltsc2022

For Windows Server 2019, use advantys/workflowgen-postgres:10.4.0-postgres-win-ltsc2019.

⁠Wait for Initialization

docker logs -f wfgen-postgres
# Look for: "Workflowgen database is ready"

⁠Requirements

⁠Linux

• Docker Engine on any Linux distribution
• Minimum 2GB RAM (4GB+ recommended for production)
• Docker for Windows (with Linux containers mode) or Docker for Mac
• WorkflowGen v10.0+ application

⁠Windows

• On Windows 10 Pro or Enterprise, install Hyper-V and Docker Desktop, switch to Windows containers, and use an ltsc2019 image. Windows 10 does not support Windows Server 2022 container images.
• Use Windows 11 or Windows Server 2022 or later for ltsc2022 images. Consult Microsoft's Windows container version compatibility⁠ matrix when the host and container versions differ.
• On Windows Server, use the image tag matching the host version for process isolation. A newer compatible host can run an older image with Hyper-V isolation.
• WorkflowGen v10.0+ application

⁠Environment Variables

⁠Required

⁠Recommended Values for PGDATA and POSTGRES_INITDB_ARGS

Linux:

PGDATA=/var/lib/postgresql/data
POSTGRES_INITDB_ARGS=--username=postgres

Windows:

PGDATA=C:\pgsql\data
POSTGRES_INITDB_ARGS=--username=postgres

⁠Optional

Note: All environment variables support the _FILE suffix for Docker Secrets integration.

⁠Volumes

⁠Linux

Mount /var/lib/postgresql/data to persist your PostgreSQL database:

# Named volume (recommended)
--mount "type=volume,src=pgdata,dst=/var/lib/postgresql/data"

# Or bind mount (if you need direct host access)
--mount "type=bind,src=/path/to/data,dst=/var/lib/postgresql/data"

⁠Windows

Mount C:\pgsql\data to persist your PostgreSQL database:

# Named volume (recommended)
--mount "type=volume,src=pgdata,dst=C:\pgsql\data"

# Or bind mount (if you need direct host access)
--mount "type=bind,src=C:\path\to\data,dst=C:\pgsql\data"

⁠Ports

• 5432 - PostgreSQL server port

⁠Connection String

For WorkflowGen application configuration:

Host=wfgen-postgres;Port=5432;Database=wfgen;Username=wfgen_user;Password=<password>

⁠Health Check

The container includes built-in health monitoring:

docker inspect --format='{{.State.Health.Status}}' wfgen-postgres

Status will be healthy when PostgreSQL is running and the WorkflowGen database is accessible.

⁠pgvector Extension

The pgvector extension is pre-installed and automatically enabled in the WorkflowGen database during initialization.

Verify pgvector is available:

docker exec wfgen-postgres pwsh -Command "& psql -U postgres -d wfgen -c 'SELECT * FROM pg_extension WHERE extname = ''vector'';'"

This extension enables WorkflowGen v10+ AI features including:

• Semantic search capabilities
• Vector embeddings storage
• Similarity search operations

⁠Supported Tags

Linux:

• latest-linux - Latest stable Linux release; points to 10.4.0-postgres-debian-bookworm
• 10.4.0-postgres-debian-bookworm - WorkflowGen v10.4.0 for Linux (Debian Bookworm)

Windows:

• latest-win-ltsc2022 - Latest stable Windows Server 2022 release
• latest-win-ltsc2019 - Latest stable Windows Server 2019 release
• postgres-latest - Compatibility alias for latest-win-ltsc2019
• 10.4.0-postgres-win-ltsc2022 - WorkflowGen v10.4.0 for Windows Server 2022 LTSC
• 10.4.0-postgres-win-ltsc2019 - WorkflowGen v10.4.0 for Windows Server 2019 LTSC

The repository does not publish a plain latest tag. Select a platform-specific floating tag or, preferably, an explicit version and platform tag.

⁠Platform Support

⁠Secrets Management

For production deployments, use Docker Secrets or Kubernetes Secrets by appending _FILE to environment variable names:

⁠Docker Secrets Example (Linux)

# Create secrets
echo "yourStrong(!)Password" | docker secret create postgres_password -
echo "myDbPassword" | docker secret create wfgen_db_password -
echo "adminPassword" | docker secret create wfgen_admin_password -

# Create service with secrets
docker service create \
    --name wfgen-postgres \
    --secret postgres_password \
    --secret wfgen_db_password \
    --secret wfgen_admin_password \
    -e POSTGRES_PASSWORD_FILE=/run/secrets/postgres_password \
    -e WFGEN_DATABASE_USER_PASSWORD_FILE=/run/secrets/wfgen_db_password \
    -e WFGEN_ADMIN_PASSWORD_FILE=/run/secrets/wfgen_admin_password \
    advantys/workflowgen-postgres:10.4.0-postgres-debian-bookworm

⁠Docker Secrets Example (Windows)

# Create secrets
"yourStrong(!)Password" | docker secret create postgres_password -
"myDbPassword" | docker secret create wfgen_db_password -
"adminPassword" | docker secret create wfgen_admin_password -

# Create service with secrets
docker service create `
    --name wfgen-postgres `
    --secret postgres_password `
    --secret wfgen_db_password `
    --secret wfgen_admin_password `
    -e POSTGRES_PASSWORD_FILE=C:\ProgramData\Docker\secrets\postgres_password `
    -e WFGEN_DATABASE_USER_PASSWORD_FILE=C:\ProgramData\Docker\secrets\wfgen_db_password `
    -e WFGEN_ADMIN_PASSWORD_FILE=C:\ProgramData\Docker\secrets\wfgen_admin_password `
    advantys/workflowgen-postgres:10.4.0-postgres-win-ltsc2022

⁠Why Choose PostgreSQL for WorkflowGen v10?

⁠Open Source & Cost-Effective

• No per-core licensing or CAL costs
• Community-driven innovation
• Lower total cost of ownership

⁠Modern Features

• pgvector for AI and semantic search
• Advanced JSON/JSONB support
• Robust full-text search
• Mature replication and high availability

⁠Production-Ready Now

• PostgreSQL 17 is stable and battle-tested
• 25+ years of proven reliability
• ACID compliance
• Enterprise-grade performance

⁠Optimized for WorkflowGen

• Pre-configured schema with all required tables
• Tuned for workflow and BPM workloads
• Comprehensive monitoring and health checks
• Secure by default with best practices

⁠Troubleshooting

⁠View Logs

docker logs wfgen-postgres

⁠Access PostgreSQL Shell

Using PowerShell (works on both Linux and Windows):

docker exec -it wfgen-postgres pwsh -Command "& psql -U postgres -d wfgen"

Using bash (Linux only):

docker exec -it wfgen-postgres bash -c "psql -U postgres -d wfgen"

⁠Check Database Initialization

# Verify tables were created
docker exec wfgen-postgres pwsh -Command "& psql -U postgres -d wfgen -c 'SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ''public'';'"
# Should return: 55

⁠Verify Admin User

docker exec wfgen-postgres pwsh -Command "& psql -U postgres -d wfgen -c 'SELECT USERNAME FROM USERS WHERE ID_USER = 1;'"

⁠Documentation

• WorkflowGen Docker Guide: https://docs.workflowgen.com/docker⁠
• WorkflowGen Documentation: https://docs.workflowgen.com/⁠
• PostgreSQL 17 Docs: https://www.postgresql.org/docs/17/⁠
• pgvector Extension: https://github.com/pgvector/pgvector⁠
• WorkflowGen Website: https://www.workflowgen.com/⁠

⁠Support

For technical support and questions:

• WorkflowGen Website: https://www.workflowgen.com/⁠
• Documentation: https://docs.workflowgen.com/⁠
• Technical Support: Contact Advantys support team

⁠License

This image includes:

• PostgreSQL (PostgreSQL License)
• pgvector (PostgreSQL License)
• WorkflowGen schema and configuration (Advantys)

See the WorkflowGen EULA for terms of use.