pgpm-docker（pgpm Docker 部署）

PGPM Docker

Manage PostgreSQL Docker containers for local development using the pgpm docker command.

When to Apply

Use this skill when:

• Setting up a local PostgreSQL database for development
• Starting or stopping PostgreSQL containers
• Recreating a fresh database container
• User asks to run tests that need a database
• Troubleshooting database connection issues

Quick Start

Start PostgreSQL Container

pgpm docker start

This starts a PostgreSQL 17 container with default settings:

• Container name: postgres
• Port: 5432
• User: postgres
• Password: password

Start with Custom Options

pgpm docker start --port 5433 --name my-postgres

Recreate Container (Fresh Database)

pgpm docker start --recreate

Stop Container

pgpm docker stop

Command Reference

pgpm docker start

Start a PostgreSQL Docker container.

pgpm docker stop

Stop a running PostgreSQL container.

Common Workflows

Development Setup

# Start fresh database
pgpm docker start --recreate

# Load environment variables
eval "$(pgpm env)"

# Deploy your PGPM modules
pgpm deploy

Running Tests

# Ensure database is running
pgpm docker start

# Run tests with environment
pgpm env pnpm test

Multiple Databases

# Start main database on default port
pgpm docker start --name main-db

# Start test database on different port
pgpm docker start --name test-db --port 5433

PostgreSQL Version

The default image pyramation/postgres:17 includes PostgreSQL 17 which is required for:

• security_invoker views
• Latest PostgreSQL features used by Constructive

If you see errors like "unrecognized parameter security_invoker", ensure you're using PostgreSQL 17+.

Troubleshooting

Environment Variables

After starting the container, use pgpm env to set up environment variables:

eval "$(pgpm env)"

This sets:

• PGHOST=localhost
• PGPORT=5432
• PGUSER=postgres
• PGPASSWORD=password
• PGDATABASE=postgres

References

For related skills:

• Environment management: See pgpm-env skill
• Running tests: See pgpm-testing skill